Senior Enterprise Data Warehouse Developer

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.

Intro:

StackAdapt is a self-serve advertising platform specializing in multi-channel solutions. We are a hub of innovation, imagination, and creativity.

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. The Senior EDW Developer will have accountability over, and be responsible for building and supporting the many data pipelines, in accordance with enterprise data warehouse and development best practices, as well as supporting data operations within the EDO.

This role will build data pipelines based on the design of the Enterprise Datawarehouse Architect that are necessary for the delivery of data solutions that meet or exceed the data needs of the business, as articulated by the Manager of Business Data Analysis in the BRD/FRDs in consultation with the business.. This includes building ingestion data pipelines from a variety of data sources and building ETL for data models that are fit-for-purpose for immediate business consumption 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 consistently 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 building and supporting data pipelines within the Data Lake and Enterprise Data Warehouse (Snowflake) including:

• Build reliable and scalable 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 using enterprise grade orchestration platforms
• Contribute feedback to data architecture, data modeling, data tooling, 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
• Coach and mentor junior and intermediate data engineers and ETL developers as the EDO team grows

What you’ll bring to the table:

• Minimum 8 years of experience building data pipelines/ETL within an Enterprise Data Warehouse environment
• 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., Coalesce, PowerCenter, DataStage, Talend)
• Knowledgeable in data warehousing architecture fundamentals (e.g., Kimball/Inmon methodology, dimensional modeling, conformed dimensions, SCDs, etc)
• Hands-on experience administering cloud-based data warehouses; Snowflake preferred, and big data mediums (e.g., Iceberg, Delta Lake, Parquet, Avro) including tasks such as RBAC, PII data masking, administering user and service accounts and their access via OAuth/key pair authentication leveraging secret management services such as AWS KMS, Hashicorp Vault etc..
• Proven experience working with cloud-based platforms; AWS preferred; with knowledge of container technologies such as Kubernetes, data security, and networking fundamentals great assets
• Highly experienced in orchestrating data operations via tools such as Apache Airflow, Kestra, Cron etc.; knowledge of Infrastructure-as-Code (e.g., Terraform) a great asset
• Keen analytical and troubleshooting skills to diagnose issues and identify root causes
• Excellent written and verbal communication skills

The compensation range listed for this role reflects the expected base salary for candidates located in Ontario, Canada. It is informed by market data and the approved budget for this position. StackAdapt maintains different compensation ranges for roles across other countries and regions, and final offers will be aligned to the candidate’s current location.

This range represents base salary only. Depending on the role, candidates may also be eligible for additional compensation such as annual bonuses, commissions, equity awards, and a comprehensive benefits package.

Factors Influencing Final Compensation:

• The final compensation offer will be determined by a variety of factors, which may include, but are not limited to: the candidate's specific experience, technical skills, knowledge, abilities, and relevant education, licensure, and certifications.
• Other business factors, such as organizational needs and budget alignment, may also be considered in the final offer.

Ontario Residents Only

$100,000

—

$140,000 CAD

StackAdapter's Enjoy:

• Highly competitive salary
• Retirement/ 401K/ Pension Savings globally
• Competitive Paid time off packages including birthday's off!
• Access to a comprehensive mental health care program
• Health benefits from day one of employment
• Work from home reimbursements
• Optional global WeWork membership for those who want a change from their home office and hubs in London and Toronto
• Robust training and onboarding program
• Coverage and support of personal development initiatives (conferences, courses, books etc)
• Access to StackAdapt programmatic courses and certifications to support continuous learning
• An awesome parental leave program
• A friendly, welcoming, and supportive culture
• Our social and team events!

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.

We use artificial intelligence (AI) to streamline the resume reviews of candidates and assess their fit based on the criteria outlined in the job posting. We do not use AI to make any final hiring or interview decisions.

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

To learn more about our privacy practices, please see our

Privacy Policy

.

#LI-REMOTE