Business analyst

job summary: Key Responsibilities Develop and maintain advanced dashboards and reports using various data visualization tools.Create, analyze, and validate complex queries to extract actionable insights from enterprise systems.Ensure high-quality data outputs through rigorous validation and auditing processes.Collaborate with internal teams to address reporting needs and inform strategic decisions. Lead the evaluation and redesign of operational workflows to align with future-state systems.Identify improvement opportunities and assess potential benefits of optimized processes.Document all changes to processes and systems for compliance and clarity. Act as the liaison for a designated workflow, managing timelines and deliverables.Generate periodic updates and escalate risks as necessary to stakeholders.Partner with cross-functional teams to evaluate resource allocation and financial impacts. Validate data mapping and assist with system testing and deployment activities.Collaborate with stakeholders to build training materials and support system adoption.Monitor post-deployment outcomes to ensure operational stability and realized benefits. Required Skills: Demonstrated experience in SQL for data extraction and reporting.Experience with reporting tools such as SSRS, Tableau, Power BI, DataMart, or similar platforms preferred.Familiarity with enterprise reporting tools and methodologies.Proven track record in workflow redesign and system implementation.Organizational and problem-solving skills.Bachelor's degree or equivalent experience preferred. location: Sacramento, California job type: Permanent salary: $105,000 - 130,000 per year work hours: 8am to 4pm education: Bachelors responsibilities: Design, develop, and maintain enterprise-level custom reports and dashboards using SQL and reporting tools (such as SSRS, Tableau, Power BI, etc.).Write complex SQL queries to retrieve, manipulate, and analyze data from CRM/ERP and other business systems.Conduct data validation and quality checks to ensure accurate reporting.Collaborate with stakeholders to gather reporting requirements and ensure that reports meet business needs.Analyze data trends and provide insights to inform process improvements and decision-making.Provide technical expertise in data extraction, transformation, and reporting across various systems.Other duties as assigned. Project Leadership and Planning Point of contact and communication for their CRM process area workstream.Owns and completes gap analysis, process design, configuration and training updates for CRM releases.Manages workstream timeline and resource needs. Communicates potential financial impacts of process designs to CRM program lead for budget approval.Produces CRM Process Area Status Report.Identifies, resolves, and escalates process area workstream risks, actions, issues, and decisions for their process workstream.Partners with other Business Process Owners, Business Program lead, Delivery and Release Manager, CRM vendors, Change Management Lead, Learning & Development, IT Program Lead, and Business leadership to anticipate resource, financial, and future process area impacts.Review training strategy and plans, including signing off on content.Partners with Change Management Lead to develop a plan and approach to socialize business changes with necessary stakeholders.Identifies and tracks business benefits realization during and after implementation. Education & Deployment With guidance from implementation consultants: Align current state processes to the vendor's future state processes and standardize.Identify and design process improvement and business benefit opportunities using the future state processes. Documents process and functional changes.Provides input to RICE (Reports, Interfaces, Conversions, Enhancements) object catalog and gap analysis.Assists with data mapping for data conversions and act as final approver for data validation.Develops test scenarios and act as final approver for testing validations. Manages and nurtures a network of Subject Matter Experts for purpose of socializing and getting feedback on processes and functional requirements.Works with the SME Network to execute change and training strategies as developed by the Change Management Leader.Delivers Training for their process area with support from the Learning & Development department. Supports cut-over planning, go-live, and stabilization activitiesqualifications: Experience level: ExperiencedMinimum 6 years of experienceEducation: Bachelors skills: Business Analysis Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). This posting is open for thirty (30) days. Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance. Qualified applicants in the unincorporated areas of Los Angeles County with criminal histories will be considered for employment in accordance with the Los Angeles County's Fair Chance Ordinance for Employers. We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.