Analytics - Analytics Consultant 3 - Contingent

Artech LLC

CHARLOTTE, NC

Apply

JOB DETAILS

SALARY

$45–$50 Per Hour

SKILLS

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, Performance Analysis, Power BI, Problem Solving Skills, Query Optimization, Refactoring, SQL Server Reporting Services (SSRS), Technical Consulting

LOCATION

CHARLOTTE, NC

POSTED

24 days ago

Job Title: Analytics Consultant
Location: Charlotte NC, Des Moines ,IA and Dallas, TX
Duration: 12 Months+
Job Description
Technologies & Expertise
1. 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
2. Power Query (M)-Distinguish between performant and non performant M code-Paginated Reports (SSRS)-Optimize report rendering time and understand CU consumption
3. Microsoft Fabric-Working knowledge of Notebooks, Direct Lake, Data Pipelines, and capacity related behaviors
4. On Premises Data Gateways
5. Diagnose connectivity failures
6. Understand gateway architecture and usage requirements
7. Data Modeling-Design and assess efficient data models-Improve relationships, cardinality, and query paths for optimal performance
8. 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:
o Power BI Gateway connectivity
o Report and dataset access
o Capacity and performance constraints
o Database connectivity problems
o Report design and implementation questions
o High system capacity usage
o Missing or misconfigured gateway drivers
o Platform level issues impacting availability or performance
• Partner with various teams across the bank to:
o Analyze semantic models and reporting structures
o Identify and resolve performance bottlenecks (slow loads, high CU usage)
o Provide best practice guidance for scalable and performant reporting solutions
• Collaborate closely :
o Power BI Platform Team
o Database Administrators (DBAs)
o Microsoft Vendor Support
• Act as a technical consultant by meeting directly with users to:
o Fully understand business and technical problems
o Recommend and implement effective solutions
o Coordinate across platform and vendor teams when required

About the Company

Artech LLC

Resume Resources

Free Resume Templates Free Resume Builder