Senior Business Intelligence Analyst
Summary
Senior BI analyst at a Bethesda, MD consulting firm who leads the design, development, and maintenance of enterprise business intelligence solutions — building advanced dashboards, reports, and data models with Power BI, Power Query, and DAX, and applying AI to enhance analytics. Requires 8+ years of experience, including 3 years with AI technologies.
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!
Skills
As published by greenhouse · 7 questions · 5 written answers
Basics
First Name, Last Name, Email, Phone, Resume/CV, Cover Letter, Location
Short answers (1)
- What are your salary requirements?
Pick from a list (1)
- Will you now, or in the future, require visa sponsorship? This includes if you are on a STEM OPT, J-1, F-1 visa currently.
Written answers (5)
- Describe the most complex Power BI solution you have personally designed or led. What business problem were you solving, what data sources were involved, and what was your role?
- Provide an example of a Power BI solution where you used advanced DAX, Power Query, or data modeling techniques. What made the solution technically challenging and how did you approach it?
- Describe how you have used artificial intelligence or machine learning technologies in connection with business intelligence, analytics, reporting, or decision support. What did you personally contribute?
- Tell us about a time your analysis uncovered a significant trend, risk, or opportunity that was not previously understood. How did you identify it and how did the organization use the insight?
- Describe a situation where you served as the technical lead or subject matter expert for a business intelligence initiative. What decisions were you responsible for and how did you ensure the quality of the final solution?