Data Engineer 2

freedmanhealth; United States; On-site; USD 110,000 - 145,000; Full time

Job summary

Freedman HealthCare, LLC is seeking a Data Engineer II to design, develop, and maintain data pipelines, databases, and analytics frameworks that drive healthcare quality and equity. You will partner with health policy experts and analysts to transform complex data into actionable insights.

The role emphasizes data integrity, cross-functional collaboration, and staying current with data engineering best practices to support varied healthcare datasets and dashboards for stakeholders.

Qualifications

• Bachelor's or Master's degree in healthcare administration, data science, or statistics preferred.
• 5+ years of experience in SQL recommended.
• 5+ years of experience as a data analyst in healthcare (claims) preferred.

Responsibilities

• Develop and maintain data pipelines, ETL processes, and workflows to collect, clean, and transform data from various sources.
• Ensure data integrity, quality, and accuracy across processing lifecycle.
• Analyze healthcare claims data to identify patterns, trends, and insights.
• Generate reports, dashboards, and visualizations for nontechnical stakeholders.
• Design, develop, and maintain databases, data models, and schemas.
• Collaborate with cross-functional teams to translate business requirements into data solutions.
• Stay up to date with data engineering trends and best practices.
• Identify opportunities to improve data infrastructure and analytics capabilities.

Skills

SQL

Python

R

Excel

Tableau

Power BI

Data visualization

Data analysis

5+ years SQL experience

5+ years healthcare data analysis

Education

Bachelor's or Master's degree in healthcare administration, data science, or statistics

Tools

AWS

Azure

Google Cloud

Job description

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.