Senior Power BI & GCP Data Analytics Consultant

Job Title: GCP Data Analyst - Power BI 
Locations: Charlotte, NC (Preferred); Minneapolis, MN (Secondary)
Work Authorization: USC & GC
Contract W2 only 

Job Description:

• Senior Power BI & GCP Data Analytics Consultant (Contractor)

• Client is seeking an experienced Senior Power BI & GCP Data Analytics Consultant to support enterprise analytics, reporting, process intelligence, and Human-in-the-Loop (HITL) initiatives.
• This contractor will play a critical role in designing scalable data pipelines, developing executive dashboards, implementing KPI frameworks, and operationalizing Statistical Process Control (SPC) reporting across business and technology functions.
• The ideal candidate combines deep expertise in Power BI, Google Cloud Platform (GCP), data engineering, business intelligence, and statistical analytics to deliver solutions that improve transparency, operational performance, process control, and executive decision-making.
• This role requires collaboration with business stakeholders, data engineers, product owners, process intelligence teams, and senior leadership to transform data into actionable insights.

• Design, develop, and maintain enterprise-grade Power BI dashboards, scorecards, and reporting solutions.
• Build executive, operational, and strategic reporting that enables data-driven decision making.
• Develop complex data models, semantic layers, KPIs, calculations, and DAX measures.
• Create interactive visualizations highlighting trends, risks, performance, and opportunities.
• Optimize dashboard performance, refresh schedules, and user experience.
• Collaborate with business stakeholders to gather requirements and translate them into reporting solutions.
• Establish reporting standards, governance, and documentation.

• Design, build, and optimize data ingestion pipelines into Google Cloud Platform (GCP).
• Develop ETL/ELT processes to ingest data from enterprise applications, APIs, operational systems, and third-party sources.
• Work with BigQuery and cloud-native services to support scalable analytics solutions.
• Support data transformation, data quality validation, and reconciliation processes.
• Develop automated ingestion and monitoring capabilities to support operational and analytical use cases.
• Optimize data processing and storage architectures for performance and scalability.
• Collaborate with enterprise architecture and platform teams to align with cloud standards and best practices.

• Partner with business teams to define, document, and operationalize KPI frameworks.
• Develop executive scorecards and operational performance reporting.
• Create leading and lagging indicators to measure:
• Productivity, Quality, Throughput, Cycle Time, SLA Performance, Exception Rates, Process Efficiency, Operational Risk
• Design KPI governance processes, metric definitions, thresholds, and reporting standards.
• Deliver monthly and quarterly business performance reporting packages.

• Develop and maintain Statistical Process Control reporting for Human-in-the-Loop (HITL) and operational process management programs.
• Design and implement SPC visualizations and performance monitoring capabilities including:
• X-Bar Charts, Moving Range Charts, P-Charts, C-Charts, U-Charts, Control Limit Monitoring, Process Capability Analysis, Performance Trend Analysis, Outlier Detection, Variance Analysis
• Monitor process stability and identify common cause and special cause variation.
• Establish automated alerting and threshold monitoring based on control limits and performance targets.
• Support continuous improvement initiatives through data-driven root cause analysis and trend identification.
• Partner with process owners and control teams to evaluate control effectiveness and operational health.

• Perform trend analysis, forecasting, statistical analysis, and operational assessments.
• Identify emerging risks, process bottlenecks, and optimization opportunities.
• Develop executive narratives and data-driven recommendations for leadership teams.
• Support process intelligence, observability, automation, AI, and analytics initiatives.
• Participate in Agile ceremonies including sprint planning, backlog grooming, and delivery reviews.

• 5 plus years of hands-on experience developing Power BI solutions.
• 3 plus years of experience working within Google Cloud Platform (GCP).
• Experience building executive dashboards and enterprise reporting solutions.
• Strong understanding of dimensional modeling and business intelligence best practices.
• Experience working with large-scale datasets and enterprise environments.
• Strong analytical, problem-solving, and communication skills.

• Power BI Desktop
• Power BI Service
• DAX
• Power Query (M)
• SQL
• Data Modeling
• BigQuery
• ETL/ELT Development
• Data Integration and Transformation

• Experience supporting Human-in-the-Loop (HITL), AI Operations, Process Intelligence, Automation, or Digital Transformation programs.
• Experience implementing Statistical Process Control (SPC) methodologies.
• Knowledge of Lean, Six Sigma, Operational Excellence, or Continuous Improvement frameworks.
• Experience developing KPI scorecards and operational health dashboards.
• Experience with process mining, observability, automation, or workflow analytics platforms.
• Financial services or highly regulated industry experience preferred.

• Python
• APIs
• Git-based source control
• Agile/Scrum methodologies
• Data Governance and Metadata Management

• Executive Power BI dashboards and scorecards
• Operational and KPI reporting solutions
• Automated GCP data ingestion pipelines
• Curated analytical data sets and reporting marts
• e-HITL Performance Management Dashboards
• Statistical Process Control (SPC) Monitoring Suite
• Control Chart and Threshold Monitoring Frameworks
• Data Quality and Reconciliation Reporting
• Executive Monthly Business Review (MBR) Reporting Packages
• Technical Documentation and Knowledge Transfer Materials

• Self-motivated and capable of working independently.
• Strong stakeholder management and communication skills.
• Comfortable engaging with senior leaders and executive audiences.
• Ability to bridge business, analytics, and technology teams.
• Proven track record delivering end-to-end analytics and data engineering solutions.
• Strong attention to detail with a focus on operational excellence and measurable outcomes.

• Power BI | GCP | BigQuery | SQL | ETL/ELT | Data Engineering | KPI Management | Statistical Process Control (SPC) | Control Charts | Data Analytics | Executive Reporting | Process Intelligence | HITL Analytics | Python | Business Intelligence | Dashboard Development | Automation Analytics | Data Governance

• Consult on complex initiatives with broad impact and large-scale planning for Systems Architecture
• Review and analyze complex multi-faceted, larger scale or longer-term Systems Architect challenges that require in-depth evaluation of multiple factors including intangibles or unprecedented factors
• Contribute to the resolution of complex and multi-faceted situations requiring solid understanding of the function, policies, procedures, and compliance requirements that meet deliverables
• Strategically collaborate and consult with Client personnel

• 5 plus years of Systems Architecture experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education.

• Position: Senior Power BI & GCP Data Analytics Consultant (Contract)
• Duration: 6 Months (Extension Possible)
• Location: Charlotte, NC Preferred / Minneapolis Secondary
• Engagement Type: Full-Time Contractor
• Start Date: Immediate

Pay Range: $70-$75

The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.