Senior Business Intelligence Analyst
At a glance
Senior Data Analysis & BI role at Black Canyon Consulting. Bethesda · no salary stated · we estimate $113,700–$164,639 across the United States.
Black Canyon Consulting has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Lead the build and upkeep of BI solutions, from data models to reports and dashboards in Power BI
- Turn business needs into analytical solutions, using Power Query and DAX to shape data and calculations
- Find patterns and relationships in complex datasets, then develop methods that yield useful business insights
- Apply AI where it can strengthen analytics, and assess solution performance to identify improvements
- Guide BI work across projects and share findings with stakeholders, including leadership
What you bring
- At least eight years of relevant professional experience, including three years working with AI technologies
- Advanced Power BI, Power Query and DAX skills, plus experience building complex dashboards, reports and visualizations
- A strong foundation in data modeling and BI architecture, with experience analyzing complex datasets
- Experience translating business requirements into reporting solutions and communicating analytical findings to varied audiences
Who this fits
This senior technical role suits someone who can lead BI initiatives across multiple assignments while continuing to design and develop analytical solutions. You’ll work with business stakeholders, technical teams, analysts and organizational leaders. The role is based in Bethesda, United States.
From the employer
Overview
Black Canyon Consulting (BCC) is searching for a Senior Business Intelligence Analyst to lead the design, development, implementation, and enhancement of enterprise business intelligence solutions. The Senior Business Intelligence Analyst will use Microsoft Power BI and related technologies to transform complex data into actionable insights that support strategic and operational decision-making.
Job Description
The Senior Business Intelligence Analyst will serve as a technical expert responsible for leading complex business intelligence and data analytics initiatives. This position will design and develop advanced reporting, dashboards, data models, and analytical solutions using Microsoft Power BI, Power Query, DAX, and related Microsoft technologies.
The Senior Business Intelligence Analyst will analyze complex datasets, identify patterns and trends, develop innovative analytical approaches, and translate findings into meaningful business insights. This position will also evaluate solution performance, recommend improvements, and provide technical leadership across multiple assignments.
The role requires experience applying artificial intelligence technologies to analytics, business intelligence, or related data initiatives and the ability to identify opportunities where AI can enhance analytical capabilities and decision support.
Required Skills
- 8+ years of relevant professional experience
- At least 3 years of experience related to artificial intelligence technologies
- Extensive experience designing, developing, implementing, and maintaining business intelligence solutions
- Advanced experience with Microsoft Power BI
- Advanced experience with Power Query
- Advanced experience developing DAX calculations and measures
- Experience developing complex dashboards, reports, and data visualizations
- Strong understanding of data modeling and business intelligence architecture
- Experience analyzing complex datasets and identifying meaningful patterns, trends, and relationships
- Experience translating business requirements into analytical and reporting solutions
- Experience evaluating business intelligence solution performance and recommending improvements
- Ability to develop analytical methodologies that produce actionable business insights
- Experience serving as a technical expert across multiple projects or initiatives
- Strong analytical, problem-solving, and data interpretation skills
- Strong written and verbal communication skills
- Ability to communicate complex analytical findings to technical and non-technical stakeholders
Desired Skills
- Experience integrating AI or machine learning capabilities into business intelligence or analytics solutions
- Experience with Microsoft Fabric or other Microsoft data and analytics technologies
- Experience with advanced data modeling and semantic models
- Experience working with large or complex enterprise datasets
- Experience developing executive dashboards and decision-support tools
- Experience establishing business intelligence standards, governance, or development practices
- Experience mentoring or providing technical guidance to analysts or developers
- Experience with SQL, data warehouses, data lakes, or similar data platforms
- Experience supporting enterprise-wide analytics initiatives
- Experience influencing organizational strategy through data-driven analysis
Job Responsibilities
- Lead the design, development, implementation, and maintenance of business intelligence solutions
- Develop advanced reports, dashboards, data models, and visualizations using Microsoft Power BI
- Develop and optimize Power Query transformations and DAX calculations
- Translate business and organizational requirements into effective analytical solutions
- Analyze complex datasets to identify patterns, trends, relationships, and actionable insights
- Develop innovative analytical methodologies and approaches
- Apply AI technologies where appropriate to enhance analytics and business intelligence capabilities
- Evaluate business intelligence solution performance and identify opportunities for improvement
- Recommend significant technical or analytical changes that support project and organizational objectives
- Serve as a technical expert across multiple business intelligence and analytics initiatives
- Provide technical leadership and guidance related to business intelligence technologies and practices
- Develop data-driven insights that support strategic and operational decision-making
- Collaborate with business stakeholders, technical teams, analysts, and organizational leadership
- Ensure analytical solutions are accurate, reliable, maintainable, and aligned with organizational requirements
- Support development of business intelligence standards, methodologies, and best practices
- Evaluate emerging business intelligence, analytics, and AI technologies
- Help shape the future direction of organizational business intelligence capabilities and practices
- Communicate analytical findings and recommendations to leadership and other stakeholders
Benefits and Salary
We attract the best people in the business with our competitive benefits package that includes medical, dental and vision coverage, 401k plan with employer contribution, paid holidays, vacation, and tuition reimbursement.
If you enjoy being a part of a high performing, professional service and technology focused organization, please apply today!