DirectJobHub
Jobs · Colorado

Business Intelligence & Systems Integration Architect

IDR, Inc. · Louisville, CO · 2 wk ago
Hybrid$80–$90/hrFull-time

IDR is seeking a Business Intelligence & Systems Integration Architect to join one of our top clients for an opportunity in Louisville, CO. This role focuses on designing and implementing business intelligence solutions while integrating and streamlining key financial/ERP and operational business systems.

About the Role

In this position, you will architect and integrate financial/ERP and related business systems to improve data flow, connectivity, and usability across teams. You will lead the migration of legacy Microsoft Access databases to Azure SQL, including testing, validation, and preparation for multi-region deployment. Additionally, you will design, build, and rapidly deploy Power BI dashboards, Power Queries, and data integrations to support stakeholder reporting needs.

Responsibilities

  • Architect and integrate financial/ERP and related business systems to enhance data flow and usability.
  • Lead migration of legacy Microsoft Access databases to Azure SQL, including testing and validation for multi-region deployment.
  • Design, build, and deploy Power BI dashboards, Power Queries, and data integrations to meet 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 tools to improve efficiency.

Requirements

  • Experience integrating financial/ERP business systems, including connecting multiple business applications.
  • Strong hands-on experience with Microsoft SQL Server and Access, including migrating Access solutions to SQL Server/Azure SQL.
  • Advanced SQL query development skills with a focus on optimization and analytics/reporting use cases.
  • Advanced Power BI expertise, including building dashboards, data models, and Power Query transformations.
  • Advanced VBA programming experience (Excel and Access required; Microsoft Project preferred) with demonstrated workflow automation capabilities.

Benefits

  • Competitive compensation package
  • Full benefits: Medical, Vision, Dental, and more
  • Employee Stock Ownership Program
  • Dedicated Engagement Manager committed to your success
  • Medical, Dental, Vision, and Life Insurance
  • ClearlyRated's Best of Staffing® Client and Talent Award winner 12 years in a row

Pay

$80-$90/hr

Similar jobs