[Remote] Data Engineer

Note: The job is a remote job and is open to candidates in USA. Omnicom, through its Hearts & Science agency, is a company focused on data and analytics services. The Data Engineer will build, enhance, and optimize ETL jobs and data warehouse solutions, develop batch and real-time data solutions on AWS, support data quality and automation processes, and collaborate with Analytics, Data Science, IT, Investment, and other teams.

Responsibilities

• Contribute to the growth of the enterprise data warehouse (EDW) by working alongside stakeholders to produce accurate information within database objects used in reporting, strategic planning and decision making
• Assist the Senior Director 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 clarify requirements and business rules needed to design, develop and implement ETL/ELT processes
• Collaborate with peer Data Engineers to build upon and support our CI/CD pipelines hosted within our extensive GIT repository
• Mentor our 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 POCs 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/development, contributing to the team knowledgebase when applicable

Skills

• The candidate must have data warehouse, data pipeline design/development, SQL, AWS Cloud and Big Data Technologies experience
• This is a very hands-on position, requiring extensive experience developing workflows in Python, willingness to dive into legacy code repositories and maintain complex data transformation processes on AWS cloud
• Good decision-making, time management, prioritization and escalation skills are traits needed to ensure continued success in this role
• Bachelor's in Computer Science or similar technical degree within a STEM field
• 3+ years of hands-on experience in building data pipelines using traditional ETL tech stack, platform APIs and big data technologies
• 3+ years of experience in programming languages including as Python and working within a Linux based environment
• Experience designing, deploying and supporting production cloud services in AWS ecosystem including EC2, S3 and Redshift
• Can speak to concepts and designs/benefits to multiple audiences as well as interpret high level business requirements from conversation
• Able to work within a cross-functional team environment with people from multiple business units, vendors, countries, and cultures
• Working experience within the advertising/media industry with knowledge of basic media math
• Experience in Social Media Datasets such as Twitter, Facebook, Instagram is a plus
• Experience in Google Campaign Manager, Xandr, or Adobe Analytics datasets is a plus
• Experience with Google Cloud products is a plus
• Experience with Microsoft PowerAutomate is a plus
• Experience using Project Management tools such as Jira is a plus
• Experience creating data visualizations and using tools such as Tableau is a plus

Company Overview