← Back to jobsJob ID col-cmv8dw7d904iuoz01wsvb3sgr

Imperial PFSPosted 30+ days ago

Data Analytics Engineer

Full-time
On-site
2+ years
$88K – $117K/yr
Posted 30+ days ago

Midwest Railcar provides railcar leasing and transportation solutions across the rail industry. The Data Analytics Engineer will build and maintain scalable data models, ELT/ETL pipelines, governance practices, and documentation in Snowflake and dbt to deliver reliable, analysis-ready data. The role also focuses on performance optimization, software engineering practices, and collaboration with analysts and business stakeholders.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

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 data quality checks and validation processes within dbt workflows
  • Optimize data storage and retrieval processes within Snowflake to ensure scalable, reliable, and cost-effective data solutions
  • Fine-tune SQL queries and data transformations for optimal performance
  • Monitor and improve pipeline efficiency and resource utilization
  • Create and maintain clear, comprehensive documentation for data models, processes, and key metrics
  • Document data lineage and maintain metadata for analytical datasets
  • Establish documentation standards and best practices for the team
  • Leverage version control and CI/CD pipelines for streamlined, reliable development processes
  • Ensure code quality through testing, peer reviews, and automated deployment
  • Work closely with analysts and business subject matter experts to understand requirements
  • Translate business needs into effective technical data solutions
  • Participate in regular stakeholder meetings to refine and expand data capabilities

Qualifications

  • Bachelor's degree in Information Systems or a related field
  • 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

Preferred

  • SnowProcertification or equivalent advanced Snowflake expertise
  • Experience with modern cloud data architecture (data lakes, data lakehouses, cloud data platforms)
  • Experience with ELT/ETL tools (Fivetran experience a plus)
  • Knowledge of data visualization tools (Tableau, Looker, Power BI)
  • Previous experience in insurance, finance, or regulated industries
  • Python programming experience for data parsing, transformation, and scripting within data pipelines
  • Insurance Industry Experience
  • Finance Industry Experience
  • Regulated Industry Experience

Required skills

SQLSnowflakeData ModelingdbtELT/ETL PipelinesData GovernanceData QualityCloud Data ArchitectureFivetranTableauLookerPower BIPython

Full job description

Midwest Railcar provides railcar leasing and transportation solutions across the rail industry. The Data Analytics Engineer will build and maintain scalable data models, ELT/ETL pipelines, governance practices, and documentation in Snowflake and dbt to deliver reliable, analysis-ready data. The role also focuses on performance optimization, software engineering practices, and collaboration with analysts and business stakeholders.

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 data quality checks and validation processes within dbt workflows
  • Optimize data storage and retrieval processes within Snowflake to ensure scalable, reliable, and cost-effective data solutions
  • Fine-tune SQL queries and data transformations for optimal performance
  • Monitor and improve pipeline efficiency and resource utilization
  • Create and maintain clear, comprehensive documentation for data models, processes, and key metrics
  • Document data lineage and maintain metadata for analytical datasets
  • Establish documentation standards and best practices for the team
  • Leverage version control and CI/CD pipelines for streamlined, reliable development processes
  • Ensure code quality through testing, peer reviews, and automated deployment
  • Work closely with analysts and business subject matter experts to understand requirements
  • Translate business needs into effective technical data solutions
  • Participate in regular stakeholder meetings to refine and expand data capabilities

Preferred

  • SnowProcertification or equivalent advanced Snowflake expertise
  • Experience with modern cloud data architecture (data lakes, data lakehouses, cloud data platforms)
  • Experience with ELT/ETL tools (Fivetran experience a plus)
  • Knowledge of data visualization tools (Tableau, Looker, Power BI)
  • Previous experience in insurance, finance, or regulated industries
  • Python programming experience for data parsing, transformation, and scripting within data pipelines
  • SnowPro Certification
  • Advanced Snowflake Expertise
  • Cloud Data Architecture
  • Data Lakes
  • Data Lakehouses
  • Cloud Data Platforms
  • ELT/ETL Tools
  • Fivetran
  • Data Visualization
  • Tableau
  • Looker
  • Power BI
  • Insurance Industry Experience
  • Finance Industry Experience
  • Regulated Industry Experience
  • Python Programming
  • Data Parsing
  • Scripting
  • Data Pipeline Development

Benefits

  • Parking and commuter benefits programs, based on your location
  • Wellworks wellness program
  • Employee Assistance Program for confidential support
  • Gym membership subsidies
  • 401(k) with a company match
  • Company lunches
  • Corporate outings
  • Occasional ice cream truck
  • Medical insurance
  • Prescription insurance
  • Dental insurance
  • Voluntary vision insurance
  • Voluntary life/dependent life insurance
  • Group term life insurance
  • AD&D insurance
  • Paid time off
  • Paid holidays, in accordance with company policy and applicable laws

Company

  • Insurance premium financing and payment technology
  • Kansas City, Missouri, USA
  • https://www.ipfs.com/
  • Founded in 1977
  • 501-1000 employees

Qualifications

  • Bachelor's degree in Information Systems or a related field
  • 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
  • Dbt proficiency for managing data transformations and building data models within Snowflake
  • SnowProcertification or equivalent advanced Snowflake expertise
  • Experience with modern cloud data architecture (data lakes, data lakehouses, cloud data platforms)
  • Experience with ELT/ETL tools (Fivetran experience a plus)
  • Knowledge of data visualization tools (Tableau, Looker, Power BI)
  • Previous experience in insurance, finance, or regulated industries
  • Python programming experience for data parsing, transformation, and scripting within data pipelines

Required skills

  • SQL, Snowflake, Data Modeling, dbt, ELT/ETL Pipelines, Data Governance, Data Quality, Cloud Data Architecture, Fivetran, Tableau, Looker, Power BI, Python

Preferred skills

  • Experience with ELT/ETL tools (Fivetran experience a plus)

Experience

  • 2+ years

Job details

Employment type

Full-time

Seniority level

2+ years

Date posted

Oct 10, 2026

Work mode

On-site

Job source

Ethic Leaf recruiter

Company

Imperial PFS

Information Technology & AI

Insurance premium financing and payment technology

  • Kansas City, Missouri, USA
  • Information Technology & AI
  • 501-1000 employees
  • Founded 1977
  • ipfs.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Analytics Engineer jobs in St. Louis

Amazon

1d ago

New

Data Engineer, Central InfraOps Analytics Team

Full-timeOn-siteSeattle, WA$101K – $160K/yr

Amazon Data Services, Inc. is hiring a Data Engineer to support data-driven decision-making for AWS Data Center Infrastructure Operations.

Why similarSame roleData ModelingPython

Energy

1d ago

New

Sr Data & Analytics Engineer

Full-timeRemoteUnited StatesCompetitive

Baltimore Aircoil Company (BAC) is hiring a Senior Data & Analytics Engineer to support and modernize enterprise data and analytics capabilities using Microsoft Fabric and Power BI.

Why similarSame rolePower BIRemote

MSRcosmos LLC

1d ago

New

Business Intelligence/Data Analytics Developer

Full-timeRemoteUnited StatesCompetitive

MSRcosmos LLC is hiring a Business Intelligence/Data Analytics Developer to modernize healthcare data warehouse reporting by converting SAP BusinessObjects reports and universes to Power BI.

Why similarSame roleData ModelingRemote

Get new Analytics Engineer jobs in St. Louis by email

Create job alert

Data Analytics Engineer

Imperial PFS · $88K – $117K/yr

Apply via Ethic Leaf