Senior Business Systems Analyst​/Oakland, CA Hybrid

Senior Business Systems Analyst

Location:

Oakland, CA (Onsite Tues and Wed EVERY Week)/Hybrid

Type: 12 Month Contract (Can Be Extended)

The Business Systems Analyst (BSA) is expected to bring both business and technical expertise to support the requirements gathering and functional design of enterprise level cloud-based data platform supporting UC Finance diversion. The ideal candidate will have a strong blend of business acumen and technical skills necessary to bridge the gap between UC Finance business stakeholders and technical teams. The BSA will support the Data Architect in the effort to have a data architecture that is centralized, scalable, and efficient for data storage, processing, reporting and analytics.

Business & Data Analysis

• Working closely with business stakeholders to gather, analyze, and document requirements for the data repository project from each finance department to understand data sources, business requirements, and reporting needs.
• Partner with Finance, HR, and ITS stakeholders to understand business processes, data definitions, and reporting needs.
• Translate business requirements into functional and technical specifications for data ingestion, transformation, and consumption.
• Creating and leading systems requirement documentation standards, including use case modeling, user story creation and narrative description.
• Collaborating with the data architect to ensure the planned data repository meets UC Finance business requirements.

Data Lake & System Integration

• Serve as a key contributor to the design and evolution of an AWS-based data lake architecture.
• Work closely with data engineers and architects on integrations using AWS services such as Glue, Lambda, S3, Athena, Lake Formation, and Quick Sight.
• Conduct data profiling and data quality analysis using SQL and Python.
• Develop and maintain mapping documents and source-to-target specifications.
• Support API-based, batch, and event-driven integrations across enterprise systems.

Delivery & Cross-Functional Collaboration

• Act as the primary liaison between business stakeholders, data engineering, analytics, and ITS team.
• Participate and lead backlog refinement, sprint planning, daily stand-ups, and retrospectives.
• Create test plans, execute unit testing, and conduct UAT activities for data and integration initiatives.
• Ensure solutions align with institutional priorities, data governance standards, privacy requirements, and compliance obligations.
• Communicate technical information to technical and non-technical personnel at various levels within an organization.

Governance, Security & Documentation

• Support data governance practices, including data definitions, lineage, access controls, and auditability.
• Ensure appropriate handling of sensitive financial and payroll/personnel data (PII/PHI where applicable).
• Produce clear, thorough documentation including requirements, data models, process flows, and test scenarios.

• Strong proficiency in SQL for data querying, analysis, and validation.
• Strong knowledge of Python for scripting and data manipulation tasks.
• Experience with data warehousing, data lakehouse or data lake concepts, ETL processes, and data modeling.
• Solid understanding of AWS data services such as Glue, Lambda, S3, Athena, Lake Formation, and Quick Sight.
• Familiarity with Agile/Scrum methodologies.
• Experience with tools such as Atlassian JIRA, Atlassian Confluence, and SQL case tools such as TOAD or SQL Developer.
• Knowledge of extraction, transform and load (ETL) and/or extraction, load and transform (ELT) processes from source to target.
• Demonstrated experience performing extensive data repository testing, creating required test plans, and performing unit testing as well as user acceptance testing.
• Experience with data management, data warehousing, data lake, and data lakehouse implementations.
• Demonstrated knowledge of business process and analysis functions including reverse engineering, business process and brainstorming maps in Microsoft Visio, and requirements documentation using Atlassian JIRA.
• Demonstrated experience with related IT areas such as managed file transfer (MFT) processes, data architecture, data security, web content management, data quality and validation processes, database administration, access management, and data cleanup and conversion.
• Firm understanding of data pipelines and processing programs for data integration, especially for organizations with multiple locations and source systems.
• Excellent analytical and problem-solving skills with attention to detail.
• Strong verbal and written communication skills with the ability to translate technical details into business language.
• Demonstrated ability to work with others from diverse backgrounds.

• Business Requirement Document on selected use cases
• Functional Requirements and User Stories
• Acceptance Criteria and Success Measures
• Source-to-Target Data Mapping
• Business Data Definitions and Glossary
• Functional Specifications and Data…