Senior Data Analyst, Data Architecture

Health Care Cost Institute Inc.; Washington (District of Columbia); Hybrid; USD 145,000 - 175,000; Full time

Benefits offered by this job

403B retirement plan

Health insurance

Job summary

Health Care Cost Institute in Washington, DC is seeking a Senior Data Analyst, Data Architecture to advance its mission. You will own data quality, oversee multiple inbound feeds, and design data marts from a data warehouse to support downstream reporting.

The role requires 10+ years of data experience, strong SQL, and experience with ETL and data warehousing platforms. It offers a $145k–$175k salary, remote eligibility with East Coast hours, and benefits including a 403B and health insurance.

Qualifications

• 10+ years of data experience, with at least 5 years in data quality across multiple feeds
• Experience designing data marts to support downstream reporting
• Strong SQL and relational database design skills
• Bachelor's degree in computer science, information systems, health informatics, or related field, or equivalent combination of education and practical experience
• Experience with ETL tools, data warehousing platforms, and data quality/monitoring frameworks
• Excellent communication of quantitative findings to non-quantitative audiences
• Strong organization and time management, capable of managing multiple projects
• Experience analyzing claims data and generating leadership reports

Responsibilities

• Develop strategic planning of dataset assets and infrastructure management
• Own data quality management across inbound data feeds into the data warehouse
• Design, build, and maintain data marts to support reporting
• Document data architecture, data lineage, and data quality rules
• Partner with data warehouse vendor to maintain data quality standards and monitor flow
• Evaluate and recommend improvements to data architecture and warehouse design
• Communicate with internal and external stakeholders to ensure valid results for downstream reporting
• Develop, implement and refine data quality reports for internal and external audiences
• Support organizational operational activities (proposals, liaising with data users)

Skills

SQL

Data modeling

Data analysis

Communication

Project management

Education

Bachelor's degree in CS/IS/Health informatics or related field

Tools

ETL tools

Data warehousing platforms

Job description

About HCCI

The Health Care Cost Institute (HCCI) is an independent, non-profit research institute located in Washington, D.C. with a mission to use data and analytics to improve the US health care system. Employers, policymakers, and researchers rely on HCCI’s claims data to better understand the health care system, evaluate existing and emerging coverage and payment policies, and assess health care quality. Our multi-disciplinary team produces timely, policy-relevant reports and analyses in an academic but fast-paced environment.

Join the Team that Informs the Health Care Decision Making

We are looking for a Senior Data Analyst, Data Architecture to join our dynamic team working to advance HCCI’s mission. This position is ideal for candidates with extensive experience working with health care claims data and who are seeking opportunities to conduct high-profile analytics. The Senior Data Analyst, Data Architecture will support HCCI’s efforts to provide employers and other stakeholders information to help them make informed decisions to improve the value of health care.

The Senior Data Analyst, Data Architecture will:

• Work with HCCI’s leadership to develop and implement strategic planning of dataset assets and infrastructure management.
• Own data quality management across multiple inbound data feeds into a claims data warehouse, including data flow monitoring and validation; work with data submitters to resolve data integrity issues.
• Design, build, and maintain data marts from a claims data warehouse to support downstream reporting and analytic needs.
• Document data architecture, data lineage, and data quality rules for the claims data warehouse and downstream data marts.
• Partner with HCCI’s data warehouse vendor to maintain data quality standards, controls, and monitor flow across the data pipeline.
• Work with HCCI’s data warehouse vendor to evaluate and recommend improvements to data architecture and warehouse design to improve reliability and scalability.
• Communicate and coordinate with internal and external stakeholders, including other analysts, data visualization specialists, and senior leaders, to ensure valid and interpretable results for measures in downstream reporting.
• Develop, implement and refine data quality reports for internal audiences and external stakeholders.
• Support HCCI’s organizational operational activities as needed (e.g. help write proposals, liaise with external data users, etc.)

In our candidates, we look for:

• At least 10 years of experience working with or analyzing data, with at least 5 years of experience managing data quality across multiple data feeds in a data warehouse or similarly large relational data environment; experience with claims data warehouses preferred.
• Proven ability to design and build data marts in a data warehouse to support downstream reporting.
• Strong SQL and relational database design skills, with the ability to diagnose and resolve complex data integrity issues.
• Bachelor’s degree in computer science, information systems, health informatics, or related field, or equivalent combination of education and practical experience.
• Experience with ETL/ETL tools, data warehousing platforms, and data quality/monitoring frameworks.
• Ability to communicate clearly, verbally and in writing, especially about quantitative findings for non-quantitative audiences.
• Strong organizational and time management skills, with the ability to prioritize and manage multiple projects at once.
• A proactive, detail-oriented problem solver with a collegial approach who can serve as a resource for other team members.
• Experience analyzing claims data and generating reports for organizational leadership.

This is a full-time, exempt, position with an annual salary range from $145,000 to $175,000, depending on experience. HCCI also provides competitive benefits to full-time employees, including 403B retirement with employer contribution and health insurance.

This position is remote eligible, with occasional travel to the Washington, DC office. Preference will be given to applicants located in states where HCCI is currently registered as an employer – Washington, DC, Maryland, Virginia, Pennsylvania, New York, Massachusetts and Minnesota. Regardless of work location, this position requires East Coast hours.

HCCI is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, marital or family status, or any other status protected under applicable law. All qualified applicants will receive equal consideration for employment regardless of the state in which they reside.

HCCI participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9.