BI Functional Analyst

CNX•Denver, CO

4d•$92,000 - $135,000•Hybrid

About The Position

The BI Functional Analyst serves as a strategic liaison between business stakeholders, Business Process Owners, and the IT Business Intelligence team. The role translates complex business needs into clear functional, reporting, and analytics requirements that support scalable BI solutions and measurable business value. It is suited to an analytical, business-minded professional who understands data, reporting platforms, stakeholder engagement, and the connection between business objectives and technology-enabled outcomes. The position is based in Denver, Colorado, with a hybrid-onsite schedule of three days per week. The analyst works with business and technical teams across the organization to improve reporting, analytics, decision-making, and adoption of BI solutions. The role also supports solution design, data validation, user acceptance testing, change management, training, and project delivery. The stated base salary range is $92,000–$135,000 per year, plus incentives aligned with individual and company performance. Actual salary varies based on work location, qualifications, skills, education, experience, and competencies. Benefits available to eligible employees include medical, dental, and vision insurance, an employee assistance program, a 401(k) retirement plan, paid time off, and holidays. The application deadline is November 16, 2026.

Requirements

At least 10 years of experience as a Business Analyst, Functional Analyst, BI Analyst, or in a similar role.
Demonstrated experience partnering with business stakeholders, Business Process Owners, and cross-functional teams.
Strong understanding of Business Intelligence, reporting, data analytics, KPIs, metrics, and business process analysis.
Experience with reporting and visualization platforms such as Power BI, OBIEE, Tableau, or Qlik.
Advanced SQL skills and strong knowledge of relational database management concepts.
Expert-level proficiency in Microsoft Excel.
Strong analytical, problem-solving, communication, facilitation, and documentation skills.
Experience defining business rules, reporting logic, data mappings, functional specifications, and user stories.
Ability to translate complex business needs into clear, actionable requirements for technical teams.
Experience supporting UAT, business validation, defect resolution, and solution adoption.
Experience with modern data platforms such as Azure, Databricks, Snowflake, or Microsoft Fabric.
Experience with ERP systems such as Oracle, SAP, or Microsoft Dynamics.
Ability to manage multiple priorities, communicate effectively with diverse stakeholders, and contribute to successful project delivery.

Responsibilities

Serve as the primary interface between business users, Business Process Owners, and IT Business Intelligence teams.
Build relationships with functional leaders across Sales, Finance, Operations, Supply Chain, Marketing, and other business units.
Understand end-to-end business processes and identify opportunities to improve reporting, analytics, and decision-making.
Facilitate workshops, requirements-gathering sessions, stakeholder interviews, and business process discussions.
Challenge and refine business requirements to promote scalable, standardized, and sustainable BI solutions.
Gather, analyze, document, and prioritize business requirements for reporting and analytics initiatives.
Translate business needs into functional specifications, user stories, business rules, KPIs, metrics, calculations, and reporting logic.
Create process flows, use cases, data mappings, and functional documentation.
Ensure requirements are complete, testable, aligned with business objectives, and ready for technical delivery.
Collaborate with BI Developers, Data Engineers, Architects, Product Owners, and other technical teams to design reporting and analytics solutions.
Participate in solution design discussions and ensure business and functional requirements are reflected in technical designs.
Review dashboards, reports, and analytics solutions for usability, accuracy, consistency, and business value.
Promote reuse of existing data assets, common business definitions, and standardized reporting practices.
Analyze source systems, data flows, and data transformations to support accurate reporting outcomes.
Perform data analysis to validate business requirements and confirm reporting logic.
Identify data quality issues and partner with Data Governance and IT teams to support resolution.
Ensure reports and dashboards reflect approved business definitions, KPIs, and metrics.
Develop test scenarios, business validation criteria, and UAT support materials.
Coordinate and support User Acceptance Testing, including defect tracking and resolution follow-up.
Validate that delivered BI solutions meet business expectations and agreed requirements.
Support rollout, change management, and adoption of new BI solutions.
Conduct demonstrations, user training, and knowledge-sharing sessions.
Develop user documentation and training materials for dashboards, reports, and self-service analytics.
Work with Product Owners and Project Managers to prioritize requirements, manage backlogs, and respond to changing business priorities.
Provide status updates, communicate risks, and support delivery within agreed scope and timelines.