Analytics Engineer I
HybridKansas City, Missouri, United States
Job Summary
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, including dimensional models and data marts tailored to specific requirements. Implement data quality checks, validation processes, and governance frameworks to ensure information accuracy and compliance. Optimize data storage, retrieval, and SQL query performance within Snowflake to maintain scalable, cost-effective solutions. Create and maintain comprehensive documentation for data models, processes, and key metrics, including lineage and metadata. Leverage version control and CI/CD pipelines to ensure code quality through testing and peer reviews. Collaborate with analysts and business subject matter experts to translate requirements into effective technical data solutions.
Required 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
- 4 days in-office
- 1 day remote
Desired Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.