Senior Power BI & GCP Data Analytics Consultant (contract)

Location: Charlotte, NC
Duration: 6 months
Work Schedule: Hybrid – 3 days in office / 2 days remote

About the Role

In this contingent resource assignment, you will consult on complex initiatives with broad impact and large-scale planning for Systems Architecture. You will review and analyze multi-faceted, large-scale, or long-term Systems Architect challenges requiring in-depth evaluation of multiple factors, including intangibles or unprecedented elements. You will contribute to resolving complex situations with a solid understanding of function, policies, procedures, and compliance requirements to meet deliverables. Strategic collaboration and consultation with client personnel are key aspects of this role.

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 to enable 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 productivity, quality, throughput, cycle time, SLA performance, exception rates, process efficiency, and 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 X-Bar Charts, Moving Range Charts, P-Charts, C-Charts, U-Charts, control limit monitoring, process capability analysis, performance trend analysis, outlier detection, and 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.

Requirements

• Systems Architecture experience, or equivalent demonstrated through work, consulting, training, military experience, or education.
• Applicants must be authorized to work for ANY employer in the U.S. (No visa sponsorship available).
• Hands-on experience developing Power BI solutions.
• Experience working within Google Cloud Platform (GCP).
• Advanced experience with: Power BI Desktop, Power BI Service, DAX, Power Query (M), SQL, Data Modeling, BigQuery, ETL/ELT Development, Data Integration and Transformation.
• 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.

Preferred Qualifications

• 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 methodologies, Data Governance, and Metadata Management.
• Experience with process mining, observability, automation, or workflow analytics platforms.
• Financial services or highly regulated industry experience.

Benefits

• Health Insurance
• Life Insurance
• 401K
• Voluntary Benefits