Power BI Developer Consultant

Skillikz; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled Power BI Developer Consultant to create and optimize dashboards that meet complex business requirements. In this dynamic role, you will collaborate with stakeholders to deliver high-performance visualizations and streamline data processes. Your expertise in DAX, data modeling, and real-time data solutions will be crucial in enhancing analytical workflows. This opportunity offers a chance to work in a fast-paced environment, where your contributions will directly impact the success of data-driven decision-making. If you are passionate about data visualization and eager to make a difference, this role is perfect for you.

Qualifications

• 4+ years of experience developing Power BI dashboards for enterprise clients.
• Proficiency in DAX, data modeling, and real-time data solutions.
• Strong ability to analyze business requirements and deliver BI solutions.

Responsibilities

• Design, develop, and optimize Power BI dashboards for complex business needs.
• Collaborate with stakeholders to deliver intuitive visualizations.
• Document data models and provide training for effective dashboard adoption.

Skills

DAX

Power BI

Data Modeling

SQL

Analytical Skills

Communication

Project Delivery

Education

Microsoft Certified: Data Analyst Associate (PL-300)

Snowflake SnowPro Core or Azure Data Fundamentals

Tools

Power BI Desktop/Service

DAX Studio

SQL Profiler

Snowflake

Azure Synapse

Databricks

Azure DevOps

Git

Job description

Job Overview:

As a Power BI Developer Consultant, you will design, develop, and optimize Power BI dashboards to meet complex business requirements, ensuring high performance, scalability, and real-time data capabilities. You'll collaborate with business stakeholders, data engineers, and IT teams to deliver intuitive visualizations, streamline data refresh processes, and enhance analytical workflows. This role requires expertise in DAX, data modeling, and integration with modern data platforms.

Role & Responsibilities:

Dashboard Development:

• Build and maintain Power BI reports and dashboards with dynamic visuals, unified layouts, and cross-filtering capabilities.
• Implement user-friendly interfaces for business users, ensuring seamless navigation and data exploration.

Performance Optimization:

• Optimize DAX calculations and measures to improve query speed and dashboard responsiveness.
• Troubleshoot and resolve performance bottlenecks using tools like DAX Studio and Power BI Performance Analyzer.

Data Modeling:

• Design efficient data models with star schemas, optimized joins, and consolidated dimensions.
• Ensure data integrity and scalability for large datasets (millions of rows).

Real-Time Data Solutions:

• Configure incremental refresh and real-time sync mechanisms (e.g., Change Detection, Push Datasets) to minimize latency.
• Integrate dashboards with APIs and streaming data sources for live analytics.

Data Integration:

• Connect Power BI to diverse data sources (e.g., SQL databases, cloud platforms like Snowflake, Azure).
• Enable query folding and optimize data pipelines for performance.

Stakeholder Collaboration:

• Gather requirements from business users and translate them into technical specifications.
• Present dashboards and insights to clients, incorporating feedback iteratively.

Documentation and Support:

• Document data models, DAX logic, and refresh configurations for knowledge transfer.
• Provide training and support to end-users for effective dashboard adoption.

Person Specification for Power BI Developer Consultant

Essential Criteria:

Experience:

• 4+ years developing Power BI dashboards for enterprise clients, ideally in finance, insurance, or data-heavy sectors.
• Hands-on experience optimizing DAX measures and resolving performance issues in large-scale reports.
• Track record of delivering real-time or near-real-time BI solutions (e.g., live sync, streaming data).

Technical Skills:

• Power BI Expertise: Proficient in Power BI Desktop/Service, building unified dashboards with dynamic filters and drill-downs.
• DAX Mastery: Advanced DAX skills for complex calculations (e.g., weighted averages, time intelligence, FX conversions). Experience with Calculation Groups is a plus.
• Data Modeling: Strong ability to design star schemas, optimize joins, and consolidate dimensions for scalability.
• Real-Time Sync: Knowledge of incremental refresh, Change Detection, and Push Datasets, including API integration.
• Data Integration: Experience connecting Power BI to SQL databases, Snowflake, or Azure platforms, ensuring query folding.
• Performance Tuning: Skilled in using DAX Studio, Performance Analyzer, and SQL Profiler to diagnose bottlenecks.
• SQL Proficiency: Ability to query and validate data from relational databases.

Analytical Skills:

• Capability to analyze business requirements and map them to BI solutions (e.g., financial reporting, analytics).
• Strong problem-solving to address refresh delays, data latency, and dashboard slowdowns.
• Attention to detail in validating data accuracy and consistency across sources.

Communication:

• Clear verbal and written skills to present technical solutions to business users and clients.
• Ability to document designs, calculations, and configurations for team and client use.
• Comfortable gathering requirements in workshops or one-on-one sessions.

Project Delivery:

• Proven ability to deliver BI projects under tight deadlines (e.g., 12 month contracts).
• Experience working in agile or iterative environments, adapting to feedback.

Desirable Criteria:

Domain Knowledge:

• Familiarity with financial reporting standards (e.g., IFRS, GAAP) or insurance analytics (e.g., reserving, risk).
• Understanding of actuarial or financial data structures (e.g., cash flows, loss ratios).

Advanced Tools:

• Experience with Snowflake, Azure Synapse, or Databricks for large-scale data processing.
• Knowledge of Python/R for statistical modeling or custom visuals in Power BI.
• Familiarity with Azure DevOps or Git for version control.

Certifications:

• Microsoft Certified: Data Analyst Associate (PL-300).
• Snowflake SnowPro Core or Azure Data Fundamentals.

Soft Skills:

• Proactive approach to identifying optimization opportunities (e.g., pre-aggregation).
• Strong collaboration with cross-functional teams (e.g., data engineers, BAs).
• Ability to train end-users or mentor junior developers.

Perks and Benefits:

Salary: Competitive, based on experience

Job Type: Contract/Full-Time (6-12 months, with potential extension)