Senior Data Analyst

Position Summary:  

Contributes to MacroHealth’s new Fairness Benchmarking product. The Fairness Benchmarking product uses a catalog of benchmarks to help clients determine what they are paying for services (claims) relative to local and national competitors, hotspot key areas for improvements, and identify, quantify and recommend course of action.

The candidate will be working within Data team and supporting the team goal by utilizing a wide variety of tools and techniques to build Fairness Benchmarking reports. Supports both internal and external customers by providing valuable data analysis and insight on current and potential business outcomes. Prioritizes and manages workflow and outcomes. Works collaboratively with both internal and external stakeholders to improve reporting, drive improved efficiencies and support process improvements.

Key Relationships: Data Analyst, Data Engineer, Data Scientist, Software Engineer, Product Manager 

Key Accountabilities:

Dashboard and Reporting Development:

• Design, develop a suite of dashboards and reports for Fairness Benchmark product
• Organize and automate the reports
• Design, build and maintain self-service reporting portal

Data Management and Collaboration:

• Collaborate with data engineers to evaluate, ingest and validate various data sources
• Document all systems-related processes and flows

Data Insights and Presentation:

• Provide data insights on demand and proactively to assist operations
• Present analytics and insights to customers

Continuous Improvement and Technology Adoption:

• Stay current with new technologies, constantly evolving our systems to advance the maturity and capabilities of our platforms

Knowledge, Skills and Abilities:

• Experience with healthcare data (e.g. health payments, authorizations, eligibility, electronic health records)
• Experience with existing and emerging health care interoperability technologies and standards (e.g. X12, NCPDP, FHIR)
• Experience with creating and application of healthcare benchmarks and measures across cost, quality and satisfaction
• Experience working for or with healthcare providers/plans/payers particularly in data warehousing and business intelligence
• Excellent knowledge of SQL, Power BI or equivalent BI tools
• Experience using Python
• Strong creative problem-solving skills and critical thinking competencies
• Excellent written and verbal communication skills
• Excellent organizational skills and attention to detail
• Ability to prioritize and exercise time management
• Ability and willingness to stay on top of current trends and industry knowledge
• Fits in a people-first culture of teamwork and respect

Required Education and Experience: 

• Experience working with healthcare data sets, US healthcare claims and EDI x12/NCPDP transactions
• 5+ years of experience with SQL
• 2+ years of experience with Power BI or equivalent BI tools
• 8+ years of experience with data analytics and working with enterprise data
• Bachelor's degree or equivalent practical experience
• Experience with healthcare data (e.g. health payments, authorizations, eligibility, electronic health records)
• Experience with existing and emerging health care interoperability technologies and standards (e.g. X12, NCPDP, FHIR)
• Experience with creating and application of healthcare benchmarks and measures across cost, quality and satisfaction
• Experience working for or with healthcare providers/plans/payers particularly in data warehousing and business intelligence

• Experience using Python
• Experience working with US healthcare benchmarks (CMS, TIC/MRF, APCD, others)

Salary: $115,000 to $130,000

Location: Fully remote within the US

• Act as one team with fellow MacroMates and customers
• Value humility, low ego, and collaboration
• Maintain an All for One, One for All attitude   

Deliver on Promises:

• Do the right thing
• Do what you say you will do
• Work with a sense of urgency and transparency

• Challenge yourself and others to think boldly, bigger, and into the future
• Lead with a Growth Mindset
• Act as a thought leader for the healthcare industry

MacroHealth is an equal opportunity employer.