StackAdapt
Lead the design and implementation of data architecture for StackAdapt's Enterprise Data Office, overseeing data engineering, data pipelines, and platform management to support business intelligence needs.
Apollo
Senior Solutions Architect at Apollo, leading federated graph efforts for major product teams, providing technical expertise & industry best practices.
Apollo
Lead the design and implementation of GraphQL-based architectures at Apollo, advising enterprise customers on adopting federated graphs and contributing to platform improvements.
Grafana Labs
Provide specialized consultation and guidance to customers using Grafana products. Work with complex business and technical requirements to design solutions, manage customer onboarding, and ensure ongoing success through support and advocacy for product improvements.
Cyderes
Senior Solution Architect for cybersecurity services provider Cyderes, driving revenue growth and expanding market share through professional services and managed security solutions.
Ottimate
Lead complex customer projects as Senior Manager of Professional Services at Ottimate (formerly Plate IQ), driving growth, innovation, and customer satisfaction.
CoinsPaid
Senior Payments Officer - Develop and ship impactful crypto payment features, collaborate with a talented team, and create innovative solutions.
Contentsquare
Senior Creative Operations Expert at Contentsquare: lead operational efficiency, collaborate with design & copywriting teams, drive brand storytelling & innovation.
brightwheel
Enhance Brightwheel's systems and processes as a Senior SysOps Administrator by leveraging your expertise in Salesforce and systems integration to drive operational efficiency and scalability.
ActiveCampaign
Lead the Postmark product team at ActiveCampaign, driving innovation in transactional email solutions. Collaborate across teams to deliver impactful features and ensure customer satisfaction with competitive compensation and benefits.
Mercury
Work on the most critical touchpoints in our product — between our users and the lifeblood of their business. Collaborate with designers and product leaders to deliver lovable experiences around card issuing and management. Build infrastructure ensuring reliable and secure operations with partner banks.
Apollo
Senior Marketing Communications Manager at Apollo GraphQL - drive developer advocacy, craft compelling stories, and build brand presence
Senior Data Scientist at Reddit: drive product strategy through data analysis and experimentation
Binance
Senior Staff Engineer - Java at Binance: Develop crypto-related products with autonomy, lead global greenfield projects, and drive transformative infrastructure upgrades.
Mercury
Senior Risk Strategist at Mercury: Develop risk management strategies using data analysis, lead cross-functional efforts, and ensure regulatory compliance.
Rackspace
Cloud Engineer for Rackspace Technology, supporting Site Reliability, DevOps Infrastructure on Google Cloud, with a focus on large-scale GCP employments and migrations.
Eventbrite, Inc.
Analyze data using SQL to provide insights for optimizing customer service strategies. Collaborate with leadership to improve processes and measure program impacts.
Contentsquare
Senior Product Manager AI role at Contentsquare, leading AI-focused products with a focus on user needs, practical AI solutions, and collaboration with design teams.
Futurhealth
AI Product Manager for weight management services, collaborating with engineering & healthcare teams to develop innovative AI solutions.
Twilio
Senior GTM Data Engineer 3 at Twilio: Design scalable data pipelines for sales systems integration & predictive analytics
StackAdapt
StackAdapt is seeking a Staff Data Architect to lead the data architecture, engineering, and operations within their Enterprise Data Office. The role involves building and managing data pipelines, advising on data models, mentoring junior engineers, and ensuring seamless execution of data operations. Candidates should have extensive experience in cloud-based data warehouses, ETL/ELT pipelines, orchestration tools, and infrastructure-as-code.
StackAdapt is a self-serve advertising platform that specializes in multi-channel solutions including native, display, video, connected TV, audio, in-game, and digital out-of-home ads. We empower hundreds of digitally-focused companies to deliver outcomes and exceptional campaign performance everyday. StackAdapt was founded with a vision to be more than an advertising platform, it’s 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. Reporting to the Director of Enterprise Data Office, the Staff Data Architect 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
Coach and mentor junior and intermediate data engineers and ETL developers as the EDO team grows
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
