GovCIO · 1 day ago
DW/BI Architect (Remote)
United States
Full-time
Remote
Senior Level, Lead/Staff
$160K/yr - $164K/yr
15+ years expGovCIO is looking for a highly skilled and experienced Senior Data Engineer / Data Architect to join our team. In this role, you will be responsible for architecting and developing enterprise data models, metadata governance frameworks, ETL pipelines, and analytics platforms to support data governance, performance measurement, and business intelligence solutions for VA client.
ConsultingIT InfrastructureIT ManagementManagement Consulting
No H1B
U.S. Citizen Only
Responsibilities
Design, build, and maintain relational data models in SQL Server 2019-2022 Enterprise to support metadata governance, request submissions, audit tracking, version control, and production publishing pipelines
Architect multi-stage relational models for metadata lifecycle management, including intake submissions, staging, review, audit trail snapshots, approval tracking, and final publishing structures
Develop and maintain SSIS packages and ETL pipelines for metadata ingestion, transformation, validation, auditing, staging, and publishing processes supporting multi-layered data warehouse architectures
Apply hybrid cloud integration expertise utilizing Azure SQL, Azure Data Factory, Databricks, Synapse Analytics, and Azure Fabric to develop and support scalable data pipelines and platform modernization initiatives
Collaborate closely with business analysts, Power BI developers, Power Apps developers, and VA stakeholders to gather requirements and translate functional business needs into scalable technical data solutions
Build Power Platform integrations (Power BI, PowerApps, Power Automate) connecting to SQL Server and cloud data services; implement identity-based row-level filtering using Power Platform user context for submission-level security and role-based access control
Maintain fully auditable data models including metadata change tracking, approval lineage, governance version control, and compliance documentation to support ATO certification, PMO audit packages, and federal regulatory standards
Conduct advanced query tuning, stored procedure optimization, index management, query plan evaluation, blocking and deadlock resolution, and performance troubleshooting across large relational data platforms
Develop and maintain comprehensive technical documentation including data dictionaries, entity-relationship diagrams (ERDs), data flow diagrams, process workflows, swimlane diagrams, system architecture diagrams, metadata catalogs, data lineage models, dependency mappings, and PMO governance documentation packages
Provide full lifecycle production support including ETL pipeline monitoring, SSIS failure remediation, long-running job resolution, scheduled job support, SQL Server troubleshooting, and incident management across on-premises and hybrid data environments
Qualification
Required
Bachelor's degree in Computer Science, Information Technology, or related field with 15+ years (or commensurate experience)
10+ years of experience in SQL Server database development, data architecture, and ETL design
8+ years of experience in data warehouse architecture, metadata governance, and analytics platforms
Deep hands-on experience with SQL Server 2019-2022 Enterprise (on-prem), SSIS, T-SQL, and relational database design
Cloud experience with Azure or AWS platforms
Proficiency in Azure Data Factory, Databricks, Synapse Analytics, and hybrid cloud integration for modernizing ETL pipelines
Experience with Azure DevOps for version control, CI/CD pipeline automation, and release management
Experience with additional RDBMS platforms including Oracle, PostgreSQL, MySQL
Power Platform experience integrating Power BI, PowerApps, and Power Automate into enterprise reporting and data governance solutions
SharePoint Online experience supporting integrated metadata governance processes
Knowledge of metadata-driven design patterns, audit trail frameworks, and enterprise governance architecture aligned to federal PMO standards
Strong technical documentation skills, including ERDs, data dictionaries, data flows, and process mapping
Strong experience in performance tuning, query optimization, and long-running job remediation
Excellent troubleshooting, problem-solving, and analytical skills across full data pipeline lifecycle
Familiarity with federal compliance frameworks (ATO, FISMA, NIST 800-53, FedRAMP)
Clearance Required: Suitability/Public Trust
Preferred
Microsoft Fabric platform (Power BI Premium, Data Warehousing, RLS security models)
Additional experience with MongoDB or NoSQL stores
Python, PowerShell, or other scripting for ETL and automation
IT security certifications (e.g., CISSP, CISM, GIAC) helpful
Prior experience working within federal data governance or VA PMO environments
Benefits
Employee Assistance Program (EAP)
Corporate Discounts
Learning & Development platform, to include certification preparation content
Training, Education and Certification Assistance*
Referral Bonus Program
Internal Mobility Program
Pet Insurance
Flexible Work Environment
Company
GovCIO
GovCIO is a business consulting firm that focuses on cyber security, digital, data, management and mission services, and IT services.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Lynn Oakes
Sr. Vice President, Contracts at GovCIO
Andre Green
Vice President Special Operations Support Solutions (SOSS) GOVCIO
Recent News
Washington Technology
2026-01-14
2026-01-14
Washington Technology
2025-11-26
Company data provided by crunchbase