Power BI Optimization Consultant / Freelance Contractor

External

Coleman Research · Worldwide

Full-timeRemoteToday

AuditingData ModelingDocumentationPhoenixPower BISQL

Cover Letter Connect

Prepare for this interview

Elite

AI-generated questions, company research, and talking points tailored to this role

About the role

At VISASQ/COLEMAN, we connect businesses with hard-to-find expertise through our extensive global network of subject matter experts. VISASQ/COLEMAN is a partnership formed by VisasQ Inc., Asia's leading expert network and the only publicly traded company in our field. Through VisasQ's merger with Coleman Research, a trusted expert service provider with over 20 years of experience, VISASQ/COLEMAN offers tailored consulting solutions for consulting firms, asset management funds, and corporations seeking primary research insights. Our mission is to eliminate barriers to knowledge by facilitating direct exchanges of critical insights across industries. We take pride in utilizing our comprehensive internal database of qualified experts, along with our ability to custom recruit specialists for each project, ensuring our clients receive timely and relevant information to inform their decision-making processes. With offices across Raleigh, NC; Phoenix, AZ; New York, NY; Reading, UK; Hong Kong; Japan; and Bogotá, Colombia, we empower our clients to navigate complex markets and gain a competitive edge. Join us in revolutionizing informed decision-making by transforming how businesses access expert insights. For more information, visit our website .

Responsibilities

Audit large and complex Power BI semantic models to identify opportunities for performance improvement

Evaluate model structure, table relationships, data volume, and overall semantic model design

Identify opportunities to reduce model size, improve refresh reliability, and streamline ongoing maintenance

Recommend and support model optimization strategies within a Power BI Pro environment

Support star schema redesign, normalization, and fact/dimension table separation where appropriate

Review SQL, DAX, M query, query folding, and Power BI-side performance considerations

Use tools such as DAX Studio, Measure Killer, and Tabular Editor to analyze and improve model performance

Provide clear documentation, recommendations, and handover guidance for the internal team

Required Experience

Proven experience optimizing large-scale Power BI semantic models

Strong understanding of Power BI model architecture, DAX, M query, VertiPaq, and query folding

Experience auditing complex or legacy Power BI environments

Practical knowledge of star schema design and fact/dimension modeling

Experience improving refresh reliability, model performance, and maintainability

Ability to work within Power BI Pro constraints without relying on Premium capacity as the primary solution

Strong communication skills and ability to explain technical recommendations clearly

Preferred Experience

Experience working with large, highly utilized Power BI models supporting multiple downstream reports

Experience identifying unused columns, duplicate tables, inefficient queries, and unnecessary data load

Familiarity with thin reports or reports connected through Power BI Service/live datasets

SQL Server view design or database-side optimization experience

Foundational knowledge of data warehouse design

Power BI governance or workspace structure experience

Microsoft PL-300 certification

Prior freelance, consulting, or Microsoft Partner experience

Engagement Details

Part-time or hourly consulting engagement

Estimated project length: approximately 2 months

Expected cadence: regular weekly touchpoints with independent analysis and optimization work between meetings

Remote-friendly

Flexible structure based on consultant availability, proposed approach, and project scope

Expected Deliverables

Initial assessment and findings report

Recommendations for semantic model optimization

At least one optimized version of a current model or model component

Improved refresh reliability

Reduced model size and removal of unnecessary columns/tables where appropriate

Handover documentation for internal maintenance

To Express Interest

Please apply through this job board or send your resume, LinkedIn profile, or a brief summary o

Power BI Optimization Consultant / Freelance Contractor

About the role

Responsibilities

Requirements

Your Match

Company Intel

What employees say

Interested in this role?