Junior Analytics Platform Engineer: DBT, Airflow

PepsiCo; New York (NY); On-site; USD 80,000 - 136,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Disability coverage

Paid time off

Bonus eligibility

Parental leave

Job summary

PepsiCo is hiring an entry-level Analytics Platform Engineer to help build and evolve the Digital Commerce Analytics Platform. You will contribute from dbt project infrastructure and CI/CD to orchestration, metadata systems, and AI-driven capabilities, working beside senior engineers to deliver reliable, scalable platform tooling for data delivery teams.

Located in New York, you will collaborate across engineering teams to implement best practices, govern BI workloads, and explore AI-assisted

Qualifications

• 1–2 years of experience in analytics engineering or related internships.
• Familiarity with dbt or similar transformation frameworks.
• Familiarity with Apache Airflow or similar orchestration tools.
• Experience with CI/CD systems (GitHub Actions, Jenkins, or equivalent).
• Exposure to BI platforms (Power BI, Tableau, or equivalent).
• Exposure to large language models and their application to analytics workflows.
• Experience with version control (Git) and branching strategies.
• Familiarity with cloud data platforms (Snowflake, BigQuery, or Databricks).

Responsibilities

• Develop and maintain the dbt project infrastructure — including CI/CD workflows, project configuration, macros, and testing frameworks — that delivery engineering teams build upon
• Build and support Apache Airflow orchestration infrastructure, ensuring reliable scheduling, monitoring, and scalability for data pipelines
• Maintain and evolve the CI/CD platform (GitHub Actions workflows, pre-commit hooks, automated validation) that enforces quality and deployment standards
• Manage and administer the Power BI platform — including workspace governance, capacity management, and deployment pipelines — to support report delivery teams
• Develop and maintain metadata collection systems for tracking pipeline health, lineage, and model ownership
• Define and enforce best practices, patterns, and conventions across data delivery and report delivery engineering teams
• Support evaluation and prototyping of AI-for-BI capabilities, including automated insight generation using large language models
• Research and evaluate emerging tools and technologies; present findings and recommendations to inform platform direction
• Participate in build-vs-buy assessments and contribute to tooling decisions that delivery engineering teams depend on
• Collaborate with engineering teams to identify platform gaps, gather requirements, and deliver scalable solutions

Skills

dbt

Apache Airflow

CI/CD

Power BI

LLMs / AI in BI

Git

Snowflake / BigQuery

Tools

GitHub Actions

Jenkins

Tableau

Job description

PepsiCo is hiring an entry-level Analytics Platform Engineer to help build and evolve the Digital Commerce Analytics Platform. You will contribute from dbt project infrastructure and CI/CD to orchestration, metadata systems, and AI-driven capabilities, working beside senior engineers to deliver reliable, scalable platform tooling for data delivery teams.

Located in New York, you will collaborate across engineering teams to implement best practices, govern BI workloads, and explore AI-assisted