Analytics Engineer, Care Operations
AndHealth · Columbus, OH · 1 mo ago
Information TechnologyFull-time
About the role
We're looking for an Analytics Engineer to be the dedicated data partner to our Care Delivery team. You'll translate business decisions into metrics, build internal and external reporting and dashboards, develop the semantic layer, and partner with Data and Software Engineering to shape the data platform.
Responsibilities
- Translate business decisions into metrics
- Partner with stakeholders from several teams to generate actionable insights
- Build internal and external reporting and dashboards
- Develop the semantic layer in dbt
- Flag upstream data quality issues and gaps
- Build a thorough testing suite across the data platform
- Partner with the client management team to build the value story for quarterly business reviews
- Become a domain expert in your assigned area
- Proactively identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform
Requirements
- Bachelor's degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent practical experience
- 6+ years of data analysis or related experience with significant experience partnering directly with business stakeholders
- Strong analytical instincts, able to interrogate data, identify anomalies, trace them to their source, and communicate findings clearly to technical and non-technical audiences
- Strong SQL proficiency, complex queries, CTEs, window functions, and performance-optimized transformations across large datasets
- Hands-on experience with dbt (Core or Cloud)
- Comfortable working within a dimensionally modeled warehouse
- Experience creating reporting systems and visualizations; advanced experience with Excel and other data systems
- Experience with a BI tool (Omni, Looker, Metabase, or similar), especially defining governed metrics and data products
- Familiarity with healthcare data (clinical, pharmacy, billing, or claims from EHRs, TPAs, or pharmacy operating systems)
- Advanced data modeling experience, designing non-trivial dbt/SQL models that encode real business logic
- Experience with R or Python or another scripting language in data analysis work
Qualifications
- Comfort working in ambiguous, fast-moving environments with competing priorities