Analytics Consultant - Business Intelligence (Power BI)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+1 more
Job description
In this contingent assignment, you will support and enhance enterprise analytics capabilities by consulting on moderately complex analytics initiatives and resolving performance, capacity, and connectivity challenges. You will collaborate with platform teams, database administrators, and business partners to deliver scalable, high-performing BI solutions, with a primary focus on Microsoft Power BI., Analytics Consulting & Delivery
- Consult on and contribute to moderately complex analytics initiatives and large-scale planning for analytics deliverables.
- Review, analyze, and resolve analytics challenges requiring in-depth evaluation of variable technical factors.
- Apply a strong understanding of analytics functions, policies, procedures, and compliance requirements to deliver solutions.
Business Intelligence Support
- Manage and resolve enterprise BI support tickets through the CASE system, primarily focused on Microsoft Power BI.
- Diagnose and resolve issues related to:
- Power BI Gateway connectivity and architecture
- Report, dataset, and semantic model access
- Capacity constraints and high system utilization
- Report and query performance issues
- Data source and database connectivity
- Missing or misconfigured gateway drivers
- Platform-level availability and performance issues
Performance Optimization & Best Practices
- Analyze data models, semantic layers, and reporting structures to identify performance bottlenecks.
- Optimize data models, relationships, cardinality, and query paths for efficient performance.
- Provide best-practice guidance for scalable, performant, and reliable BI solutions.
Collaboration & Stakeholder Engagement
- Partner with teams across the organization to troubleshoot and resolve BI and analytics issues.
- Collaborate closely with:
- Power BI Platform teams
- Database Administrators (DBAs)
- Microsoft vendor support
- Act as a technical consultant by meeting directly with users to understand business and technical requirements, recommend solutions, and coordinate implementation efforts., * DAX Studio
- Advanced diagnostics to identify query inefficiencies
- Reviewing, refactoring, and optimizing complex DAX calculations
Work Environment
- Hybrid work model with a balance of onsite collaboration and remote flexibility.
- Fast-paced, enterprise analytics environment supporting mission-critical BI platforms.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively “Judge”) to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge’s Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Requirements
This role requires strong technical expertise, hands-on troubleshooting skills, and the ability to partner effectively with stakeholders to meet analytics deliverables., * 4+ years of analytics experience, or equivalent demonstrated through work experience, consulting, training, military service, or education.
- Hands-on experience supporting or developing analytics and business intelligence solutions.
Preferred Qualifications / Technical Skills Required Experience
- Microsoft Power BI
- Performance Analyzer (visual- and query-level analysis)
- Capacity Metrics App (capacity usage analysis, spike and outage identification)
- Power Query (M)
- Identifying and writing performant M code
- Paginated Reports (SSRS)
- Optimizing report rendering time and understanding CU consumption
- Microsoft Fabric
- Working knowledge of Notebooks, Direct Lake, Data Pipelines, and capacity behavior
- On-Premises Data Gateways
- Architecture, usage requirements, and connectivity troubleshooting
- Data Modeling
- Designing and assessing efficient data models
- Improving relationships, cardinality, and query performance
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on dice.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Making Data Warehouses Fast: A Developer’s Story
Data Engineer Salary UK
Best Companies to work for in London: Top 25 Companies in 2023
Top Big Data Technologies That You Need to Know