Senior Data Warehouse Architect - SQL Server & Kimball

Nationwide IT Services; Virginia (MN); On-site; USD 150,000 - 190,000; Full time

Job summary

Nationwide IT Services is seeking a Data Warehouse Subject Matter Expert (SME) to provide senior technical leadership in design, development, optimization, and support of enterprise data warehouses.

You will lead large-scale SQL Server environments, dimensional modeling, and analytics solutions using SSIS/SSRS/SSAS, Power BI, and Python/R. On-site work at DEA offices in Merrifield, VA and Arlington, VA with Secret Clearance required.

Qualifications

• 15+ years of total database experience.
• 12+ years of SQL Server experience within the 15 years.
• 5+ years of experience with Agile development methodologies.
• 3+ years with Microsoft tools such as SSIS, SSRS, SSAS, Power BI, and ADO, and with modern data tools.
• 3+ years of dimensional analysis in Kimball-style EDW with not less than 500 tables and a billion rows.
• Secret Clearance required.

Responsibilities

• Serve as SME for enterprise data warehouse architecture, design, implementation, and performance optimization.
• Provide deep technical expertise for large-scale SQL Server environments with multi-terabyte data and billion-row datasets.
• Design and optimize data warehouse solutions using Kimball-style dimensional modeling.
• Lead development of fact and dimension structures in large data warehouse environments.
• Develop and maintain ETL/ELT pipelines and analytics using Microsoft data tools.
• Utilize SSIS, SSRS, SSAS, Power BI, and ADO for data integration and reporting.
• Apply Python, R, and cloud services to enhance data processing and analytics.
• Collaborate with cross-functional teams in Agile environments for iterative delivery.
• Analyze data requirements, troubleshoot complex issues, and recommend improvements.
• Ensure scalable, maintainable data warehouse solutions aligned with objectives.

Skills

Data warehousing

SQL

Agile

Tools

SSIS

SSRS

SSAS

Power BI

ADO

Python

R

Cloud services

Job description

Nationwide IT Services is seeking a Data Warehouse Subject Matter Expert (SME) to provide senior technical leadership in design, development, optimization, and support of enterprise data warehouses.

You will lead large-scale SQL Server environments, dimensional modeling, and analytics solutions using SSIS/SSRS/SSAS, Power BI, and Python/R. On-site work at DEA offices in Merrifield, VA and Arlington, VA with Secret Clearance required.