MacroHealth's mission is to make buying and selling healthcare services simple and powerful.

We provide an Intelligent Health Market-as-a-Service platform that enables Payers, Providers, and Health Market Partners to Optimize and Connect their unique healthcare ecosystems.

Our Optimization solutions provide analytics and connectivity focused on optimizing healthcare pricing and payments. We provide health Payers with data enhancement, analytical tools, and market benchmarking to design Provider network solutions that are optimized for each unique member group. With our Connect solutions, a single EDI/API implementation can connect our clients with their chosen Providers, Provider Networks and industry Partners.

Our team has a vision to create Intelligent Health Markets that dramatically improve healthcare cost, quality and access for everyone.

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.

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

Required Education and Experience:

• Experience working with healthcare data sets, US healthcare claims and EDI x12/NCPDP transactions
• Experience working for or with healthcare providers/plans/payers particularly in data warehousing and business intelligence
• 5+ years of experience with SQL
• 2+ years of experience with PowerBI
• 8+ years of experience with data analytics and working with enterprise data
• Bachelor's degree or equivalent practical experience
• Experience using Python