Lead Data Engineer

About Annalect

Annalect is the Data & Technology arm of Omnicom Media Group. Annalect’s 4,000+ innovators leverage data and technology to help clients across Omnicom build relationships that matter – whether that means fostering consumers’ trust in brands, building new experiences, or delivering advanced analytics where it’s most needed. Annalect is the driving force behind Omni, Omnicom’s unique open operating system, which works hand-in-hand with clients’ and partners’ data and tools, to orchestrate better marketing outcomes.

Annalect’s unique approach to data and technology – one that relies on transparency, neutrality, and interoperability – allows us to deliver purpose-built and scalable solutions that make data actionable. Our advanced teams of product leaders, data scientists, consultants, and engineers enable us to meet the business goals of our internal and external clients.

Lead Data Engineer (OMD USA LLC d/b/a Annalect Group, New York, NY) Produce accurate information within database objects used in reporting, strategic planning and decision making to directly impact the growth of the enterprise data warehouse (“EDW”);
Collaborate with the Senior Director of Data Engineering in developing long-term strategies and capacity planning for meeting future data warehouse and data automation needs;
Meet with end-users and data SMEs to identify and clarify requirements and business rules needed to design, develop and implement ETL/ELT processes;
Collaborate with peer Data Engineers to build upon and support the company’s Continuous Integration/Continuous Delivery (“CI/CD”) pipelines;
Use strong communication skills (written and verbal) to mentor emerging Data Analysts, including providing feedback and suggestions for their planned workflows prior to deployment into production;
Respond, investigate and correct reported data inaccuracies within the EDW compared to source and business-expected results;
Establish relationships with external and internal points of contact to ensure seamless inbound and outbound Data Delivery expectations are met;
Implement and support backend maintenance processes that enforce ongoing data optimization and corporate retention policies while ensuring the historical data needs of the client are met;
Document and maintain all the processes and procedures pertaining to ETL and data warehouse usage and development, contributing to the team knowledgebase when applicable;
Build products which sit atop cloud-based data infrastructure. Participate in technical architecture, design and development of software products as well as research and evaluation of new technical solutions;
Participate in architecture and strategy discussions with stake holders;
Create architecture diagrams and provide input to Delivery Managers on milestones and deliverables. Accountable for completion of projects on time, ensuring best practices are followed in the SDLC;
Meet with end-users and data SMEs to identify and clarify requirements and business rules needed to design, develop and implement ETL/ELT processes;
Use strong communication skills (written and verbal) to mentor emerging Data Analysts, including providing feedback and suggestions for their planned workflows prior to deployment into production;
Collaborate with the Senior Director of Data Engineering in developing long-term strategies and capacity planning for meeting future data warehouse and data automation needs; and Meet with end-users and data SMEs to identify and clarify requirements and business rules needed to design, develop and implement ETL/ELT processes. Position is 100% remote. Must reside in U.S. Reports to HQ in New York, NY.

Salary: $167,835 – $178,500 per year.

MINIMUM REQUIREMENTS:

Bachelor’s degree or U.S. equivalent in Information Systems, Information Technology, Computer Science, Computer Engineering, or a related field, plus 6 years of professional experience as Data Engineer, Software Engineer, or any occupation/position/job title involving building data pipelines and utilizing big data technologies. Must also have experience in the following: 5 years of professional…