Data Engineer 2

Data Engineer II

• Freedman HealthCare LLC (FHC) is a growing Massachusetts-based consulting firm with a national
• footprint. We have helped more than 30 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 Data Engineer II 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
• will collaborate with cross-functional teams, including health policy experts, analysts, and healthcare
• stakeholders, to identify and address data-related challenges and opportunities.

• Duties/Responsibilities:
• •Develop and maintain 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 nontechnical stakeholders
• •Design, develop, and maintain databases, data models, and schemas for efficient storage and
• retrieval of data
• •Collaborate with 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
• •Knowledge of US healthcare policy, trends, and factors such as eligibility, utilization, cost, and equity
• •Knowledge of state government role in healthcare
• •Expertise in data analysis and data visualization using tools such as SQL, Python, R, Excel, or similar
• •Expertise in data profiling, manipulation, and transformation using tools like Pandas, SQL, 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
• •5+ years of experience in SQL
• •5+ 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:
• •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.