Senior BI & Data Solutions Analyst - Power BI & Automation

Colorado Springs Utilities; Colorado Springs (CO); On-site; USD 109,000 - 114,000; Full time

Job summary

Colorado Springs Utilities is seeking a Senior Business Intelligence Analyst to lead analytics, reporting, and data integration efforts within Customer Operations Technology & Analytics. You will design scalable BI solutions, drive automation, and partner with stakeholders to deliver measurable business value.

The role emphasizes enterprise reporting, data governance, and modernization initiatives across systems, with collaboration across technology teams and business units.

Qualifications

• 3–5+ years in business intelligence, analytics, reporting, data engineering, or related disciplines.
• Advanced experience with SQL and relational database development.
• Experience designing and supporting enterprise reporting and analytics solutions.
• Experience developing dashboards and visualizations using Power BI or similar BI tools.
• Experience developing and supporting APIs, integrations, and automated data workflows.
• Proven ability to translate complex business problems into scalable technical solutions.

Responsibilities

• Leading the administration, support, and continuous improvement of customer operations technologies.
• Developing and maintaining enterprise reporting solutions, dashboards, scorecards, and self-service analytics using Power BI, SQL, and modern reporting platforms.
• Designing, developing, and supporting SQL processes, databases, operational tables, and automated data preparation workflows.
• Utilizing APIs, automated data pipelines, integrations, and data services that connect enterprise applications and reporting platforms.
• Supporting Python-based automation, data transformation, and process optimization initiatives.
• Producing and enhancing operational, financial, customer, regulatory, and compliance reporting.
• Analyzing customer usage patterns, operational performance, workload trends, financial impacts, and business metrics to provide actionable recommendations.
• Leading analytical efforts related to predictive models, forecasting, trend analysis, benchmarking, modeling, and strategic decision support.
• Supporting enterprise data governance activities by validating data quality, consistency, completeness, and reporting accuracy.
• Driving automation initiatives that reduce manual effort and improve efficiency across customer operations and business processes.
• Serving as the technical lead for reporting, data integration, and workload management modernization initiatives.
• Partnering with business leaders, technology teams, vendors, and stakeholders to gather requirements, solve complex operational challenges, and implement sustainable solutions.
• Documenting processes and solutions as part of solution delivery.
• Supporting modernization efforts involving enterprise customer information systems, measurement data, Genesys, APIs, Lakehouse technologies, enterprise reporting platforms, and next-generation analytics capabilities.
• Presenting findings, recommendations, and technical solutions to leadership and stakeholder groups clearly.
• Creating documentation, standards, and best practices that support long-term scalability and supportability of reporting and analytics solutions.

Skills

SQL

Reporting & Analytics design

Dashboards & Visualization

APIs & Data Workflows

Analytical problem solving

Education

Bachelor's degree or higher in related field

Tools

Power BI

APIs

Job description

Colorado Springs Utilities is seeking a Senior Business Intelligence Analyst to lead analytics, reporting, and data integration efforts within Customer Operations Technology & Analytics. You will design scalable BI solutions, drive automation, and partner with stakeholders to deliver measurable business value.

The role emphasizes enterprise reporting, data governance, and modernization initiatives across systems, with collaboration across technology teams and business units.