> Markdown version of [/jobs/ext/4564092-ms-bi-data-architect](https://www.wearedevelopers.com/jobs/ext/4564092-ms-bi-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# MS BI Data Architect

- **Company:** Q1 Technologies, Inc.
- **Location:** Aurora, IL, United States (Remote available)
- **Contract:** Permanent contract
- **Skills:** Databases, Data Architecture, Extract Transform Load (ETL), Data Transformation, Data Retrieval, Microsoft SQL Server, Power BI, Cloud Services, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Freeform SQL, Powerquery, Web Api
- **Published:** November 4, 2026
- **Apply:** https://www.thejobnetwork.com/job/69e9ce38-7895-480e-9949-386136dc2e62/ms-bi-data-architect

## About the Role

o Domain knowledge of metal and manufacturing industry is a big plus
o Strong analytical and problem-solving skills.
o Excellent communication and presentation skills, with the ability to convey technical concepts to non-technical audiences.
o Ability to work effectively both independently and as part of a team

## Description

o Create complex SQL queries, view, Stored procedure etc. in SQL server.
o Design and implement robust ETL using SSIS.
o Develop scalable and reusable Power BI solutions that adhere to best practices and industry standards.
o Integrate data from various sources, including on-premises databases, cloud services, and external APIs, into Power BI.
o Optimize data models for performance, ensuring efficient data retrieval and processing.
o Develop advanced DAX formulas and Power Query transformations to create complex calculations and data transformations .
o Understanding and support existing reports in SSRS and developing new reports.