Senior Data Warehouse & BI Engineer

Elevait Solutions; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

Elevait Solutions seeks a Senior Data Warehouse & BI Engineer in Charlotte, NC to lead end-to-end DW/BI solutions. You will design and optimize T-SQL, ETL workflows with SSIS, and deliver Power BI reports, collaborating with DBA for performance and data integrity.

Requirements include 5+ years with Microsoft BI tools, SDLC experience, and US citizenship for DoD-related work. This role may involve on-site operations in a manufacturing setting.

Qualifications

• 5+ years designing, developing, and supporting data warehouse and BI solutions
• 5+ years with Microsoft BI technologies: SQL Server, SSRS, SSIS, and SSAS
• Strong T-SQL development, including stored procedures, functions, performance tuning, and query optimization
• Experience building data warehouse, ETL, and end user reporting solutions such as Power BI within an SDLC process
• US citizenship required for this Department of Defense related position (ITAR); no immigration sponsorship available

Responsibilities

• Lead end to end delivery of data warehouse and BI solutions, from requirements through design, development, testing, and support
• Develop and maintain T-SQL stored procedures, functions, and queries for reporting and data integration
• Design, build, and support ETL processes that bring manufacturing and enterprise data into the warehouse
• Research, analyze, and troubleshoot data issues in stored procedures and SSRS or Power BI reports
• Partner with the DBA team on server health, query performance, and indexing improvements
• Develop and support data migration scripts for project and operational needs
• Contribute to the ongoing evolution of data warehouse architecture and best practices
• Keep data warehouse and analytics code in version control per SDLC standards
• Support operationally critical work, including flexibility for global support hours when needed

Skills

T-SQL development

SSIS ETL design

Power BI/SSRS reporting

Education

Bachelor's degree in IT/CS/Engineering

Tools

SQL Server

SSRS

SSAS

Job description

Elevait Solutions seeks a Senior Data Warehouse & BI Engineer in Charlotte, NC to lead end-to-end DW/BI solutions. You will design and optimize T-SQL, ETL workflows with SSIS, and deliver Power BI reports, collaborating with DBA for performance and data integrity.

Requirements include 5+ years with Microsoft BI tools, SDLC experience, and US citizenship for DoD-related work. This role may involve on-site operations in a manufacturing setting.