Job Information
Plymouth Rock Management Company of New Jersey Senior Marketing Data Analyst in Woodbridge, New Jersey
DUTIES: Position will leverage expertise in Data Methodologies to create, maintain, and enhance internal datasets for Reporting, Analysis and Dashboard creation based on business requirements, using approved technologies and coding standards. Monitor and optimize data processes to ensure best performance. Document code appropriately for maintainability. Communicate with product owners and business analysts to gather accurate specifications for enhancements to existing data processes or the creation of new ones and assist with work estimations based on business requirements. Translate requirements and use cases into data process flows and functional code, utilizing source control software to maintain historical versioning. Maintain and optimize the data flow that feeds Marketing data into our Email Service Provider (ESP). Create and maintain visual dashboard reporting on Marketing performance metrics, allowing the Marketing Group to gain insights on campaign performance and opportunities. Implement API/ETL data solutions for the Marketing Group to be used in reporting and analytics, providing future support and scalability. Perform functionality and code reviews and help maintain code quality, performance, and Dashboard/Process responsiveness with a complete understanding of full SDLC and object-oriented programming concepts, as well as Agile programming methodology.REQUIREMENTS: Position requires a Master's degree (or foreign equivalent) in Software Engineering, Computer Science, Information Systems or related field plus two (2) years of experience in the job offered or in a Senior Marketing Data Analyst-related occupation and experience in Database, Report/Dashboard, and ETL/API design and development. Or, alternatively, a Bachelor's degree (or foreign equivalent) in Software Engineering, Computer Science, Information Systems or related field plus five (5) years of experience in the job offered or in a Senior Marketing Data Analyst-related occupation and experience in Database, Report/Dashboard, and ETL/API design and development. Experience must include the following: •Demonstrable expertise creating, documenting, debugging, and implementing SQL Server database objects including tables, view, functions, scripts, stored procedures, indexes, and triggers, as well as overseeing general database health, data integrity, and proactively handling errors; •Demonstrable expertise utilizing programming languages: SQL, DB2, Python and Visual Studio; •Demonstrated expertise designing and developing ETL/API processes using SQL Server Integration Services (SSIS) or Python to extract data from data formats (JSON, HTML, XML, and Flat-File (CSV or PSV)); •Demonstrated expertise with data warehousing and process designs, including but not limited to historical, strategic, marketing, and operational data; •Demonstrated expertise in designing front-end Dashboard Visuals and developing back-end Data Processes to support key business stakeholders; and,•Demonstrated expertise performing object oriented (OO) design and analysis of design principles.CONTACT: To apply please email resume clearly referencing Job Code 21765.47 to recruit@plymouthrock.com