Data Analytics and Reporting Lead Subject Matter Expert (SME)

Summary

As a Data Analytics and Reporting Lead Subject Matter Expert (SME) at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this 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. This role translates contractual, operational, and client requirements into governed metrics, automated reporting, executive insights, and sustainable processes. The role leads cross-functional analytics work, mentors team members, manages priorities and risks, and serves as a trusted advisor to contract and operational leadership.

Your role in our mission

Contract Delivery and Governance

• Own the analytics and reporting workstream across the lifecycle, including solution design, build and implementation, transition to operations, stabilization, and continuous improvement.
• Translate contract requirements, service-level agreements (SLAs), key performance indicators (KPIs), regulatory obligations, and client commitments into clear 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 that identifies business purpose, audience, source systems, frequency, owner, dependencies, and contractual due dates.
• Partner with contract leadership to identify reporting risks, dependencies, data gaps, and decisions requiring escalation; recommend practical mitigation plans and track them through closure.

Analytics, Reporting, and Technical Delivery

• 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 that confirm detail-level records align with KPI totals and contractual submissions.
• Analyze trends, root causes, exceptions, capacity, workload, productivity, timeliness, and SLA performance; clearly distinguish 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 clear documentation, including requirements, business rules, data dictionaries, standard operating procedures, test scripts, release notes, and user guidance.

Leadership and Team Expectations

• Lead projects and workstreams from intake through implementation, including scope, milestones, assignments, dependencies, testing, stakeholder communication, and post-implementation support.
• Set clear 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 where risks and assumptions can be challenged, defects become learning opportunities, and processes continuously improve.
• 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.

• Lead projects and workstreams from intake through implementation, including scope, milestones, assignments, dependencies, testing, stakeholder communication, and post-implementation support.
• Set clear 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 where risks and assumptions can be challenged, defects become learning opportunities, and processes continuously improve.
• 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.

Stakeholder and Executive Partnership

• Serve as the primary analytics advisor for assigned DBO reporting areas, building 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 that communicates 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.

What we're looking for

• 3 or more 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 both 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.

Preferred Qualifications

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

What you should expect in this role

• This is a Hybrid position supporting the Roseville, California office. The employee must be available to work 8:00 a.m. to 5:00 p.m. Pacific Standard Time unless otherwise approved by leadership.
• The role may require participation in client meetings, production support, implementation activities, or time-sensitive contract deliverables outside the normal schedule with advance notice when practical.
• To work effectively as a teleworker with Gainwell, the employee should maintain broadband internet service with a minimum speed of 24 Mbps download and 8 Mbps upload. Greater speeds may improve performance

• Video cameras must be used during all interviews, as well as during the initial week of orientation
• Photo will be taken during screening for verification in all steps of the recruitment process.
• The deadline to submit applications for this posting is December 30, 2026
• #LI-HC1
• #LI-Roseville, CA

Please ensure you join all screenings, interviews and meetings from a quiet location with a stable internet connection. 

Video is required for screenings and interviews, so please test your camera and microphone in advance.

Do not use AI tools, virtual backgrounds/filters, or visual enhancements during the interview.