> Markdown version of [/jobs/ext/2359965-business-intelligence-systems-integration-architect](https://www.wearedevelopers.com/jobs/ext/2359965-business-intelligence-systems-integration-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).

---

# Business Intelligence & Systems Integration Architect

- **Company:** IDR, Inc.
- **Location:** Louisville, CO, United States
- **Salary:** $166,400.0 - $187,200.0
- **Contract:** Permanent contract
- **Skills:** Microsoft Access, Microsoft Excel, Business Software, Business Systems, Databases, Data Integration, Relational Databases, Microsoft SQL Server, SQL Azure, Power BI, Data Streaming, Systems Integration, Freeform SQL, Powerquery, Vba Programming Language, Tools for Reporting
- **Published:** August 11, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=86c65e0a0cff5418

## About the Role

* Experience integrating financial/ERP business systems, including connecting and interfacing multiple business applications.
 * Strong hands-on experience with Microsoft SQL Server and Access, including converting or migrating Access solutions to SQL Server/Azure SQL.
 * Advanced SQL query development skills with the ability to optimize and support analytics/reporting use cases.
 * Advanced Power BI expertise, including building dashboards, data models, Power Query transformations, and rapid deployment of reporting solutions.
 * Advanced VBA programming experience (Excel and Access required; Project preferred) with demonstrated workflow automation capabilities.

## Description

* Architect and integrate financial/ERP and related business systems to improve data flow, connectivity, and usability across teams.
 * Lead migration of legacy Microsoft Access databases to Azure SQL, including testing, validation, and preparation for multi-region deployment.
 * Design, build, and rapidly deploy Power BI dashboards, Power Queries, and data integrations to support stakeholder reporting needs.
 * Develop and optimize advanced SQL queries and support relational database administration in Microsoft SQL Server.
 * Streamline and automate business workflows and analysis using VBA and other tooling to improve efficiency and reduce manual effort.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)