IT - P and G Admin - Sr Business Systems Analyst

Golden 1 Credit Union•Sacramento, CA

5d•Hybrid

About The Position

The Senior Business Systems Analyst is responsible for translating business data needs into data warehousing and reporting solutions through close collaboration with business teams to identify business requirements enabling data driven decision making throughout the enterprise. This role covers all aspects of the Software Development Lifecycle with respect to data warehousing and reporting solutions. Requirements analysis, report content identification and report functionality analysis, SDLC documentation, and other recommend designs/solutions will be necessary to meet business or other requirements. Determine and recommend reporting enhancements or improvements for existing as well as new processes through the use of enterprise business intelligence tools to enhance the analysis capability or operational efficiency of various business units within the organization. This includes working across business areas, applications, data domains and technologies. Document business requirements (BRDs) and functional design specifications (FRDs) for conversions, interfaces and reports. Drive efficient and effective joint business/IT requirements and solution discussions in addition to stakeholder review meetings. Identify functional gaps and opportunities of improvement. Coordinate and drive issue resolution with cross-functional teams during the design and development process. Work closely with users to define and document use cases, scenarios and test scripts. Prepare and execute test plans to ensure solution/design meet business requirements. Create documentation for processes, training and operational support. Ensure requirements are delivered in timely stages, allowing the design and development to make the necessary progress. Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position. Ensure solutions within the environment follow established guidelines. Research, define and evaluate data requirements and specifications for departmental projects. Perform evaluations of data and data structures from disparate systems. Proactively seek opportunities to understand and improve business processes through data business intelligence and data analytics. Mentors and trains other Business Systems Analyst as needed. Act as liaison between business clients and technical staff throughout the life cycle of projects or process improvements. Coordinate effectively with IT and other departmental projects analysts and managers. Stay current with technology trends, solutions and vendors. Perform other job-related duties as necessary.

Requirements

Bachelor’s degree in Computer Science or related field or equivalent work experience.
Combined minimum 7-10 years’ progressive experience in business requirements analysis and data analysis.
High intermediate to expert SQL skills.
Proficient at analyzing data with SQL, TSQL, PSQL, or Excel.
Ability to access and analyze data in complex data models with little supervision or input.
Excellent analytical and technical skills in varied IT technologies.
Proficient in software/hardware enterprise technologies, systems integrations, and software/hardware release to production methodologies.
Excellent complex problem-solving skills.
Ability to quickly comprehend the functions and capabilities of new and existing technologies.
Project and program management capabilities.
Proven experience in executing system and integration testing.
Proficient in requirements definition, evaluation, and documentation.
Excellent planning and organization skills.
Strong communication and interpersonal skills, with the ability to influence technical and non-technical parties.
Ability to work with technical and business-oriented teams.

Nice To Haves

Previous experience with data modeling, data analysis, data quality analysis, and report development.
Exposure to a diverse enterprise application landscape with a solid understanding of how data flows through a business.
Scripting experience with Bash, Powershell, Python, or Perl.
Advanced technical and/or project management certifications.
Certified Business Analysis Professional (CBAP).

Responsibilities

Translate business data needs into data warehousing and reporting solutions.
Identify business requirements for data-driven decision making.
Perform requirements analysis, report content identification, and report functionality analysis.
Create SDLC documentation and recommend designs/solutions.
Determine and recommend reporting enhancements or improvements for existing and new processes.
Utilize enterprise business intelligence tools to enhance analysis capability or operational efficiency.
Work across business areas, applications, data domains, and technologies.
Document business requirements (BRDs) and functional design specifications (FRDs) for conversions, interfaces, and reports.
Drive joint business/IT requirements and solution discussions.
Conduct stakeholder review meetings.
Identify functional gaps and opportunities for improvement.
Coordinate and drive issue resolution with cross-functional teams during design and development.
Define and document use cases, scenarios, and test scripts with users.
Prepare and execute test plans.
Create documentation for processes, training, and operational support.
Ensure timely delivery of requirements to support design and development progress.
Maintain understanding of state and federal laws and regulations related to credit union compliance.
Ensure solutions follow established guidelines.
Research, define, and evaluate data requirements and specifications for departmental projects.
Perform evaluations of data and data structures from disparate systems.
Proactively seek opportunities to improve business processes through data business intelligence and analytics.
Mentor and train other Business Systems Analysts.
Act as a liaison between business clients and technical staff.
Coordinate with IT and other departmental projects analysts and managers.
Stay current with technology trends, solutions, and vendors.