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.

Pulled from the full job description

• Health insurance
• Vision insurance
• Dental insurance, * Competitive compensation package
• Full Benefits; Medical, Vision, Dental, and more!
• Opportunity to get in with an industry leading organization.

Why IDR?

• 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
• ClearlyRated’s Best of Staffing® Client and Talent Award winner 12 years in a row.

$80-$90/hr #LI-HYBRID

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., By submitting this application, you acknowledge and consent to engage in conversation with a recruiter or virtual recruiter from IDR Inc. and its affiliates, and contracted partners by receiving calls, AI-generated calls, texts, or emails to the contact information provided. Please ensure that the contact information provided is one you are permitted to use and are authorized to receive such messages on. If your contact information changes during the application process, please notify IDR promptly. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can opt-out of receiving communications at any time by saying or replying with “STOP” and “HELP” for help. To view our privacy policy, you may access it here (https://www.idr-inc.com/privacy-policy/).