3 months ago
Columbus, OH, USASenior
Responsibilities
- Translate stakeholder decisions and ambiguous business questions into governed metric definitions.
- Build internal and external reporting, dashboards, curated datasets, and self-service data products for pharmacy and care operations.
- Develop and maintain dbt semantic-layer models that encode business logic across staging, intermediate, and mart layers.
- Partner with Data and Software Engineering on raw data consumption, ingestion, staging transformations, and data quality issues.
- Build testing suites including schema tests, data quality checks, anomaly detection, and SLA monitoring.
- Identify data gaps and reliability improvements and communicate actionable insights to technical and non-technical stakeholders.
- Partner with client management to develop value stories for quarterly business reviews.
- Become the domain expert for care operations and translate business logic into accurate, scalable data models.
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 direct partnership with business stakeholders.
- Proven ability to turn ambiguous business questions into concrete, governed metric definitions.
- Strong analytical skills, including anomaly identification, source tracing, and clear communication of findings.
- Strong SQL proficiency with complex queries, CTEs, window functions, and performance-optimized transformations across large datasets.
- Advanced data modeling experience, including non-trivial dbt and SQL models that encode business logic.
- Experience with reporting systems, visualizations, advanced Excel, and other data systems.
- Experience working alongside ETL/ELT pipelines and partnering with data or software engineers on ingestion.
- Experience with a BI tool such as Omni, Looker, Metabase, or similar, especially for governed metrics and data products, preferred.
- Hands-on dbt Core or Cloud experience, dimensionally modeled warehouse experience, healthcare data familiarity, and R or Python experience are preferred.
- Ability to work in ambiguous, fast-moving environments with competing priorities.
Benefits
- Full-time employees are eligible for Medical, Dental, and Vision Insurance, paid time off, short- and long-term disability, a 401(k) match, and additional benefits.
- The role offers a collaborative, supportive, and growing environment with opportunities for personal and professional learning and growth.
- The position is full-time and based in Columbus, Ohio.
