Senior Data Engineer
Freedman HealthCare LLC (FHC) is a growing Massachusetts-based consulting firm with a national footprint. We have helped more than 25 states build and use healthcare data to improve care quality, affordability, and equity. We aim to be the partner of choice for policymakers and changemakers who use data to transform healthcare and promote health, wellbeing, and justice. Freedman HealthCare is an entrepreneurial, fast-paced, and growing consultancy with a culture of teamwork, open communication, and meeting exacting standards.
Job Summary:
The Senior Data Engineer plays a crucial role in extracting, analyzing, and interpreting complex data sets to drive informed decisions to improve healthcare quality, affordability, and equity. You will be responsible for designing, developing, and maintaining data pipelines, databases, and analytical frameworks. You play a lead role on cross-functional teams, including health policy experts, analysts, and healthcare stakeholders, to identify and address data-related challenges and opportunities.
Duties/Responsibilities:
- Oversee development and maintenance of data pipelines, ETL processes, and workflows to collect, clean, and transform data from various sources into usable formats
- Ensure data integrity, quality, and accuracy throughout the data processing lifecycle
- Analyze and interpret healthcare claims data and related data sets to identify patterns, trends, and insights
- Generate reports, dashboards, and visualizations to communicate findings effectively to non-technical stakeholders
- Design, develop, and maintain databases, data models, and schemas for efficient storage and retrieval of data
- Lead cross-functional teams to understand business requirements and translate them into data solutions
- Stay up to date with emerging technologies, industry trends, and best practices in data analysis, engineering, and visualization
- Identify opportunities to improve data infrastructure, processes, and analytics capabilities
Required Skills/Abilities:
- Deep knowledge of health data, multi-payer databases, public healthcare payers, claims processing, and claims data analytics
- Deep knowledge of US healthcare policy, trends, and factors such as eligibility, utilization, cost, and equity
- Deep knowledge of state government role in healthcare
- Expertise in data analysis and data visualization using tools such as SQL, Python, R, Excel, or similar, and the ability to mentor others
- Expertise in data profiling, manipulation, and transformation using tools like Pandas, SQL, SAS or similar
- Mastery of data visualization tools like Tableau or Power BI
- Familiarity with data modeling, database management, and cloud-based data solutions (e.g., AWS, Azure, Google Cloud)
- Solid understanding of statistical analysis, data mining, and machine learning concepts
- Excellent problem-solving, critical thinking, and analytical skills, with a keen attention to detail
- Strong communication and collaboration abilities, with the capacity to present complex findings in a clear and concise manner
Education and Experience Requirements:
- Bachelor's or Master’s degree in healthcare administration, data science, statistics, or equivalent work experience preferred
- 7+ years of experience in SQL
- 7+ years of experience as a data analyst in the healthcare industry, preferably in claims
Physical Requirements:
- Prolonged periods sitting at a desk and working on a computer
Note:
- Vaccination for COVID-19 is required and FHC will consider accommodations for disability- and religious-based reasons.
- The job description provided above is a general outline and may be subject to modifications based on specific organizational requirements.
Freedman HealthCare, LLC is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. We strongly encourage applications and inquiries from women, LGBTQIA+ identified persons, Black, Indigenous, People of Color, people with disabilities, and others from historically underrepresented communities. We believe that embracing diversity in our workplace is essential to achieving the best results for our clients and as an organization.
Top Skills
What We Do
FHC was established in 2005 to create a more efficient health care system and ensure broad community buy-in to a future vision of health care delivery. Through FHC’s work with state health organizations, healthcare providers, payers and policy makers, the firm assists diverse stakeholder groups in adopting policies and programmatic changes that can drive quality improvement and cost containment.
FHC understands both the clinical and business aspects of a more transparent system of care, and has demonstrated expertise with health planning, data analytics, measurement methodology, and public reporting. Clients benefit from FHC’s objectivity, senior-level expertise, market knowledge, and creative problem solving. FHC’s analytical proficiency allows the firm to help clients determine the most efficient and effective methods to measure and improve the health care system.
FHC is unaffiliated with any vendor or technical solutions provider. Therefore, the firm offers unbiased assistance to clients. FHC identifies emerging “best practices,” encourages clients to build on others’ successes, and helps them navigate through more complex territory
