Analytics Engineer

Summary

Imagine360 is a health plan solution company that combines decades of self-funding healthcare expertise with customized, member-focused solutions. The Analytics Engineer will build and maintain reliable data infrastructure, reusable data models, and transformation layers that support enterprise and client-facing analytics. The role also involves optimizing SQL, developing analytics-ready datasets, ensuring data quality, and collaborating with analysts and business stakeholders.

Responsibilities

• 3+ years of experience in analytics engineering or a closely related analytics/data role
• Strong T-SQL/SQL skills, including CTEs, window functions, joins, aggregations, and set-based transformations
• Ability to troubleshoot and optimize SQL queries, including interpreting execution plans and identifying opportunities for indexing, query rewrites, and improved data access
• Strong understanding of dimensional data modeling, including star schemas, data grain, fact and dimension tables, and reusable transformation layers
• Experience building incremental and repeatable data pipelines with appropriate data validation and quality checks
• Experience developing and maintaining analytics-ready datasets that can be consistently consumed by BI tools and analysts
• Experience with Git/source control and maintaining clear documentation of data models, dependencies, and transformations
• Ability to work closely with analysts and business stakeholders to understand requirements and translate them into scalable data solutions
• Strong attention to detail and an ability to investigate data discrepancies and identify root causes

Skills

• 3+ years of experience in analytics engineering or a closely related analytics/data role
• Strong T-SQL/SQL skills, including CTEs, window functions, joins, aggregations, and set-based transformations
• Ability to troubleshoot and optimize SQL queries, including interpreting execution plans and identifying opportunities for indexing, query rewrites, and improved data access
• Strong understanding of dimensional data modeling, including star schemas, data grain, fact and dimension tables, and reusable transformation layers
• Experience building incremental and repeatable data pipelines with appropriate data validation and quality checks
• Experience developing and maintaining analytics-ready datasets that can be consistently consumed by BI tools and analysts
• Experience with Git/source control and maintaining clear documentation of data models, dependencies, and transformations
• Ability to work closely with analysts and business stakeholders to understand requirements and translate them into scalable data solutions
• Strong attention to detail and an ability to investigate data discrepancies and identify root causes
• Experience with Tableau, including data sources, extracts, performance optimization, and basic administration
• Experience with Power BI and/or Microsoft Fabric
• Experience with DAX, Power Query/M, or semantic model development
• Experience working with healthcare claims data or other complex transactional datasets
• Experience with DB2/IBM i, linked servers, or other legacy data sources
• Familiarity with query folding and predicate pushdown concepts
• Experience automating recurring analytics or data processes
• Experience contributing to data governance, data quality, and analytics standards

Qualifications

Must Haves

• 3+ years of experience in analytics engineering or a closely related analytics/data role
• Strong T-SQL/SQL skills, including CTEs, window functions, joins, aggregations, and set-based transformations
• Ability to troubleshoot and optimize SQL queries, including interpreting execution plans and identifying opportunities for indexing, query rewrites, and improved data access
• Strong understanding of dimensional data modeling, including star schemas, data grain, fact and dimension tables, and reusable transformation layers
• Experience building incremental and repeatable data pipelines with appropriate data validation and quality checks
• Experience developing and maintaining analytics-ready datasets that can be consistently consumed by BI tools and analysts
• Experience with Git/source control and maintaining clear documentation of data models, dependencies, and transformations
• Ability to work closely with analysts and business stakeholders to understand requirements and translate them into scalable data solutions
• Strong attention to detail and an ability to investigate data discrepancies and identify root causes

Nice to Haves

• Experience with Tableau, including data sources, extracts, performance optimization, and basic administration
• Experience with Power BI and/or Microsoft Fabric
• Experience with DAX, Power Query/M, or semantic model development
• Experience working with healthcare claims data or other complex transactional datasets
• Experience with DB2/IBM i, linked servers, or other legacy data sources
• Familiarity with query folding and predicate pushdown concepts
• Experience automating recurring analytics or data processes
• Experience contributing to data governance, data quality, and analytics standards

Benefits

• Multiple Health Plan Options, including a 100% Employer Paid Benefit Options
• 100% Company paid employee premiums for Dental, Vision, STA, & LTD, plus Life Insurance
• Parental Leave Policy
• 20 days PTO to start / 10 Paid Holidays
• Tuition reimbursement
• 401k Company contribution
• Professional development initiatives / continuous learning opportunities
• Opportunities to participate in and support the company's diversity and inclusion initiatives