Remote MSBI Data Architect: Power BI & Data Warehouse

SFE; Davenport (IA); Remote; USD 90,000 - 130,000; Full time

Job summary

SFE in Davenport, IA is seeking an MSBI Data Architect to design and maintain data architectures, ETL pipelines, and BI solutions.

You will develop complex SQL queries, SSIS ETL, Power BI reports, and data models, while optimizing performance and enabling self-service analytics for stakeholders.

Candidates should have strong communication skills and experience coordinating with offshore/onsite teams in an agile environment.

Qualifications

• Strong foundation in MS SQL Server.
• Ability to create complex SQL queries, views, and stored procedures in SQL Server.
• Design and implement robust ETL using SSIS.
• Develop scalable and reusable Power BI solutions following best practices.
• Integrate data from on-prem and cloud sources into Power BI.
• Optimize data models for performance and fast data retrieval.
• Develop advanced DAX formulas and Power Query transformations.
• Understand and support existing SSRS reports and develop new ones.
• Industry experience in metal/manufacturing is a plus.
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills for non-technical audiences.
• Ability to work independently and in a team.

Responsibilities

• Coordinate with external technical and functional teams to capture requirements and translate into technical specs.
• Understand current source SQL data architecture and rearchitect downstream SQL Datawarehouse per new sources.
• Modify existing standards and customize programs as needed.
• Analyze issues and provide resolutions.
• Collaborate with offshore team to define requirements and supervise work.
• Test the application.
• Estimate effort and timelines for enhancements.
• Create/update technical specifications.

Skills

MS SQL server

Complex SQL queries

ETL design and implementation

Power BI development

Data integration

Data modeling optimization

DAX & Power Query

SSRS reports

Industry domain knowledge (manufacture

Analytical & problem solving

Communication & presentation

Team collaboration

Tools

SSIS

Power BI

SSRS

SQL Server

Job description

SFE in Davenport, IA is seeking an MSBI Data Architect to design and maintain data architectures, ETL pipelines, and BI solutions.

You will develop complex SQL queries, SSIS ETL, Power BI reports, and data models, while optimizing performance and enabling self-service analytics for stakeholders.

Candidates should have strong communication skills and experience coordinating with offshore/onsite teams in an agile environment.