Business Analyst/Consultant IV
About The Position
The Department of Employee Trust Funds (ETF) has an immediate opening for a Business/Systems Analyst to participate in its Data Management Program. The role works on a small, collaborative team using agile practices to deliver value to business partners. It calls for strong analytical and problem-solving skills, critical thinking, and the ability to identify innovative solutions. The analyst serves as a liaison between business and technical staff, develops reporting and data warehouse requirements, and supports data integration through source-to-target documentation. The position requires SQL skills, including complex SQL, and strong oral and written communication. The work is 100% remote and open to candidates nationwide; Wisconsin residency is not required. The assignment is scheduled through 6/30/2027 and is likely to extend.
Requirements
- At least 5 years of experience as a Business Analyst.
- At least 5 years of experience developing complex SQL; SQL knowledge is mandatory.
- At least 5 years serving as a liaison between business and technical staff to design and implement data integration processes and creating and maintaining S2T documentation.
- At least 5 years gathering requirements and developing user stories.
- At least 5 years translating business requirements into technical specifications.
- At least 5 years performing systems root cause analysis and data analysis with complex datasets.
- At least 2 years planning and executing testing, performing data reconciliation and analysis, conducting user acceptance testing, and collaborating to resolve issues or defects.
- Strong oral and written communication skills.
- Strong analytical and problem-solving skills, with the ability to think critically and identify innovative solutions.
Nice To Haves
- Experience with data quality tools and frameworks.
- Experience with business intelligence platforms.
- Experience with data governance, including security and privacy policies.
- A strong understanding of different types of data models.
- Experience mentoring and training users on business and systems analysis methodology.
- Experience eliciting and refining dashboard requirements.
- Experience creating comprehensive documentation and conducting end-user training sessions and workshops.
- Experience managing multiple concurrent projects and tasks.
- Strong interpersonal, communication, mentoring, collaboration, and team-building skills.
- Experience performing gap analysis and cost-benefit analysis.
Responsibilities
- Serve as a liaison between business and technical staff to design and implement efficient data integration processes.
- Create and maintain source-to-target (S2T) documentation.
- Gather requirements and develop user stories.
- Translate business requirements into technical specifications.
- Perform root cause analysis for systems and analyze complex datasets to identify patterns, trends, and insights.
- Plan and execute testing to assess system functionality, performance, and reliability; perform data reconciliation and analyze results.
- Conduct user acceptance testing and collaborate with stakeholders to resolve issues or defects.
- Perform gap analysis and cost-benefit analysis.
- Mentor and train users on business and systems analysis methodology.
- Elicit and refine requirements for dashboards.
- Create documentation such as system requirements, design specifications, and user manuals; conduct training sessions and workshops for end users.
- Manage multiple concurrent projects and tasks.
- Collaborate with stakeholders and team members, including through communication, mentoring, and team building.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
