Data Analyst

Talentify; Denver (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

Talentify is seeking a Senior Data Analyst / Business Intelligence Engineer in Denver to advance enterprise reporting, analytics, and dashboard modernization initiatives. The role focuses on collecting, validating, and transforming data into actionable insights through advanced reporting, scorecards, dashboards, and automated analytics.

The ideal candidate will command expert Power BI, SQL, and Excel skills and have experience delivering executive-level reporting, KPI scorecards, and visuals

Qualifications

• 5-10 years of experience in data analytics, BI, or reporting roles.
• Expert-level Excel skills and strong SQL/relational database experience.
• Experience building executive-level reporting, KPI scorecards, and dashboards.
• Ability to analyze data from multiple sources and present insights.
• Experience with automated reporting processes and data validation.

Responsibilities

• Collect, analyze, validate, cleanse, and report on business data.
• Develop and maintain Power BI dashboards, scorecards, and reports.
• Build automated reporting solutions to improve efficiency and accuracy.
• Extract data from databases, spreadsheets, and enterprise systems.
• Design ETL processes, SQL queries, stored procedures, and datasets.
• Support reporting modernization and data platform initiatives.
• Create executive KPI scorecards, trend reports, and performance dashboards.
• Consolidate data for weekly, monthly, quarterly reporting and ad hoc needs.
• Respond to leadership requests for analytics and insights.
• Document reporting requirements, logic, and data definitions.
• Collaborate with partners and leadership to improve reporting effectiveness.

Skills

Power BI

SQL

Microsoft Excel (Advanced)

Data Analytics

Dashboard Development

KPI Reporting

Data Visualization

ETL Development

Data Validation

Databricks

Business Intelligence

Reporting Automation

Data Modeling

Trend Analysis

Tools

Databricks

Job description

Overview

We are seeking a Senior Data Analyst / Business Intelligence Engineer to support enterprise reporting, analytics, and dashboard modernization initiatives. This role is responsible for collecting, validating, analyzing, and transforming data into actionable business insights through advanced reporting, scorecards, dashboards, and automated analytics solutions. The ideal candidate will have strong Power BI, SQL, and Excel expertise and experience building executive-level reporting, KPI scorecards, and data visualizations. This position plays a key role in supporting leadership decision-making through analytics, automation, and reporting enhancements.

Responsibilities

• Collect, analyze, validate, cleanse, and report on business and operational data
• Develop, maintain, and enhance Power BI dashboards, scorecards, reports, and visualizations
• Build automated reporting solutions to improve reporting efficiency and accuracy
• Extract and analyze data from multiple sources, including databases, spreadsheets, and enterprise systems
• Design, develop, test, and maintain:
  • ETL processes
  • SQL queries
  • Stored procedures
  • Reporting datasets
• Support reporting modernization efforts and data platform initiatives
• Create executive-level KPI scorecards, trend reporting, and performance dashboards
• Consolidate data for weekly, monthly, quarterly, and ad hoc reporting needs
• Respond to leadership requests for reporting, analytics, and business insights
• Identify trends, performance drivers, and opportunities through data analysis
• Validate reporting outputs and maintain data integrity across reporting solutions
• Document reporting requirements, logic, processes, and data definitions
• Collaborate with business partners and leadership teams to improve reporting effectiveness

Required Qualifications

• 5-10 years of experience in data analytics, business intelligence, or reporting roles
• Expert-level Microsoft Excel skills
• Strong experience with:
  • SQL
  • Relational databases
  • Data extraction and reporting
  • Data validation and cleansing
• Experience developing reports, dashboards, scorecards, and KPI metrics
• Strong analytical, problem-solving, and organizational skills
• Ability to work with complex datasets from multiple sources
• Experience creating automated reporting processes
• Strong written and verbal communication skills
• Ability to explain data insights and reporting results to business stakeholders

Preferred Qualifications

• Power BI development experience
• Databricks experience
• Experience supporting Lakehouse or modern data platform initiatives
• Experience creating interactive dashboards and executive scorecards
• Utility industry experience
• Experience with:
  • Eco Online
  • Arcos
  • Utilimarc
  • Similar enterprise operational systems

Key Skills

• Power BI
• SQL
• Microsoft Excel (Advanced)
• Data Analytics
• Dashboard Development
• KPI Reporting
• Data Visualization
• ETL Development
• Data Validation
• Databricks
• Business Intelligence
• Reporting Automation
• Data Modeling
• Trend Analysis