Healthcare Data Solutions Architect

About the Role

Role Department: Delivery

Reports to: AVP, Integration Engineering

The Healthcare Data Solutions Architect role is ideal for an experienced data professional eager to put their domain knowledge and engineering expertise to work in a collaborative, mission-driven environment. Your efforts to organize, transform, and automate the flow of healthcare data will unlock actionable insights for our clients, enabling them to move from raw data to meaningful analysis in hours rather than weeks. You'll interpret and integrate client payer claims, ADT, clinical/EMR, provider billing, and other operational datasets into the Ursa Core Data Model, building reusable, enduring data models that clients rely on to drive clinical, operational, and financial decisions.

You will work closely with Ursa colleagues across analytics engineering, product development, and customer success, as well as directly with client teams including data architects, analysts, clinicians, and other healthcare professionals to understand their data and their needs. You'll leverage Ursa Health's data platform to design and build integration pipelines, data models and increasingly, work alongside AI-assisted tooling that accelerates the process.

About You

• You're looking for a role that will allow you to apply your experience to a "blank canvas" to design and create elegant and enduring data models.

• You have great attention to detail and enjoy the process of investigating and interpreting raw data. You anticipate dataset-specific inconsistencies and edge cases before they become problems.

• You are a consultative partner by nature, comfortable working directly with a range of stakeholders (clinical, operational, data/technology, and actuarial) to understand how data was generated, what its limitations are, and how it will be used.

• You are looking to join a collaborative team that is passionate about healthcare and strives to build best in class healthcare analytics.

• You're curious by nature and excited to use technologies that allow you more time to explore, test, and iterate on the data model you design rather than worry about maintaining fragile code.

• You have a deep understanding of health information systems, medical claims and/or billing data across payors and/or clinical data from your experience as a data architect and/or engineer.

• You balance technical rigor with pragmatic elegance building solutions that are durable without being overcomplicated.

• You've worked with AI tools and have developed a clear-eyed sense of where they help and where they don't especially in a domain where the cost of a wrong answer is high.

Responsibilities

• Lead the integration of healthcare data packages including medical claims, pharmacy claims, revenue cycle billing, ADT, clinical/EMR, FHIR and value-based care financial datasets into custom or Ursa Studio standard data models through collaboration with client and Ursa Health teams.

• Own end-to-end data solution architecture for ingesting, transforming, standardizing, and integrating complex healthcare datasets from multiple sources.

• Design and maintain scalable, standardized healthcare data models.

• Operationalize rigorous validation checks that preserve data integrity, prevent analytics degradation, and maintain client trust.

• Engage with clients to understand their data, its limitations, and analytical use cases, enabling actionable insights and informed business decision making.

• Collaborate with analytics engineers, customer success, and product teams to align delivery with client expectations and to surface product opportunities informed by client needs and data behavior.

• Partner with customer's leadership team to define and execute strategic roadmaps for enterprise data architecture, integration modernization and AI adoption.

• Thoughtfully leverage AI-assisted tooling to accelerate and improve delivery, applying domain knowledge and human judgment to ensure sound output.

• Keep your knowledge current regarding data security and privacy procedures and policies. Comply with HIPAA procedures and collaborate with the Incident Response Team as directed.

Qualifications

Required 

• Bachelor’s degree. 

• 4+ years of experience working with any of the healthcare data domains ( e.g. claims, provider billing, clinical or pharmacy).

• Familiarity with healthcare data integration concepts, common data sources (payer data files or clinical/ EMR systems), data formats (claims, provider billing or HL7 ADT/ FHIR).

• 4+ years implementing and maintaining ETL/ELT pipelines and processes. 

• 4+ years of experience in end-to-end data integration (data discovery, scoping, data cleansing and curation, analysis, transformation, validation and maintenance). 

• Demonstrated expertise in SQL, relational database technologies (e.g., Snowflake, Microsoft SQL Server, Oracle, PostgreSQL), enterprise data modeling with a strong focus on designing scalable, optimized and reusable data architectures.

• Availability to work during U.S. Eastern (EST) or Central Time (CST) business hours.

Preferred 

• Knowledgeable in healthcare interoperability / integration engines.

• Experience with ELT or workflow orchestration tools such as Fivetran, dbt, SQLMesh, Dagster, or Airflow. While this role applies those concepts within Ursa Studio rather than using those tools directly, the ability to think in systems is a plus.

• Experience building data models that support healthcare outcome measurement. Familiarity with value-based care data and financial models a plus. 

• Working understanding of Python or JavaScript to manipulate and transform large datasets and data science fundamentals.

• Experience working with AI tools in a professional context, with the judgment to apply them appropriately in healthcare data environments where output accuracy is critical.

• Demonstrated ability to drive organizational change, influence leadership, communicate effectively across technical and business stakeholders, deliver measurable business value through strategic technology initiatives.

Location

• United States, Position is Remote

Please apply to this job on your actual computer, not through a VPN, with your actual email address and actual phone number. We promise we will not misuse this personal information! This should allow your application to sail through our fraud filters, which are unfortunately struggling to differentiate real candidates from the avalanche of fraudulent candidates we're seeing. If any of these fraud alerts are triggered, we will verify that your LinkedIn page has a robust, credible history and we will reach out directly through LinkedIn DM to confirm your identity. Please be on the lookout for this message!