The Senior ETL Developer designs and manages data architecture and pipelines for the Enterprise Data Warehouse, ensuring seamless data integration and operation.
StackAdapt is the leading technology company that empowers marketers to reach, engage, and convert audiences with precision. With 465 billion automated optimizations per second, the AI-powered StackAdapt Marketing Platform seamlessly connects brand and performance marketing to drive measurable results across the entire customer journey. The most forward-thinking marketers choose StackAdapt to orchestrate high-impact campaigns across programmatic advertising and marketing channels.
We have an exciting opportunity in the newly formed Enterprise Data Office (EDO) with its mandate to serve the business leaders and stakeholders at StackAdapt with trusted official reporting and governed self-service analytics. Reporting to the Director of Enterprise 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 enterprise 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 provide seamless execution and collaborate with BI Engineers to ensure our business stakeholders’ needs are met as they consume data from within the BI platform.
StackAdapt is a Remote-First company. We are open to candidates located anywhere in Canada for this position.
What You'll Be Doing
- This role will be responsible for all data architecture, data engineering, and data operations within the Data Lake and Enterprise Data Warehouse (Snowflake) including:
- Build reliable data ingestion pipelines to extract data from a variety of data sources including databases (e.g., RDBMS/NOSQL/file stores), applications (via API), flatfiles, etc into the Data Lake with appropriate metadata tagging
- Orchestrate data pipelines via batch, near-real-time, or real-time operations depending on requirements to ensure a seamless and predictable execution
- Advise the team on all data architecture, data modeling, data operations, and data platform decisions
- Support the day to day operation of the EDO 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 within an Enterprise Data Warehouse environment
- Hands-on experience with cloud-based data warehouses (e.g., Snowflake, BigQuery, Redshift) and bigdata mediums (e.g., Delta Lake, Parquet, Avro)
- Knowledgeable in data warehousing architecture fundamentals (e.g., Kimball/Inmon methodology, dimensional modeling, conformed dimensions, SCDs, etc).
- Proven experience managing cloud-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 via custom-coded scripts (e.g., Spark, Python, JAVA, SQL stored procedures) and via integration platforms (e.g., PowerCenter, DataStage, Talend)
- Highly experienced in orchestrating data operations via tools such as Apache Airflow, Cron, Astronomer etc. and administering the data platform via Infrastructure-as-Code (e.g., Terraform).
StackAdapt is a diverse and inclusive team of collaborative, hardworking individuals trying to make a dent in the universe. 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 StackAdapt. If you have any requests or requirements to support you throughout any part of the interview process, please let our Talent team know.
About StackAdapt
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 2024
G2 Top Software and Top Marketing and Advertising Product for 2024
Campaign’s Best Places to Work 2023 for the UK
2024 Best Workplaces for Women and in Canada by Great Place to Work®
#1 DSP on G2 and leader in a number of categories including Cross-Channel Advertising
#LI-Remote
Top Skills
Apache Airflow
Avro
AWS
Azure
BigQuery
Datastage
Delta Lake
GCP
Java
Kubernetes
Parquet
Powercenter
Python
Redshift
Snowflake
Spark
SQL
Talend
Terraform
Similar Jobs
Artificial Intelligence • Information Technology • Natural Language Processing • Software • Business Intelligence • Generative AI
This role involves providing technical and functional support to clients, demonstrating product features, and architecting solutions within the SaaS environment. Engaging with sales for product presentations and ensuring customer satisfaction are key responsibilities.
Top Skills:
CSSHTMLJavaScriptSQL
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Lead backend engineering efforts, design and develop scalable systems, handle critical production issues, and mentor team members in a fast-paced environment.
Top Skills:
Aws CloudCassandraGitGoJava8KafkaOpensearchPostgresPythonRedis
10 Hours Ago
Artificial Intelligence • Hardware • Information Technology • Security • Software • Cybersecurity • Big Data Analytics
Lead and mentor a team managing Salesforce, MuleSoft, and HubSpot applications, guiding architectural decisions and overseeing development best practices.
Top Skills:
ApexHubspotMulesoftSalesforceSalesforce CpqSOQL
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
