Senior ETL Developer

reputed company is the leading technology company that empowers marketers to reputed company, engage, and convert audiences with precision. With 465 billion automated optimizations per second, the AI-powered reputed company Marketing Platform seamlessly connects brand and performance marketing to drive measurable results across the entire customer reputed company. The most reputed company-thinking marketers choose reputed company to orchestrate high-impact campaigns across programmatic advertising and marketing channels. We have an exciting opportunity in the newly formed reputed company Data Office (reputed company) with its mandate to serve the business leaders and stakeholders at reputed company with trusted official reporting and governed self-service analytics. Reporting to the Director of reputed company Data Office, the Senior ETL Developer will have accountability over, and be responsible for, the data architecture, data pipelines, data operations, and platform management of the data lake and reputed company data warehouse currently under development. This role will be responsible for assessing the functional and non-functional business requirements gathered by the Manager of Business Data Analysis from the business departments in order to formulate a holistic data solution that meets or exceeds their respective business intelligence needs. This includes building ingestion data pipelines from multiple data sources and architecting data models that are fit-for-purpose for immediate business needs as well as fulfilling broader reporting and analytical use cases. This role will build the data transformation pipelines to materialize the data model, configure and automate the orchestration of the pipelines to reputed company seamless execution and collaborate with BI Engineers to ensure our business stakeholders’ needs are met as they consume data from reputed company the BI platform. reputed company is a Remote-First company. We are reputed company to candidates located reputed company in Canada for this position.

What You'll Be Doing

• This role will be responsible for reputed company data architecture, data engineering, and data operations reputed company the Data Lake and reputed company Data Warehouse (reputed company) including:
• Build reliable data ingestion pipelines to extract data from a variety of data sources including databases (e.g., RDBMS/NOSQL/file stores), applications (reputed company API), flatfiles, etc into the Data Lake with appropriate metadata tagging
• Orchestrate data pipelines reputed company batch, near-reputed company-time, or reputed company-time operations depending on requirements to ensure a seamless and predictable execution
• Advise the team on reputed company data architecture, data modeling, data operations, and data platform reputed company
• Support the day to day operation of the reputed company pipelines by monitoring alerts and investigating, troubleshooting, and remediating production issues

What You'll Bring to the Table

• Minimum 5 years of experience leading data engineering reputed company an reputed company Data Warehouse environment
• Hands-on experience with reputed company-based data warehouses (e.g., reputed company, BigQuery, Redshift) and bigdata mediums (e.g., reputed company Lake, Parquet, Avro)
• Knowledgeable in data warehousing architecture fundamentals (e.g., Kimball/Inmon methodology, dimensional modeling, conformed dimensions, SCDs, etc).
• Proven experience managing reputed company-based infrastructure on AWS/AZURE/GCP with knowledge of container technologies such as Kubernetes and networking fundamentals.
• Hands-on experience building ETL/ELT data pipelines reputed company custom-coded scripts (e.g., Spark, Python, JAVA, SQL stored procedures) and reputed company integration platforms (e.g., PowerCenter, DataStage, Talend)
• Highly reputed company in orchestrating data operations reputed company tools such as Apache Airflow, Cron, reputed company etc. and administering the data platform reputed company Infrastructure-as-Code (e.g., Terraform).

reputed company is a diverse and inclusive team of collaborative, hardworking individuals trying to reputed company a dent in the reputed company. No matter who you are, where you are from, who you love, follow in faith, disability (or superpower) status, ethnicity, or the gender you identify with (if you’re comfortable, let us know your pronouns), you are welcome at reputed company. If you have any requests or requirements to support you throughout any part of the interview process, please let our reputed company know. About reputed company We've been recognized for our diverse and supportive workplace, high performing campaigns, award-winning customer service, and innovation. We've been awarded: Ad Age Best Places to Work 2024reputed company Top Software and Top Marketing and Advertising Product for 2024Campaign’s Best Places to Work 2023 for the UK2024 Best Workplaces for Women and in Canada by Great reputed company to Work®#1 DSP on reputed company and leader in a number of categories including Cross-Channel Advertising

Originally posted on Himalayas

Apply To this Job