Analytics Engineer I: Data Pipelines & Governance

Imperial PFS; Kansas City (MO); Hybrid; USD 95,000 - 135,000; Full time

Job summary

Imperial PFS in Kansas City is seeking an Analytics Engineer to design, build, and optimize data models and ELT/ETL pipelines in Snowflake using dbt. You will create analytics layers and data marts to standardize data for stakeholders.

The role emphasizes data quality, governance, and documentation, with collaboration across analysts and business teams to translate requirements into reliable data solutions and scalable infrastructure.

Qualifications

• 2–4 years of experience in analytics engineering, data engineering, or similar role.
• Advanced SQL proficiency in ANSI-SQL for querying, data transformation, and building data infrastructure.
• Snowflake expertise with hands‑on architecture and best practices for data management.
• Strong data modeling skills and experience designing efficient analytics structures.
• dbt proficiency for managing data transformations and data models in Snowflake.
• High attention to detail and commitment to data quality.
• Strong communication skills and ability to collaborate with non‑technical stakeholders.
• Curiosity to understand business problems through data.

Responsibilities

• Design, build, and manage data models and ELT/ETL pipelines in Snowflake using dbt.
• Create conform and analytics layers for standardized business data consumption.
• Develop dimensional models and data marts aligned with business needs.

Skills

Advanced SQL

Snowflake

dbt

Data modeling

Data governance

Attention to detail

Communication

Analytical thinking

Tools

Snowflake

dbt

Fivetran

Tableau

Looker

Power BI

Job description

Imperial PFS in Kansas City is seeking an Analytics Engineer to design, build, and optimize data models and ELT/ETL pipelines in Snowflake using dbt. You will create analytics layers and data marts to standardize data for stakeholders.

The role emphasizes data quality, governance, and documentation, with collaboration across analysts and business teams to translate requirements into reliable data solutions and scalable infrastructure.