Technical Business Analyst

Dear Professionals,

We are reaching out regarding an exciting opportunity with our direct client. If you are currently available and interested, please share your updated profile at your earliest convenience. Feel free to reach out with any questions or for more details about the position.

Looking forward to hearing from you soon! basha@faizhancg.com

Role: Technical Business Analyst

Location: Madison, WI (Hybrid)

Duration: Long Term Contract

Feedback from manager:

·      Previous submissions were Business BAs not Technical BAs. ETF is looking for a blend of Data, Business and Technical expertise, with an emphasis on technical skills.

·      Technical skills include SQL and S2T (source to target mapping).

·      Candidates should have experience with complex projects. They should "know how to deal with inter-project dependencies within a program and how to map out how a critical path in one project can derail critical path in another."

Position Summary:

Under general supervision from the deputy director of the Office of Enterprise Initiatives (OEI), on enterprise projects, initiatives, and processes, this advanced level position works as a liaison amongst technical and business stakeholders to facilitate the development of business requirements, lead business process redefinition studies and analyze the use of new technology for new or enhanced systems services. This position is responsible for working with business leads and subject matter experts (SMEs) from various ETF program areas to understand business structure, policies, and operations in order to develop solutions to business-related issues and achieve ETF and business unit strategic goals and initiatives. Including, but not limited to, defining/refining metrics and creating dashboards and standard operating procedures for projects, leading the creation, and assisting with the execution and completion of user acceptance testing (UAT), and assisting project managers and/or business units with defining project benefits and costs. Responsible for understanding current and future processes, including processes for the entire enterprise. The work product will impact the enterprise, as well as extra and/or inter-agency business on critical business activities.

This position, along with business leads and SMEs, will analyze current business processes and identify changes in business processes and/or IT systems that will improve ETF’s ability to meet customer needs and/or improve operating efficiency in a member-centric organization. This may include developing use cases and/or test plans to illustrate current state to future state definition and developing and validating detailed system requirements and design specifications. This position interacts with business users to assure a mutual understanding and agreement on requirements and specifications and, at an expert level, provides consultation, direction, and guidance to business managers.

This is a senior-level position performing difficult and complex work reviewing policies, priorities, recommendations, and/or solutions to IT and business-related issues. This person will serve as the principal authority in the analysis of business process definition/redefinition projects, with little supervision, and providing expertise in multiple projects of moderate to difficult scope and complexity. This position requires knowledge of project management principles, methods, and practices.

Ensuring effective and efficient interactions with staff and management at all organizational levels and areas of ETF is an essential part of this position.

Goals and Worker Activities

30% GOAL A.      Leadership, facilitation, and coordination of business and operational teams to ensure that ETF’s business needs are being met.

Worker

Activity    A1.   Lead, facilitate, and coordinate team meetings to prioritize work requests in partnership with the business leads from assigned business areas.

A2.   Serve as the key integration point between the business areas, operations teams, and IT.

A3.   Develop and maintain a deep understanding and expertise of applicable operational processes, procedures, and controls.

A4.   Work with key stakeholders to fully understand and analyze the business case for each work effort.

25% GOAL B.      Leadership, facilitation and coordination of business process and systems analysis

Worker

Activity    B1.   Lead, facilitate and coordinate business requirements at the appropriate level of detail for each work effort, ensuring the cross-functional impacts and any required coordination/integration effort has been identified ahead of the solution.

B2.   Work with internal and external stakeholders to gather and validate business requirements and assist with the functional design of solutions.

B3.   Partner with the technical lead to provide input into the functional aspects of solutions design.

B4.   Proactively identify opportunities for process, system, or other enhancements that may help the business mitigate operational risk and/or achieve its business goals.

B5.   Partner with the technical lead to create or update documentation relating to workflow process and detailed procedures resulting from implemented initiatives prior to deployment.

B6.   Develop end-user training materials, in partnership with the transition manager, and assist with the coordination of user training, if needed.

B7.   Serve as an internal expert with regards to the integrated end-to-end processes, controls, and solutions employed by ETF to manage the business.

B8.   Map out the data flows and processes within ETF for how we will collect data, process and ultimately how it is used by end systems. Identify gaps or improvements in the process.

B9.  Analyze the existing and future data to understand patterns, trends, gaps, etc. This includes a strong understanding of data profiling concepts using SQL.

B10. Based on requirements and analysis, collaborate with architects and developers to design solutions to meet the requirements. Use tools such as S2T, SQL queries, data flow diagrams, JIRA tickets to track and document design changes

25% GOAL C.      Management of quality control efforts

Worker

Activity    C1.   Develop, execute, and document user test plans and organize and oversee end-user testing and acceptance.

C2.   Provide support to test teams, as needed.

C3.   Coordinate resolution of issues uncovered during end-user testing.

C4.   Research escalated business issues and lead the creation of integrated models/workflows that resolve the root cause of these problems.

C5.   Participate in the evaluation, provide feedback, and resolve issues regarding vendor performance, escalating to the lead project manager as needed.

C6.   Independently resolve issues to remove roadblocks and provide reports or updates on issues to the portfolio owner, as needed.

C7.   Maintain and distribute metrics related to work request/project, as agreed upon.

C8.  Verify the data migrated to an intended destination and meets the requirements.

C9.  Build SQL test scripts to validate the transformation logic defined in Source to Target Mapping document.

15% GOAL D.      Participation in the Business Process and Analysis (BPA) Center of Excellence

Worker

Activity    D1.   Provide direction and training to other staff in the use of business analysis and process tools, techniques, metrics, standards, and best practices.

D2.   Promote, recommend revisions to, and lead the development of business analysis policies, processes/procedures, standards/guidelines, and tools/templates for OEI and the enterprise, ensuring consistency and repeatability.

D3.   Monitor business analysis processes, tools, standards, guidelines, and templates for adherence to industry and ETF-specific standards.

D4.   Create common ground between business units and IT services to ensure IT staff have the requirements and information to deliver technical solutions that support business needs.

D5.   Strive for continuous process improvement through identifying root causes of problems and developing solutions, providing mapping services, and inspiring the organization with new ways of thinking and new ways of doing business.

5% GOAL E.         Performance of special assignments and professional development

Worker

Activity    E1.   Stay abreast of business analysis trends and best practices.

E2.   Represent the Department on enterprise-wide and/or Department committees, as assigned.

Top Skills & Years of Experience:

·      At least 5 years of experience - Lead, facilitate, and coordinate business requirements gathering. Validate the requirements and assist with the functional design of solutions.

·      At least 5 years of experience - Develop, execute, and document test plans and organize and oversee end-user testing and acceptance. Track defects and coordinate resolutions.

·      At least 5 years of experience - Research, perform analysis, and provide recommendations for solutions that meet business needs and fit within the system/software capabilities.

·      At least 5 years of current experience – Writing SQL queries and creating sources to target mapping documents.

Nice to Have:

·      5+ years of experience doing business analysis on large and complex IT projects.

·      Experience in Government, Insurance Industry or Pension Plans.