Senior Power BI & GCP Data Analytics Consultant

Description

Title:Senior Power BI & GCP Data Analytics Consultant

Location: Charlotte, NC

Duration: 6 months

Work Engagement: W2

Work Schedule: Hybrid 3 days in office/2 days remote

Benefits on offer for this contract position: Health Insurance, Life insurance, 401K and Voluntary Benefits

Summary:

In this contingent resource assignment, you may: 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 Required Qualifications: Systems Architecture experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education

Key Responsibilities:

Power BI Reporting & Dashboard Development

• 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.

GCP Data Ingestion & Data Engineering

• 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.

KPI Development & Performance Analytics

• 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:

o 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.

Statistical Process Control (SPC) & e-HITL Analytics

• 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:

o 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.

Advanced Analytics & Insights

• 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.

Key Requirements:

• Applicants must be authorized to work for ANY employer in the U.S. This position is not eligible for visa sponsorship.
• 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.
• Proficiency with:

o Python

o APIs

o Git-based source control

o Agile/Scrum methodologies

o Data Governance and Metadata Management

• Experience with process mining, observability, automation, or workflow analytics platforms.
• Financial services or highly regulated industry experience preferred.

Power BI Desktop

o Power BI Service

o DAX

o Power Query (M)

o SQL

o Data Modeling

o BigQuery

o ETL/ELT Development

o Data Integration and Transformation