DW/BI Architect

About This Role

This role involves architecting and developing enterprise data models, metadata governance frameworks, ETL pipelines, and analytics platforms for a VA client. The successful candidate will support data governance, performance measurement, and business intelligence solutions using their expertise in data modeling, ETL development, cloud data services, and metadata-driven architecture.

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.
• Maintain fully auditable data models including metadata change tracking, approval lineage, governance version control, and compliance documentation to support ATO certification.
• Conduct advanced query tuning, stored procedure optimization, index management, query plan evaluation, blocking and deadlock resolution, and performance troubleshooting.
• Develop and maintain comprehensive technical documentation including data dictionaries, ERDs, data flow diagrams, process workflows, system architecture diagrams.
• 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.

Requirements

• Bachelors degree in Computer Science, Information Technology, or related field
• 15+ years overall experience (or commensurate experience)
• 10+ years experience in SQL Server database development, data architecture, and ETL design
• 8+ years 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
• Experience with Azure DevOps for version control, CI/CD pipeline automation, and release management
• Experience with RDBMS platforms including Oracle, PostgreSQL, MySQL
• Power Platform experience integrating Power BI, PowerApps, and Power Automate
• SharePoint Online experience supporting integrated metadata governance processes
• Knowledge of metadata-driven design patterns, audit trail frameworks, and enterprise governance architecture
• 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
• Familiarity with federal compliance frameworks (ATO, FISMA, NIST 800-53, FedRAMP)
• Suitability/Public Trust Clearance Required

Qualifications

• Bachelors degree in Computer Science, Information Technology, or related field
• 15+ years of experience (or commensurate experience) with a Bachelor's degree, including 10+ years in SQL Server database development, data architecture, and ETL design, and 8+ years in data warehouse architecture, metadata governance, and analytics platforms.

Nice to Have

• 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)
• Prior experience working within federal data governance or VA PMO environments

Skills

* Required skills