Senior Power BI & GCP Data Analytics Consultant (contract)

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: • 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: • 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. • 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 preferred. \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_