Senior Business Analyst - Data Analytics & Reporting Lead - SME - Roseville, CA

Gainwell Technologies LLC•Any city, OH

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

About The Position

The Senior Business Analyst 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 position owns the analytics and reporting workstream across its lifecycle, from solution design and implementation through transition to operations, stabilization, and continuous improvement. It establishes reporting governance, maintains reporting inventories and delivery calendars, identifies risks and dependencies, and builds and improves data pipelines, semantic models, SQL queries, automated workflows, reports, and business intelligence dashboards. It also develops data-quality and reconciliation controls, analyzes performance and trends, and maintains documentation and reporting processes. The role leads projects and workstreams, provides day-to-day functional leadership and coaching, prioritizes work, and supports collaboration and accountability. It partners with client, contract, operational, and technical leaders; presents findings and recommendations; facilitates requirements and metric-definition sessions; and supports audits, operational reviews, client meetings, and performance-improvement initiatives. This is a hybrid position supporting the Roseville, California office, with an expected schedule of three to four days per week in the office. The employee must be available to work 8:00 a.m. to 5:00 p.m. Pacific Standard Time unless otherwise approved. 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. Telework requires broadband internet with at least 24 Mbps download and 8 Mbps upload.

Requirements

At least 5 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 business purpose, audience, source systems, frequency, owner, dependencies, and contractual due dates.
Identify reporting risks, dependencies, data gaps, and decisions requiring escalation; recommend mitigation plans and track them through closure.
Gather requirements and define decision-ready insights with operations, technology, compliance, quality, finance, and client stakeholders.
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; 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 requirements, business rules, data dictionaries, standard operating procedures, test scripts, release notes, and user guidance.
Lead projects and workstreams from intake through implementation, including scope, milestones, assignments, dependencies, testing, stakeholder communication, and post-implementation support.
Set expectations for quality, timeliness, documentation, and accountability; follow up on commitments and address delivery risks early.
Provide functional leadership, coaching, peer review, and technical guidance to analysts and reporting partners.
Prioritize work based on contractual impact, operational value, risk, effort, and capacity; communicate trade-offs and escalate conflicts with recommended options.
Foster an inclusive, collaborative environment where team members can raise risks, challenge assumptions, learn from defects, and improve processes while maintaining accountability.
Develop team capability through reusable standards, knowledge transfer, cross-training, succession coverage, and constructive feedback.
Lead meetings by defining 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.
Present complex findings to technical and non-technical audiences using concise narratives, clear visuals, and actionable recommendations.
Facilitate requirements and metric-definition sessions, resolve conflicting interpretations, and document decisions and approvals.
Provide transparent status reporting on progress, risks, decisions needed, ownership, and expected completion dates.
Support audits, operational reviews, client meetings, and performance-improvement initiatives with traceable data and defensible reporting logic.