ETL Developer

About the position

As an ETL Developer within the Analytics practice, you will work in an environment where everyone is passionate about data, analytics, and self-development with a customer-centric focus. This role is on the Smart Data team, which builds and maintains the reporting infrastructure for Wavemaker's roster of clients. You will have an opportunity to employ advanced data engineering, as well as data science tools and techniques, to media analytics. Some of the data sources you'll be working with are Ad Servers, Video Ad Servers, DSPs, DMPs, Ad Verification partners, Search & Social partners, Programmatic partners, and Campaign Management tools.

Responsibilities

• Work closely with our Wavemaker counterparts to document reporting requirements and recommend optimal solutions.
• Construct the standard (aka 'Baseline') reporting infrastructure for new clients in Azure and customize it to meet individual client needs using SQL and/or Python code.
• Create and modify data streams.
• Design, build and deploy custom ETL and data management processes.
• Review daily maintenance reports and communicate any issues to stakeholders.
• Report platform bugs to the engineering team and work closely on their resolution.
• Research new platform features.
• Optimize database performance and cost-efficiency of cloud-based processes.
• Maintain a high degree of knowledge in cloud data architecture and ETL best practices.
• Provision user access to Azure objects and SQL db.
• Formulate and execute robust UAT protocols to identify and address errors & data discrepancies.
• Draft build instructions for our offshore team and manage daily delivery of those.
• Proactively communicate project progress, issues and deliverables to Manager and stakeholders.

Requirements

• Bachelor's or Graduate degree in Statistics, Engineering, Computer Science, Economics, or related quantitative field.
• At least 1-2 years of relevant work experience, media analytics preferred.
• Strong SQL skills are a must.
• Knowledge of the advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred.
• Familiarity with Azure (Data Factory, Azure Batch and/or Azure DataBricks) is preferred.
• Experience with other cloud-based platforms (GCP, AWS) is a plus.
• Python experience is a plus.
• Tableau or other visualization tool experience is a plus.
• Exceptional organizational skills and detail oriented.
• Strong critical thinking and problem-solving skills.
• Advance knowledge of MS Office Suite (Excel, Word, PowerPoint).
• Excellent written, oral, communication, project management, and presentation skills.

Nice-to-haves

• Experience with other cloud-based platforms (GCP, AWS).
• Python experience.
• Tableau or other visualization tool experience.

Benefits

• Competitive medical, vision, and dental insurance.
• Significant paid time off.
• Preferential partner discounts.
• Employee mental health awareness days.