Senior Data Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Conduct an analysis of source systems such as VistA, Millennium, ADR, MVI, Geospatial, PIT, and Exam Management to establish data structures, relationships, business rules, and classifications of PHI/PII.

• Develop and manage tables, views, and stored procedures that facilitate CDW data ingestion.

• Create conceptual, logical, and physical data models for a scalable enterprise data integration system.

• Execute source-to-target analysis and mapping, documenting transformation processes and integration requirements.

• Collaborate with data stewards, subject matter experts (SMEs), database administrators (DBAs), ETL developers, and source extraction teams throughout the data domain lifecycle.

• Assist in maintenance outages and optimize queries.

• Design and implement data models and metadata utilizing the CDW Metadata Repository (MDR) Editor.

• Contribute to improvements in tools to enhance team workflows.

• Create and maintain Data Domain Design Documents, which include overviews, Entity Relationship Diagrams (ERDs), source inventories, data lineage flows, business rules, and source-to-target mappings.

• Ensure adherence to CDW standards, data governance policies, security protocols, and enterprise architecture guidelines.

• Investigate and resolve data quality concerns through root-cause analysis.

• Address Helpdesk inquiries in collaboration with technical and business teams.

⛳️ Requirements

• A Bachelor's degree in Computer Science, Engineering, or a related field with a minimum of 14 years of relevant experience; or a Master's degree with at least 10 years of experience; or equivalent professional experience.

• Intermediate to advanced understanding of healthcare data domains, with a focus on analyzing clinical business operations and data interactions within Millennium.

• Capability to identify and manage PHI/PII across systems like Millennium, VistA, ADR, MVI, GeoSpatial, PIT, Exam Management, and others.

• Advanced expertise in T-SQL, encompassing queries, stored procedures, functions, indexing, partitioning, query optimization, and performance tuning.

• Experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and Power BI.

• Strong skills in database design, including ERDs, data lineage flows, and conceptual/logical/physical data modeling.

• Proficiency in scalable data architecture methodologies such as Kimball, Inmon, and Data Vault.

• Familiarity with Embarcadero or TOAD.

• Experience in investigating and resolving data quality challenges and working collaboratively with extraction teams.

• Understanding of data governance processes, data catalogs, and compliance with CDW standards.

• Proven experience collaborating with SMEs, DBAs, ETL developers, and source extraction teams.

• Experience in supporting maintenance outages, optimizing queries, and ensuring data security compliance.

• Excellent documentation skills, producing Data Domain Design Documents (DDDs), ERDs, source-to-target mappings, and process documentation.

• Ability to obtain and maintain suitability/Public Trust clearance.

🏝️ Benefits

• Competitive salary and comprehensive benefits package.

• Opportunities for professional development and continued education.

• Collaborative and inclusive work environment.

• Flexible work arrangements to support work-life balance.