Design, build, and maintain scalable cloud data pipelines and architectures. Develop and optimize ETL/ELT workflows, manage data warehouses (primarily BigQuery), implement governance and security, collaborate with engineers and analytics teams, enable ML/AI use cases, and maintain documentation, lineage, and high-availability pipelines.
ABOUT APPLY
APPLY is the Agentic Customer Experience (ACx) partner for the world's most ambitious consumer and entertainment brands. We bring together deep domain expertise across Retail, CPG, Sports, and Media with AI-native delivery capability, designing and delivering agentic solutions that turn CX vision into commercial reality. We are the partner of choice for brands like Arc'teryx, NFL, Lululemon, and Kraft Heinz. For more information, visit applydigital.com.
LOCATION: APPLY is hybrid/remote friendly. The preferred candidate should be based in either the Greater Toronto Area or the Greater Vancouver Area of Canada, working in hours that align to ET (Eastern Timezone) or PT (Pacific Timezone).
THE ROLE:
RESPONSIBILITIES:
- Design, build, and maintain scalable data pipelines and architectures to support analytical and operational workloads.
- Develop and optimize ETL/ELT pipelines, ensuring efficient data extraction, transformation, and loading from various sources.
- Work closely with backend and platform engineers to integrate data pipelines into cloud-native applications.
- Manage and optimize cloud data warehouses, primarily BigQuery, ensuring performance, scalability, and cost efficiency.
- Implement data governance, security, and privacy best practices, ensuring compliance with company policies and regulations.
- Collaborate with analytics teams to define data models and enable self-service reporting and BI capabilities.
- Develop and maintain data documentation, including data dictionaries, lineage tracking, and metadata management.
- Monitor, troubleshoot, and optimize data pipelines, ensuring high availability and reliability.
- Stay up to date with emerging data engineering technologies and best practices, continuously improving our data infrastructure.
REQUIREMENTS:
- Certified SnowPro.
- Experience collaborating with distributed teams across North America and Latin America.
- 5+ years of experience in data engineering, building modern cloud-based data platforms.
- Strong hands-on experience with Snowflake, including performance tuning, security, and data modeling.
- Advanced SQL skills for analytics engineering and data transformation.
- Proficiency in Python for data processing, automation, and orchestration.
- Experience with dbt or similar analytics engineering frameworks.
- Familiarity with orchestration tools such as Dagster or Apache Airflow.
- Experience working with clickstream and event data — ingestion, modeling, and real-time or near-real-time processing at scale.
- Experience enabling or supporting machine learning, feature engineering, or AI-driven use cases on top of data platforms.
- GCP certified (Associate Cloud Engineer or Professional Data Engineer).
- Solid understanding of data privacy, governance, and compliance best practices.
- Strong problem-solving skills and a pragmatic, delivery-oriented mindset.
- Strong problem-solving skills, with the ability to debug and optimize complex data workflows.
- Excellent English communication and collaboration skills.
NICE TO HAVES:
- Experience with Snowflake Cortex, Snowpark, or ML workflows integrated with Snowflake.
- Familiarity with GenAI or LLM-enabled analytics use cases (e.g., semantic layers, AI-assisted insights, decisioning).
- Experience with Databricks or hybrid Snowflake + Databricks architectures.
- Exposure to real-time or near-real-time data pipelines.
- Experience with BI tools (e.g., Looker, Tableau, Power BI).
- Infrastructure as Code experience (e.g., Terraform) in data environments.
- Familiarity with CDPs, marketing platforms, and digital experience ecosystems (e.g., Segment, Contentful, personalization tools).
LIFE AT APPLY
People are at the core of everything we do at APPLY. We provide you with modern tools, systems and approaches, value your time, safety, and health, and strive to build a work community where you can thrive and grow. Here are a few benefits we offer to support you:
Agentic Delivery: Our people work in a modern way to deliver client outcomes. Broaden your skills on a range of engagements with international brands that have a global impact.
An inclusive and safe environment: We’re truly committed to building a culture where you are celebrated and everyone feels welcome and safe.
AI & Strategic Upskilling: Accelerate your professional growth with generous training budgets and mentorship, with a specific focus on Agentic AI expertise and the critical human skills required for the future of work.
Generous vacation policy: Work-life balance is key to our team’s success, so we offer flexible personal time off (PTO); allowing ample time away from work to promote overall well-being.
Customizable benefits: Tailor your extended health and dental plan to your needs, priorities, and preferences.
Flexible work arrangements: We work in a variety of ways, from remote, to in-office, to a blend of both.
APPLY is a safe, respectful, and inclusive community where differences are celebrated. We are committed to equal opportunity and fostering a workplace where everyone belongs. Learn more in our Diversity, Equity, and Inclusion (DEI) section. For recruitment accommodations, please email [email protected].
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Design, build, and operate production AI systems and marketing data infrastructure. Develop retrieval pipelines, agent orchestration, CDP integrations, ETL/ELT pipelines, and analytics. Automate workflows with AI, ensure data quality and reliability, partner with stakeholders, ship Python and SQL code, mentor engineers, and drive requirements to production.
Top Skills:
Agent OrchestrationBigQueryClaude CodeCursorCustomer Data Platform (Cdp)Data WarehouseDatabricksDbtEtl/EltHightouchLlmsMarketing AutomationPythonSalesforceSegmentSnowflakeSQLWeb Analytics
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Design and maintain data architecture and pipelines to support compliance and risk teams. Build and optimize data models, standardize metrics, and create data dictionaries. Implement data quality, lineage monitoring, AI-driven agents for false-positive reduction and automation, and participate in on-call rotations to ensure SLAs are met.
Top Skills:
AirflowDatabricksDbtGitOmniPrefectPythonSnowflakeSQLTerraform
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Lead design and optimization of data models and pipelines for compliance and risk; standardize metrics and documentation; build data quality, lineage, and monitoring (including AI agents for automation); manage ETL scheduling, on-call pipeline support, and collaborate with product and non-technical partners to translate business needs into automated, production-ready data solutions.
Top Skills:
AirflowDatabricksDbtGitOmniPrefectPythonSnowflakeSQLTerraform
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.
