Healthcare Data Analyst
At Amalgamated Life Insurance Company, we consider our employees our greatest asset. We provide a positive work environment that rewards professionalism, hard work and a commitment to the highest standards of customer service. Each employee is given the opportunity to develop their skills, advance and achieve personal fulfillment. A competitive compensation package, coupled with a congenial work atmosphere, has made Amalgamated Life an organization which consists largely of longstanding, loyal employees.
The Actuarial Department is seeking a motivated, analytically driven recent graduate to join the team as a Healthcare Data Analyst. This position has been created to support the department’s transition to a modern cloud-based analytics platform (Databricks) and to expand data reporting and quality capabilities across the organization.
The successful candidate will work directly with the Director of Health Underwriting, developing deep familiarity with our data environment, business processes, and regulatory requirements. This role is designed to grow with the individual — as the platform matures and the candidate builds competency; responsibilities will naturally expand to reflect demonstrated capability.
Reporting & Analytics
- Fulfill report requests from internal departments using Tableau and Excel, ensuring accuracy and timely delivery.
- Develop and maintain recurring reports against Databricks Gold layer analytics tables using SQL.
- Respond to ad hoc data inquiries from stakeholders across at least 10 internal departments.
- Document report logic, data definitions, and field mappings to support institutional knowledge.
Data Quality & Validation
- Execute data quality and validation testing across multiple source systems to ensure integrity of healthcare, premium, and claims data.
- Monitor Databricks data quality dashboards and escalate anomalies for review.
- Assist in developing and maintaining validation rules and reconciliation procedures.
- Participate in validation of Databricks pipeline outputs against source data to confirm accuracy.
Platform & Operations
- Learn and work within the Databricks environment, Unity Catalog, and medallion data architecture (Bronze, Silver, Gold layers).
- Support data operations tasks including pipeline monitoring, error review, and routine maintenance.
- Contribute to process documentation and standard operating procedures for data workflows.
- Collaborate with the Director on platform development tasks as skills develop.
Qualifications
- Bachelor’s degree in a quantitative field (Statistics, Mathematics, Actuarial Science, Computer Science, Data Science, Economics, Finance, or similar).
- Demonstrated proficiency in SQL or Python — one is sufficient; both is a plus.
- Strong analytical mindset: ability to reason through data problems, identify discrepancies, and ask the right questions.
- Proficiency in Microsoft Excel including formulas, pivot tables, and data organization.
- Ability to work semi-independently: comfortable owning assigned tasks and checking in regularly.
- High attention to detail and commitment to data accuracy in a regulated environment.
- Exposure to Tableau or similar BI/visualization tools (coursework, internship, or personal projects accepted).
- Academic or internship experience with healthcare, insurance, financial, or other regulated industry data.
- Familiarity with cloud platforms (AWS, Azure, or GCP) or interest in learning.
- Experience with data validation, reconciliation, or quality assurance concepts.
- Coursework or self-study in data engineering, databases, or analytics platforms.
Working Environment
- Direct mentorship from the Director of Health Underwriting with regular structured check-ins.
- Access to enterprise-grade data infrastructure serving at least 10 internal departments.
- Exposure to sensitive healthcare and financial data — HIPAA compliance training provided and required.
- Technically evolving environment: comfort learning new tools and adapting to platform changes is essential.
- Growth-oriented culture where demonstrated performance creates expanded responsibility and visibility
Why This Role
This is a meaningful opportunity for a recent graduate to enter the healthcare analytics field with immediate, hands-on exposure to enterprise data. The Actuarial Department is mid-migration from a legacy environment to a modern cloud analytics platform — a significant investment by the organization. The person hired into this role will gain practical experience with regulated industry data,