Hybrid Analytics Engineer - Snowflake, dbt & Pipelines

IPFS Corporation; Kansas City (MO); Hybrid; USD 100,000 - 150,000; Full time

Job summary

IPFS Corporation is seeking an Analytics Engineer in Kansas City, MO to design and maintain data infrastructure that delivers reliable, analytics-ready insights. You will build scalable data models, pipelines, and governance practices to support data-driven decision making across departments.

The role emphasizes bridging raw data ingestion and analytics needs, ensuring high-quality, well-documented data models while collaborating with analysts and stakeholders to improve operational efficiency

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 experience in its architecture and best practices for data management and processing.
• Strong data modeling skills with deep understanding of data modeling principles and experience designing efficient structures for analytics.
• dbt proficiency for managing data transformations and building data models within Snowflake.
• Passion for detail and quality - skilled at spotting data and process gaps and committed to driving continuous improvement.
• Strong communication skills and comfort collaborating with non-technical stakeholders.
• Intellectual curiosity and drive to understand business problems through data.

Responsibilities

• Design, build, and manage data models and ELT/ETL pipelines to transform raw data into structured formats within Snowflake using dbt.
• Create conform and analytics layers that standardize data for business consumption.
• Develop dimensional models and data marts tailored to business requirements.
• Implement best practices for data quality, integrity, and performance monitoring.
• Contribute to data governance frameworks, including maintaining data lineage and definitions.
• Establish documentation standards and best practices for the team.
• Leverage version control and CI/CD pipelines for streamlined, reliable development processes.
• Work closely with analysts and business subject matter experts to translate requirements into technical data solutions.

Skills

SQL (ANSI)

Snowflake

dbt

Data Modeling

Data Pipelines

Data Quality

Communication

Analytical Thinking

Tools

Snowflake

dbt

Job description

IPFS Corporation is seeking an Analytics Engineer in Kansas City, MO to design and maintain data infrastructure that delivers reliable, analytics-ready insights. You will build scalable data models, pipelines, and governance practices to support data-driven decision making across departments.

The role emphasizes bridging raw data ingestion and analytics needs, ensuring high-quality, well-documented data models while collaborating with analysts and stakeholders to improve operational efficiency