Power BI Consultant (Analytics & Reporting)

Job Summary
We are seeking a dynamic Power BI Consultant specializing in Analytics and Reporting to join our innovative data team. In this role, you will leverage your expertise in Power BI and a broad suite of analytics tools to transform complex data into clear, actionable insights. Your efforts will empower stakeholders across the organization to make informed decisions, optimize processes, and drive strategic growth.

This role focuses on delivering scalable, governed, and high‑performance Power BI solutions using modern Microsoft analytics capabilities, including Power BI Service, DAX, semantic models, and Microsoft Fabric‑aligned architectures. The ideal candidate combines strong technical depth with a solid understanding of business KPIs, manufacturing or operations‑centric data, and stakeholder communication.

Key Responsibilities

• Power BI Solution Design & Development
• Design and build Power BI reports, dashboards, and semantic models for enterprise audiences
• Develop optimized DAX measures for complex KPIs, trends, and performance analysis
• Implement star‑schema and dimensional models to support scalable analytics
• Apply best practices for visual design, usability, and performance
• Modern Microsoft Analytics Stack
• Leverage Power BI Service capabilities including:
• Apps, workspaces, deployment pipelines
• Row‑level security (RLS) and object‑level security
• Scheduled refresh and data gateways
• Work with Microsoft Fabric‑aligned architectures, including:
• Lakehouse/warehouse concepts
• Direct Lake or DirectQuery strategies (where applicable)
• Partner with data engineers on data pipelines, refresh strategies, and model optimization
• Data Integration & Performance
• Consume data from multiple enterprise sources, such as:
• ERP and operational systems
• Manufacturing, supply chain, and finance platforms
• Cloud data warehouses and lakes
• Optimize report and model performance by:
• Reducing model size and cardinality
• Optimizing DAX and relationships
• Implementing aggregation and incremental refresh strategies
• Stakeholder Enablement & Governance
• Partner with business stakeholders to understand reporting and analytics needs
• Translate requirements into clear, trusted dashboards and insights
• Establish governance standards for datasets, metrics, and reporting consistency
• Support user adoption through documentation, walkthroughs, and enablement sessions

Qualifications

• Proven experience in developing dashboards and reports using Power BI; familiarity with Tableau is a plus.
• Strong knowledge of SQL Server, Oracle databases, and experience with database design principles.
• Skilled in data analysis techniques using SQL, R, Python, and ETL processes with tools like Talend or similar platforms.
• Experience working within Agile methodologies and managing projects through SDLC frameworks.
• Familiarity with Business Analysis practices to gather requirements effectively from diverse stakeholders.
• Knowledge of visualization tools such as Looker; experience with VBA or Bash scripting is advantageous.
• Understanding of linked data concepts and their application in analytics projects.
• Excellent analysis skills combined with the ability to communicate insights clearly to technical and non-technical audiences.
• Ability to manage multiple priorities efficiently while maintaining attention to detail in a fast-paced environment. Join us as a Power BI Consultant (Analytics & Reporting) where your expertise will directly influence strategic decisions across the organization! We are committed to fostering an inclusive environment that values innovation, continuous learning, and professional growth—empowering you every step of the way toward making impactful contributions through data-driven solutions.

Pay: $80.00 - $90.00 per hour

Work Location: Remote