BU Data Analyst II

SchoolsFirst Federal Credit Union•Tustin, CA

1d•Onsite

About The Position

Under limited supervision, responsible for complex systems administration within the business unit, including design, development, testing, implementation, troubleshooting, administration and enhancement of assigned systems, including workflow design and third party integrations. Acts as a subject matter expert and key liaison among stakeholders based on advanced understanding of the structure, policies, and operation, in order to develop recommendations and solutions to solve problems and issues related to business operations. Maintains advanced knowledge and skillset of business systems in order to effectively bridge the gap between business unit inefficiencies and technology solutions. Designated as a subject matter expert and functions as a liaison and point of contact to Information Technology from the line of business, representing the end users and business process owners in business system requirements, implementations and support for software products. Maintains a solid understanding of data management, business systems, procedures and processes for the corresponding business unit. Consults with management and users to determine the needs and functional requirements of the system, which may include software requirements, technical requirements, system requirements or new technologies & features that may contribute to business process efficiencies. Defines user system requirements, provides user support and coordinates user acceptance testing of new tools. Represents user needs in the development of functional specifications and works closely with IT to design or enhance a system to meet the business goals. Prepares and delivers business users’ system needs and writes technical documents to give other analysts and Information Technology insight into system architecture, business rules, and Integration Services. Participates in the overall project planning, which includes, identifying system and process gaps and initiating changes to processes and or systems, including performing feasibility analysis, developing project scope, and providing recommendations on alternative solutions, project strategy and deliverable prioritization. Participates in roll out of system and process changes. Participates in implementation, coordinating tests, and observing initiation of the system to validate performance. Works closely with teammembers, developers, testers and a variety of end users to ensure technical compatibility and user satisfaction; ensuring that budgets are adhered to and deadlines met. Analyzes and communicates stakeholder needs by translating business requirements into software or reporting requirements. Designs and creates workflows for business processes to increase efficiency and effectiveness, while allowing for better management oversight of processes and enhanced reporting. Specifies inputs and formatting outputs to meet users’ needs, using techniques such as sampling, model building and structured analysis to ensure the solution is efficient, cost-effective and financially feasible. May develop specifications, diagrams and flowcharts for programmers to follow. Administers software version control for assigned systems and oversees testing and installation of all upgrades, patches, and maintenance updates. Escalate software related issues to 3rd party vendors. Actively participates in design and testing system upgrades or conversions, security reviews and system conversions. Effectively manages form libraries, troubleshoots macros, system mappings, and integration documents. Applies system maintenance to data files, product descriptions, rates channels, fees channels, and related decision engines to ensure accurate system performance. Administers security requirements for assigned systems and participates in security reviews/audits. Configures user roles and set-up of new users; periodically audits active users for security purposes. Troubleshoots hardware and/or software issues. Logs system failures, reports bugs to developers, and proactively works with 2nd level support teams (internal and external) for quick resolutions. Availability to support systems and apply upgrades, new or changed products, restoration of system performance after a mishap. Provides training and user manuals to users of a new or existing system. Prepares end-user release notes and procedural documentation to support upgrades. Keeps up to date with technical and industry developments. Additional Job Functions Performs other duties as assigned Complies with regulatory compliance and assigned training requirements including but not limited to BSA regulations corresponding to their specific job duties. Failure to do so may result in disciplinary and other employment related actions.

Requirements

High School Diploma or GED required
Bachelor's Degree in a related field or equivalent years of experience required
5-7 years of prior relevant experience required
Advanced knowledge and understanding of computer software and applications within assigned business unit used to support report development including, but not limited to SQL, SQL Server tools such as SSMS, SSRS, SSIS, and SSAS, Crystal Reports, Microsoft Office, Visio, Microsoft Project.
Strong problem-solving and analytical skills, communication and interpersonal skills, and the ability to focus with close attention to detail
Understanding of credit union business lines including lending, shares, investment services, asset/liability etc.
Understanding of existing reporting systems such as DSS and EIS, information process flows within the credit union, month end processing and reporting cycles, security requirements and how to manage and secure reporting.
Knowledge/previous experience with financial and operational reporting.
Strong understanding of programming, database design and development, data sources and data feeds used to populate reports.
Must have the technical knowledge to help guide the decisions on technical specifications.
Experience working with tech leads and end-users.

Nice To Haves

Certified Business Analysis Professional (CBAP) preferred
May provide training to less-experienced BU Systems Analysts.

Responsibilities

Design, development, testing, implementation, troubleshooting, administration and enhancement of assigned systems, including workflow design and third party integrations.
Acts as a subject matter expert and key liaison among stakeholders based on advanced understanding of the structure, policies, and operation, in order to develop recommendations and solutions to solve problems and issues related to business operations.
Maintains advanced knowledge and skillset of business systems in order to effectively bridge the gap between business unit inefficiencies and technology solutions.
Functions as a liaison and point of contact to Information Technology from the line of business, representing the end users and business process owners in business system requirements, implementations and support for software products.
Maintains a solid understanding of data management, business systems, procedures and processes for the corresponding business unit.
Consults with management and users to determine the needs and functional requirements of the system, which may include software requirements, technical requirements, system requirements or new technologies & features that may contribute to business process efficiencies.
Defines user system requirements, provides user support and coordinates user acceptance testing of new tools.
Represents user needs in the development of functional specifications and works closely with IT to design or enhance a system to meet the business goals.
Prepares and delivers business users’ system needs and writes technical documents to give other analysts and Information Technology insight into system architecture, business rules, and Integration Services.
Participates in the overall project planning, which includes, identifying system and process gaps and initiating changes to processes and or systems, including performing feasibility analysis, developing project scope, and providing recommendations on alternative solutions, project strategy and deliverable prioritization.
Participates in roll out of system and process changes.
Participates in implementation, coordinating tests, and observing initiation of the system to validate performance.
Works closely with team members, developers, testers and a variety of end users to ensure technical compatibility and user satisfaction; ensuring that budgets are adhered to and deadlines met.
Analyzes and communicates stakeholder needs by translating business requirements into software or reporting requirements.
Designs and creates workflows for business processes to increase efficiency and effectiveness, while allowing for better management oversight of processes and enhanced reporting.
Specifies inputs and formatting outputs to meet users’ needs, using techniques such as sampling, model building and structured analysis to ensure the solution is efficient, cost-effective and financially feasible.
May develop specifications, diagrams and flowcharts for programmers to follow.
Administers software version control for assigned systems and oversees testing and installation of all upgrades, patches, and maintenance updates.
Escalate software related issues to 3rd party vendors.
Actively participates in design and testing system upgrades or conversions, security reviews and system conversions.
Effectively manages form libraries, troubleshoots macros, system mappings, and integration documents.
Applies system maintenance to data files, product descriptions, rates channels, fees channels, and related decision engines to ensure accurate system performance.
Administers security requirements for assigned systems and participates in security reviews/audits.
Configures user roles and set-up of new users; periodically audits active users for security purposes.
Troubleshoots hardware and/or software issues.
Logs system failures, reports bugs to developers, and proactively works with 2nd level support teams (internal and external) for quick resolutions.
Provides training and user manuals to users of a new or existing system.
Prepares end-user release notes and procedural documentation to support upgrades.
Keeps up to date with technical and industry developments.
Performs other duties as assigned.
Complies with regulatory compliance and assigned training requirements including but not limited to BSA regulations corresponding to their specific job duties.