Data Analytics and Reporting Lead Subject Matter Expert (SME)

Gainwell Technologies LLC•Roseville, CA

5d•$78,100 - $111,600•Hybrid

About The Position

The Data Analytics and Reporting Lead SME is a hands-on analytics leader responsible for establishing and operating reliable reporting, data governance, and performance-management capabilities for the contract. The role translates contractual, operational, and client requirements into governed metrics, automated reporting, executive insights, and sustainable processes. It leads cross-functional analytics work, mentors team members, manages priorities and risks, and serves as a trusted advisor to contract and operational leadership. The role owns analytics and reporting across the contract lifecycle, including solution design, build and implementation, transition to operations, stabilization, and continuous improvement. It develops governed reporting practices and technical solutions, supports operational and client decision-making, leads projects and workstreams, and partners with stakeholders across contract, operations, technology, compliance, quality, finance, and client teams. This is a hybrid position supporting the Roseville, California office. The employee is expected to work 8:00 a.m. to 5:00 p.m. Pacific Standard Time unless otherwise approved by leadership. Client meetings, production support, implementation activities, or time-sensitive contract deliverables may occasionally require participation outside the normal schedule, with advance notice when practical. Effective teleworking requires broadband internet service with minimum speeds of 24 Mbps download and 8 Mbps upload.

Requirements

At least 3 years of experience in data analytics, business intelligence, reporting, or a closely related discipline, including responsibility for complex or cross-functional deliverables.
Demonstrated experience leading projects, mentoring analysts, or serving as a functional or technical lead.
Experience translating business, client, or contractual requirements into governed metrics, reports, dashboards, and operational processes.
Proficiency with SQL and experience with Python or another data scripting language.
Experience developing in a business intelligence platform such as Microsoft Power BI, Cognos, or Tableau.
Experience querying, integrating, validating, and analyzing large or diverse data sets.
Ability to explain complex data concepts, risks, and recommendations to technical and non-technical audiences.
Strong organization, prioritization, stakeholder-management, and written documentation skills.
Ability to work independently in a fast-paced remote environment while maintaining accountability, communication, and delivery discipline.

Nice To Haves

At least 2 years of advanced SQL development, query optimization, and data-validation experience.
Experience with Microsoft Power Platform, including Power BI and Power Automate.
Experience developing within Microsoft Azure, Amazon Web Services (AWS), or another cloud environment.
Experience with data governance, data quality management, metadata, lineage, access controls, and production change management.
Experience supporting a DBO, implementation, transition, managed-services, or client-based contract with formal SLAs, KPIs, deliverables, and regulatory requirements.
Experience in a highly regulated environment such as healthcare, government, or the public sector.
Experience with Agile, Lean, Six Sigma, or comparable process-management and continuous-improvement methods.
Experience presenting to senior or executive leadership and influencing decisions through data.
Experience supporting reporting automation, centralized analytics, or migration from manual or decentralized reporting processes.

Responsibilities

Own the analytics and reporting workstream across solution design, build and implementation, transition to operations, stabilization, and continuous improvement.
Translate contract requirements, SLAs, KPIs, regulatory obligations, and client commitments into metric definitions, data rules, reports, dashboards, and evidence packages.
Establish reporting governance, including metric definitions, data ownership, source-to-report lineage, refresh schedules, validation controls, approval paths, exception handling, and change control.
Maintain a reporting inventory and delivery calendar identifying purpose, audience, source systems, frequency, owner, dependencies, and contractual due dates.
Partner with contract leadership to identify reporting risks, dependencies, data gaps, and escalation needs; recommend and track mitigation plans.
Collaborate with operations, technology, compliance, quality, finance, and client stakeholders to gather requirements and define decision-ready insights.
Architect and improve data pipelines, semantic models, SQL queries, automated workflows, reports, and Power BI or comparable business intelligence dashboards.
Build data-quality controls and reconciliation processes to confirm detail-level records align with KPI totals and contractual submissions.
Analyze trends, root causes, exceptions, capacity, workload, productivity, timeliness, and SLA performance, distinguishing observed facts from assumptions and recommendations.
Improve report reliability, refresh time, usability, and maintainability by reducing manual steps, duplicate logic, and unsupported one-off processes.
Publish and maintain documentation such as requirements, business rules, data dictionaries, standard operating procedures, test scripts, release notes, and user guidance.
Lead projects and workstreams from intake through implementation, managing scope, milestones, assignments, dependencies, testing, stakeholder communication, and post-implementation support.
Set expectations for quality, timeliness, documentation, and accountability; monitor commitments and address delivery risks early.
Provide functional leadership, coaching, peer review, and technical guidance to analysts and reporting partners, with or without direct-report responsibility.
Prioritize work based on contractual impact, operational value, risk, effort, and capacity; communicate trade-offs and escalate conflicts with recommended options.
Build an inclusive, accountable team environment that encourages challenge of risks and assumptions, learning from defects, and continuous improvement.
Strengthen team capability through reusable standards, knowledge transfer, cross-training, backup coverage, and constructive feedback.
Lead effective meetings by clarifying purpose, driving decisions, documenting actions and owners, and ensuring follow-through.
Serve as the primary analytics advisor for assigned DBO reporting areas and build trusted relationships with client, contract, operational, and technical leaders.
Translate complex findings into concise narratives, clear visuals, and actionable recommendations for technical and non-technical audiences.
Facilitate requirements and metric-definition sessions, resolve conflicting interpretations, and document decisions, business rules, and approvals.
Provide transparent status reporting on progress, risks, dependencies, decisions needed, ownership, and expected completion dates.
Support audits, operational reviews, client meetings, and performance-improvement initiatives with traceable data, documented controls, and defensible reporting logic.