Analytics Engineer I
Imperial Funding Corporation
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Imperial Funding Corporation seeks an Analytics Engineer I to design and maintain data infrastructure that delivers analysis-ready insights. You will build scalable data models, ELT/ETL pipelines, and governance practices to support data-driven decisions across departments.
The role bridges raw data ingestion and analytics, ensuring high-quality, well-documented data for stakeholders, with standard collaboration across the analytics team.
Qualifications
- 2-4 years in analytics engineering, data engineering, or similar role.
- ANSI-SQL proficiency for querying and data transformations.
- Snowflake expertise and best practices for data management.
- Strong data modeling skills for analytics.
- dbt proficiency for managing data transformations.
Responsibilities
- Design, build, and manage data models and ELT/ETL pipelines in Snowflake using dbt (Data Modeling & Pipeline Development).
- Create conform analytics layers and data marts tailored to business needs.
- Implement data quality, integrity, and governance checks.
- Optimize data storage and SQL performance in Snowflake.
- Document data models, lineage, and metadata; maintain CI/CD for code quality.
- Collaborate with analysts and stakeholders to translate requirements into data solutions.
Skills
Tools
Job description
Ready for the next step in your career?
Great companies have great teams.
What started in 1977 as a small, local office offering premium financing has grown to over 600 associates and more than 20 locations across North America. In all we say and do, we work towards our mission of providing solutions, resources, and premium financing for the insurance industry.
We work hard to deliver on our corporate mission statement by empowering and encouraging our associates to provide great products and an unparalleled level of service.
1977
600 Associates
29 Locations
- At the Office
- Based on your location, we offer parking and commuter benefits programs to help make your commute a little easier.
- Insurance Benefits
- Our insurance benefits include medical, prescription, dental, voluntary vision, voluntary life/dependent life, group term life, and AD&D.
- Supporting Wellness
- Our wellness program, WellWorks, combined with our Employee Assistance Program (for confidential support), provides support for short and long-term health goals, and any bumps along the way. We also offer gym membership subsidies to support health and fitness goals.
- Work Life Balance
- We offer paid vacation time and paid personal leave, in addition to company-paid holidays.
- Preparing for Your Future
- IPFS offers a 401(k) with a company match to help set you up for a financially successful future.
- Company Culture
- Our associates are the foundation of our company. We strive to make our workplace a great place for everyone. IPFS sponsors company lunches, corporate outings, and even the occasional ice cream truck!
Location: Kansas City, MO (4 days in-office, 1 day remote)
Experience Level: Mid-level (2-4 years)
Department: Data Analytics Team
An Analytics Engineer builds and maintains the foundational data infrastructure that transforms raw business data into reliable, analysis-ready insights for decision-making. This position is critical to establishing scalable data models, pipelines, and governance practices that will support our growing analytical needs.
The prime reason for this role's existence is to bridge the gap between raw data ingestion and analytics needs, ensuring that our analysts and stakeholders have access to high-quality, well-documented, and performant data models. This position directly contributes to the company's overall mission by enabling data-driven decision making across all departments, improving operational efficiency, and supporting strategic initiatives through reliable analytics infrastructure.
- Building standardized data models that reduce time-to-insight for business users
- Implementing data quality and governance frameworks that ensure information is accurate and compliant.
- Creating reliable, well-documented data pipelines that enable consistent reporting and analytics across all business functions
- 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
- 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
- SnowPro certification 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
#IPFSUS
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
