More jobs:
Business Intelligence & Systems Integration Architect
Job in
Louisville, Boulder County, Colorado, 80028, USA
Listed on 2026-08-22
Listing for:
IDR, Inc.
Full Time
position Listed on 2026-08-22
Job specializations:
-
IT/Tech
Data Engineering, Data Analyst, Business Systems & Technology Analysis, Database Administrator
Job Description & How to Apply Below
IDR is seeking a Business Intelligence & Systems Integration Architect to join one of our top clients for an opportunity in Louisville, CO. In this role, you will design and implement business intelligence solutions while integrating and streamlining key financial/ERP and operational business systems. This is a great fit for someone who enjoys solving complex data and workflow challenges, accelerating reporting adoption, and enabling reliable, global use of modernized data platforms.
Position Overview for the Business Intelligence & Systems Integration Architect:- 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.
- 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.
- Competitive compensation package
- Full Benefits;
Medical, Vision, Dental, and more! - Opportunity to get in with an industry leading organization.
- 25+ Years of Proven Industry Experience in 4 major markets
- Employee Stock Ownership Program
- Dedicated Engagement Manager who is committed to you and your success.
- Medical, Dental, Vision, and Life Insurance
- Clearly Rated's Best of Staffing® Client and Talent Award winner 12 years in a row.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×