Senior Analytics Engineer — Transform Data for BI Decisions

Profitero, Inc.; Lehi (UT); Hybrid; USD 88,540 - 121,100; Full time

Benefits offered by this job

Paid time off

Hybrid work arrangements

Dental/medical benefits

Job summary

Profitero+ is hiring a Senior Analytics Engineer to own the transformation layer between data ingestion and BI platforms. You will define how raw data becomes trusted, business-ready models powering decisions across the organization.

The role requires 5+ years in data/analytics engineering, strong dbt and SQL skills, and experience with BigQuery. Hybrid role in Lehi, UT with on-site expectations 1–2 days/week and no sponsorship.

Qualifications

• 5+ years of professional experience in data engineering, analytics engineering, or a similar role; prior experience working alongside the CPG, retail, and/or marketing industries preferred.
• Bachelor's degree in computer science, data analytics, information systems, or a related field preferred; experience may be substituted.
• Expert-level dbt skills including experience building and maintaining production dbt projects at scale including tests, documentation, and incremental models.
• Strong SQL and data modeling skills, particularly in BigQuery or another columnar cloud data warehouse.
• Experience working across the full data pipeline from raw ingestion to BI-ready models.
• Familiarity with ecommerce, CPG, digital shelf, or retail media network data sources and analytics preferred.
• Experience with Airflow or Dagster for pipeline orchestration and Python for data pipeline tasks preferred.
• Familiarity with Looker or LookML preferred.
• Experience and familiarity with data quality frameworks, automated testing, or observability tooling preferred.
• Comfort operating with a high level of ownership, autonomy, and accountability.
• A natural sense of urgency with an ability to work quickly, efficiently, and accurately within tight deadlines and constantly-evolving project parameters, scope, and goals.
• Flexible and adaptable with an ability to work successfully across multiple concurrent projects and competing priorities.
• Highly collaborative but independently capable.
• Exceptionally organized with a fanatical attention to detail.
• Strong written and verbal communication skills, both with technical and non-technical audiences.

Responsibilities

• Own the Transformation Layer: Design, build, and maintain dbt models transforming raw data into analytics-ready datasets.
• Define and enforce dbt modeling standards, naming conventions, and testing practices.
• Serve as primary owner of the transformation layer, coordinating with ingestion engineers and BI developers
• Proactively identify data coverage gaps and work with sourcing teams to resolve them.
• Accelerate Pipeline Delivery: Reduce transformation backlogs by building scalable, reusable model patterns.
• Partner with Airflow/Dagster pipeline owners to ensure DAGs are reliable and well-monitored in BigQuery.
• Identify and resolve performance bottlenecks in SQL transformations and BigQuery query patterns.
• Bridge Engineering and Analytics: Ensure Looker data sources are well-modeled and maintainable.
• Translate business requirements into reliable data models; automate dbt testing and data quality monitoring.
• Mentor junior/mid-level teammates and document data models, lineage, and transformation logic.
• Contribute to SQL and business logic standards with the Director of Data Engineering.

Skills

dbt

SQL

BigQuery

Python

Airflow

Dagster

Looker/LookML

data modeling

data quality

Education

Bachelor's degree in computer science, data analytics, information systems, or related field

Tools

dbt

BigQuery

Looker/LookML

Airflow

Dagster

Python

Job description

Profitero+ is hiring a Senior Analytics Engineer to own the transformation layer between data ingestion and BI platforms. You will define how raw data becomes trusted, business-ready models powering decisions across the organization.

The role requires 5+ years in data/analytics engineering, strong dbt and SQL skills, and experience with BigQuery. Hybrid role in Lehi, UT with on-site expectations 1–2 days/week and no sponsorship.