Analysis Skills, Best Practices, Business Intelligence, Consulting, Data Analysis, Data Management, Data Modeling, Data Sets, Database Administration, Desktop PC, Identify Issues, Metrics, Microsoft Product Family, Multiplatform/Cross-Platform, Performance Analysis, Power BI, Problem Solving Skills, Query Optimization, Refactoring, SQL Server Reporting Services (SSRS), Technical Consulting
Analytics Consultant
Location: Charlotte NC, Des Moines, IA and Dallas, TX Duration: 12 Months+
Technologies & Expertise
- Microsoft Power BI-Performance Analyzer-Analyze visual level and query level performance in Power BI Desktop
- Capacity Metrics App-Identify capacity usage patterns, spikes, and outage causing operations
- Power Query (M)-Distinguish between performant and non performant M code
- Paginated Reports (SSRS)-Optimize report rendering time and understand CU consumption
- Microsoft Fabric-Working knowledge of Notebooks, Direct Lake, Data Pipelines, and capacity related behaviors
- On Premises Data Gateways
- Diagnose connectivity failures
- Understand gateway architecture and usage requirements
- Data Modeling-Design and assess efficient data models-Improve relationships, cardinality, and query paths for optimal performance
- DAX Studio (Bonus Skill)-Use advanced diagnostics to identify query inefficiencies and bottlenecks-Review, optimize, and refactor poorly performing DAX calculations
Core Responsibilities
- Manage and resolve enterprise BI support tickets through the CASE system, with the majority focused on Microsoft Power BI.
- Troubleshoot and resolve issues including:
- Power BI Gateway connectivity
- Report and dataset access
- Capacity and performance constraints
- Database connectivity problems
- Report design and implementation questions
- High system capacity usage
- Missing or misconfigured gateway drivers
- Platform level issues impacting availability or performance
- Partner with various teams across the bank to:
- Analyze semantic models and reporting structures
- Identify and resolve performance bottlenecks (slow loads, high CU usage)
- Provide best practice guidance for scalable and performant reporting solutions
- Collaborate closely:
- Power BI Platform Team
- Database Administrators (DBAs)
- Microsoft Vendor Support
- Act as a technical consultant by meeting directly with users to:
- Fully understand business and technical problems
- Recommend and implement effective solutions
- Coordinate across platform and vendor teams when required