MSBI Data Architect - Power BI & Data Warehouse Lead

Ztek Consulting INC; Davenport (IA); On-site; USD 90,000 - 120,000; Full time

Job summary

Ztek Consulting INC in Davenport, IA seeks an experienced BI/ETL Developer to design and implement robust SQL, ETL, and Power BI solutions. You will integrate data from multiple sources, optimize data models, and develop advanced DAX/Power Query transformations for complex calculations and reporting.

The role requires strong analytical and communication skills, with ability to work independently and within a team in a manufacturing-oriented environment.

Qualifications

• Strong experience with MS SQL Server and complex SQL queries.
• Experience designing ETL with SSIS.
• Develop scalable Power BI solutions and data models.
• Integrate data from on-prem, cloud, and external APIs.
• Strong analytics and problem solving capabilities.
• Excellent communication and stakeholder presentation skills.
• Ability to work independently and in teams.
• Knowledge of SSRS reporting.

Responsibilities

• Coordinate with external teams to convert requirements to technical specifications.
• Understand and rearchitect downstream SQL Datawarehouse based on new source system.
• Modify existing standards and customize programs as needed.
• Analyze issues and provide resolutions.
• Work with offshore team to provide requirements and supervise the overall work.
• Testing of application.
• Estimate the effort and timelines for enhancements.
• Create/update technical specifications.

Skills

MS SQL Server

Complex SQL Queries

Stored Procedures

ETL with SSIS

Power BI development

Data integration

Data modeling

DAX expressions

Power Query

SSRS reporting

Analytical thinking

Communication skills

Tools

SQL Server

SSIS

Power BI

SSRS

Job description

Ztek Consulting INC in Davenport, IA seeks an experienced BI/ETL Developer to design and implement robust SQL, ETL, and Power BI solutions. You will integrate data from multiple sources, optimize data models, and develop advanced DAX/Power Query transformations for complex calculations and reporting.

The role requires strong analytical and communication skills, with ability to work independently and within a team in a manufacturing-oriented environment.