MSBI Data Architect | Remote Power BI, SQL & SSIS

Acestack; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Acestack is seeking a MSBI Data Architect to design and implement data solutions for a remote, full-time role. You will optimize data models, develop robust ETL pipelines with SSIS, and build scalable Power BI dashboards that adhere to best practices.

You will collaborate with cross-functional teams to integrate data from on-prem and cloud sources, ensuring performance with advanced DAX and SSRS reporting while maintaining strong communication with stakeholders.

Qualifications

• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills.
• Ability to work independently and as part of a team.

Responsibilities

• Coordinate with external technical and functional teams to understand requirements and translate into technical specs.
• Understand existing source SQL data architecture and rearchitect downstream SQL Data Warehouse based on new source system.
• Modify existing standards and customize programs based on requirements.
• Analyze issues and provide resolutions.
• Work with offshore team to provide requirements and supervise overall work.
• Testing of application.
• Estimate effort and timelines for enhancements.
• Create/update technical specifications.

Job description

Acestack is seeking a MSBI Data Architect to design and implement data solutions for a remote, full-time role. You will optimize data models, develop robust ETL pipelines with SSIS, and build scalable Power BI dashboards that adhere to best practices.

You will collaborate with cross-functional teams to integrate data from on-prem and cloud sources, ensuring performance with advanced DAX and SSRS reporting while maintaining strong communication with stakeholders.