Remote MSBI & Power BI Data Architect

SFE

United States

Remote

USD 120,000 - 160,000

Full time

14 days+

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

SFE is seeking a MSBI Data Architect/BI Architect for a remote, full-time role. You will design and implement scalable Power BI solutions, build robust ETL with SSIS, and optimize data models for performance.

You will integrate data from on-premises and cloud sources, while maintaining SSRS reports and stakeholder communication. The position requires strong SQL Server expertise, advanced DAX/Power Query skills, and collaboration with offshore teams to deliver end-to-end data warehousing

Qualifications

Strong foundation in MS SQL server.
Create complex SQL queries, view, Stored procedure etc. in SQL server.
Design and implement robust ETL using SSIS.
Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
Integrate data from various sources into Power BI.
Optimize data models for performance.
Develop advanced DAX formulas and Power Query transformations.
Understand and support existing reports in SSRS.

Responsibilities

Coordinate with external technical and Functional team to understand requirements, convert that to technical specifications.
Understand existing source SQL data architecture and rearchitect downstream SQL Datawarehouse based on new source system.
Modify existing standards as well as customized program based on requirement.
Analyze issues and provide resolution.
Work with offshore team to provide the requirements and supervise the overall work.
Testing of application.
Estimate the effort and timelines for enhancements.
Create/update technical specifications.