Business Intelligence Lead

prosource.it

Business Intelligence Lead managing the design and maintenance of data models and reporting for global enterprise clients. Collaborating with stakeholders to drive data-driven decision-making and operational efficiency within the company.

Posted 5/9/2026full-timeDenver • Colorado, Texas • 🇺🇸 United StatesSenior💰 $120,000 - $135,000 per yearWebsite

Tech Stack

Tools & technologies

D3.jsSQL

About the role

Key responsibilities & impact

Design, build, and maintain scalable data models and reporting structures supporting interventions analytics.
Develop and maintain complex T-SQL queries, stored procedures, and scripts to support dashboards, reports, and ad hoc analysis.
Own the development, enhancement, and modernization of Power BI, SQL reporting, and embedded visualization outputs (e.g., D3, HighCharts).
Partner with business and data-domain owners to translate requirements into robust analytical solutions.
Establish and evolve business metrics and KPIs to support operational decision-making.
Deliver timely ad hoc analyses and visualizations to support interventions leadership.
Lead the redesign and conversion of legacy reports and databases into modern, maintainable solutions.
Apply AI-enabled tools (e.g. Claude) to enhance data exploration, diagnostics, and insight development.
Collaborate closely with the Data & Analytics team to support enterprise reporting and analytics initiatives.
Be the SME for Wellview to help support the intervention team

Requirements

What you’ll need

7+ years of experience in Data & Analytics, Business Intelligence, or Reporting roles.
Strong experience in Peloton Wellview (or similar)
Strong SQL expertise, including complex query development and performance optimization.
Hands-on experience with Power BI
Experience in data modeling, analysis, testing, development, and deployment.
Experience supporting large-scale data environments with batch and/or near-real-time data.
Oil & gas industry experience strongly preferred; upstream experience preferred.
Experience leveraging AI-enabled tools (e.g., Claude) to support analytics and decision-making.
Strong analytical skills with high attention to detail.

Benefits

Comp & perks

medical
dental
vision
long term disability
short term disability
401k contribution
paid holidays
PTO

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

T-SQLcomplex query developmentperformance optimizationdata modelingdata analysisdata testingdata developmentdata deploymentPower BIAI-enabled tools

Soft Skills

analytical skillsattention to detailcollaborationcommunicationleadership