Senior Power BI & GCP Data Analytics Consultant

Quick Facts

• Role: Senior Power BI & GCP Data Analytics Consultant (contract)

• Location: Charlotte, NC (Hybrid: 3 days in office / 2 days remote)

• Duration: 6 months

• Engagement: W2

• Benefits: Health insurance, life insurance, 401(k), voluntary benefits

Description

You will consult on complex, multi-faceted initiatives by applying systems architecture thinking to analytics challenges and deliverables. The work focuses on enterprise Power BI reporting, GCP/BigQuery data ingestion and engineering, KPI operationalization, and Statistical Process Control (SPC) with HITL analytics, delivered in an Agile environment.

Responsibilities

• Power BI Reporting & Dashboard Development: Design, develop, and maintain enterprise-grade Power BI dashboards, scorecards, and reporting solutions; build semantic layers, KPIs, calculations, and DAX measures; create interactive visualizations; optimize performance and refresh schedules; gather requirements from stakeholders; establish reporting standards, governance, and documentation.

• GCP Data Ingestion & Data Engineering: Design and optimize data ingestion pipelines into GCP; build ETL/ELT processes from enterprise applications, APIs, operational systems, and third-party sources; use BigQuery and cloud-native services; perform transformation, data quality validation, and reconciliation; implement automated ingestion and monitoring; optimize processing and storage for performance and scalability; align with cloud standards and best practices.

• KPI Development & Performance Analytics: Define and operationalize KPI frameworks; develop executive scorecards and operational performance reporting; create leading and lagging indicators (productivity, quality, throughput, cycle time, SLA performance, exception rates, process efficiency, operational risk); set KPI governance, metric definitions, thresholds, and reporting standards; deliver monthly and quarterly performance packages.

• SPC & e-HITL Analytics: Develop and maintain SPC reporting for Human-in-the-Loop (HITL) and operational process management; create SPC visualizations (X-Bar Charts, Moving Range Charts, P-Charts, C-Charts, U-Charts, control limit monitoring, process capability analysis, performance trend analysis, outlier and variance analysis); monitor stability and identify common vs. special cause variation; set up automated alerting based on control limits; support continuous improvement through root-cause analysis and trend identification; evaluate control effectiveness and operational health.

• Advanced Analytics & Insights: Conduct trend analysis, forecasting, statistical analysis, and operational assessments; identify risks, bottlenecks, and optimization opportunities; develop executive narratives and recommendations; support process intelligence, observability, automation, AI, and analytics initiatives; participate in Agile ceremonies (sprint planning, backlog grooming, delivery reviews).

Requirements

• Authorized to work for any employer in the U.S. (no 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 Python, APIs, Git-based source control, Agile/Scrum, data governance, and metadata management

• Experience with process mining, observability, automation, or workflow analytics platforms

• Power BI Desktop, Power BI Service, DAX, Power Query (M), SQL, data modeling, BigQuery, ETL/ELT development, data integration and transformation

• Financial services or highly regulated industry experience preferred