Senior Data Architect

πŸ•’ November 4

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $165k - $185k / year

⏰ Full Time

πŸ”΄ Lead

🚰 Data Engineer

Where this job comes from

Posted on GovCIO's careers page β†—GovCIO's careers page, not through a job board

First seen by Remote Rocketship November 4

Still open on GovCIO's site. Checked 2 hours ago.

Apply Now
Logo of GovCIO

GovCIO

1001 - 5000 employees

Founded 2010

πŸ’Ό Consulting

πŸ›οΈ Government

πŸ”’ Cybersecurity

Consulting β€’ Government β€’ Cybersecurity

GovCIO is a technology company that specializes in providing digital solutions and IT services to government agencies. Their focus is on transforming public sector operations through innovative technology, thereby enhancing the efficiency and effectiveness of government services.

πŸ“‹ Description

β€’ Analyze source systems including VistA, Millennium, ADR, MVI, Geospatial, PIT, and Exam Management to define data structures, relationships, business rules, and PHI/PII classification β€’ Design and maintain tables, views, and stored procedures supporting CDW data ingestion β€’ Build conceptual, logical, and physical data models for scalable enterprise data integration β€’ Perform source-to-target analysis and mapping, documenting transformations and integration requirements β€’ Partner with data stewards, SMEs, DBAs, ETL developers, and source extraction teams across the data domain lifecycle β€’ Support maintenance outages and query optimization β€’ Create and deploy data models and metadata using the CDW Metadata Repository (MDR) Editor β€’ Contribute to tool enhancements improving team workflows β€’ Develop and maintain Data Domain Design Documents, including overviews, ERDs, source inventories, data lineage flows, business rules, and source-to-target mappings β€’ Ensure compliance with CDW standards, data governance policies, security requirements, and enterprise architecture guidelines β€’ Investigate and resolve data quality issues through root-cause analysis β€’ Respond to Helpdesk requests with technical and business teams

🎯 Requirements

β€’ Bachelor's degree in Computer Science, Engineering, or related field with 14+ years of relevant experience; or a Master's degree with 10+ years of experience; or equivalent professional experience β€’ Intermediate to advanced knowledge of healthcare data domains, with expertise analyzing clinical business operations and data interactions in Millennium β€’ Ability to identify and handle PHI/PII across Millennium, VistA, ADR, MVI, GeoSpatial, PIT, Exam Management, and related systems β€’ Advanced proficiency in T-SQL, including 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 database design skills, including ERDs, data lineage flows, and conceptual/logical/physical data modeling β€’ Expertise in scalable data architecture methodologies: Kimball, Inmon, and Data Vault β€’ Familiarity with Embarcadero or TOAD β€’ Experience investigating and resolving data quality issues and collaborating with extraction teams β€’ Familiarity with data governance processes, data catalogs, and CDW standards compliance β€’ Experience working with SMEs, DBAs, ETL developers, and source extraction teams β€’ Experience supporting maintenance outages, query optimization, and data security compliance β€’ Outstanding documentation skills, producing DDDs, ERDs, source-to-target mappings, and process documentation β€’ Ability to obtain and maintain a suitability/Public Trust

Apply Now

πŸ“Š Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

πŸ•’ November 4

Dragos, Inc.

501 - 1000

🏭 Manufacturing

πŸ“¦ Logistics

πŸ’Ό Consulting

Principal Data Engineer building scalable data pipelines and analytics for Dragos, a global xOT cybersecurity leader. Modernizing data systems and enabling threat detection across industrial networks.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $225k / year

πŸ’° $74M Series D - Dragos on 2023-09

⏰ Full Time

πŸ”΄ Lead

🚰 Data Engineer

πŸ•’ November 3

Cedar

11 - 50

🏠 Real Estate

πŸ’Έ Finance

πŸ’³ Fintech

Principal Data Engineer leading scalable data architecture, pipelines, and metrics reliability. Building AI data foundations for Cedar’s healthcare financial platform.

πŸ•’ November 3

ReSource Pro

5001 - 10000

πŸ’Ό Consulting

πŸ“¦ Logistics

πŸ₯ Healthcare

Senior data engineer building scalable pipelines, lakehouse platforms, semantic models, and dashboards. Modernizing data services for ReSource Pro’s insurance-industry clients.

πŸ•’ November 2

GEICO

10,000+ employees

🚘 Automotive

πŸ’Ό Consulting

πŸ₯ Healthcare

Senior Manager leading GEICO’s data platforms, pipelines, and shared data products. Building business-domain data mesh architecture while enabling trusted Analytics and AI datasets.

πŸ•’ November 2

TISTA Science and Technology Corporation

1001 - 5000

πŸ’Ό Consulting

πŸ₯ Healthcare

πŸ”’ Cybersecurity

Data Architect designing VA supply-chain lakehouse and database solutions for TISTA Science and Technology. Establishing governance and tuning SQL Server, Oracle, Postgres, and Databricks environments.

Developed byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok