Business Intelligence Analyst
$100,000–$115,000 year
Remote · Chicago, Illinois, United States or Denver, Colorado, United States
Job Summary
Business Intelligence Analyst responsible for transforming complex project data into dashboards and reports for Project Development Services, serving as the reporting and data quality SME. Partner with PMO Director and leadership to elevate data capabilities, automate reporting, and deliver insights for client and executive audiences. Responsibilities include performance reporting, KPI tracking, data quality validation, automation of repetitive tasks using Power Automate and Excel, developing and maintaining dashboards in Azara, Smartsheet, and related tools, and cross-functional collaboration to standardize data definitions and reporting processes.
Required Qualifications
- Bachelor's degree or higher in Information Systems, Data Analytics, Statistics, Economics, Computer Science, or related field
- 3-5 years of BI development experience
- Excellent communication and presentation skills
- Advanced Excel (Power Query, pivot tables)
- Experience with reporting, dashboards, data quality, and stakeholder management
- Preferred: CMMS, Tableau, PowerPivot, Smartsheet, Azara, data governance concepts
- Eligibility to work in the United States without sponsorship (no visa sponsorship)
Desired Qualifications
- Bachelor's degree or higher in Information Systems, Data Analytics, Statistics, Economics, Computer Science, or related field
- 3-5 years of experience in business intelligence development with focus on reporting and dashboard creation
- Strong written and verbal communication and presentation skills
- Advanced native Excel skills including formulas, pivot tables, and Power Query
- Experience with data visualization tools and BI platforms
- Proven ability to manage stakeholder expectations and drive data-driven decisions
- Experience with Power Automate, Smartsheet, and Azara (preferred)
- Understanding of data quality management and data governance (preferred)
- Experience developing and maintaining data dictionaries and data definitions (preferred)
- Ability to translate complex data findings into actionable insights
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.