Overview
Skills
Job Details
- Must be a current WI resident. No relocation allowed
- This position can work 100% remote within the state of WI.
- The manager is looking for a Business Systems Analyst with reporting and data warehouse requirements development experience and source to target mapping.
- This individual MUST also be able to write SQL and must have excellent oral and written communication skills.
- We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Business/Systems Analyst to participate in our Data Management Program.
- Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization.
- This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners.
- This position must have strong analytical and problem-solving skills with the ability to think critically and identify innovative solutions.
- Candidates MUST know SQL for this position
- Serve as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation 5 years
- Develop complex SQL - 5 years
- Gather requirements and develop user stories 5 years
- Translate business requirements into technical specifications 5 years
- Perform root cause analysis for systems and perform data analysis with complex datasets to identify patterns, trends, and insights 5 years
- Plan and execute rigorous testing procedures to ensure system functionality, performance, and reliability. Perform data reconciliation and analysis of results. Conduct user acceptance testing and collaborate with stakeholders to resolve any issues or defects. 2 years
- Performing gap analysis and cost benefit analysis
- Mentoring and training users in business and systems analysis methodology
- Experience with data quality tools and frameworks
- Experience with business intelligence platforms
- Experience with data governance including security and privacy policies
- Eliciting and refining requirements for dashboards
- Strong understanding of different types of data models
- Creating comprehensive documentation, including system requirements, design specifications, and user manuals. Conduct training sessions and workshops to educate end-users on system functionalities and best practices.
- Managing multiple, concurrent projects and tasks
- Having strong interpersonal skills including communication, mentoring, collaborating, and team building
- Jira
- SharePoint
- Teams
- Alteryx
- SSIS
- SSRS
- SSMS
- Squirrel
- SQL Server
- Tableau
- Semarchy
- Git & GitHub
Qualification | Requested | Your Rating | |||||||||||
Must Have Skills | |||||||||||||
Serving as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation |
5 (Expert) of 5 (Expert) and 5+ Years of experience. |
And __ Years of experience. | |||||||||||
Developing complex SQL |
5 (Expert) of 5 (Expert) and 5+ Years of experience. |
And __ Years of experience. | |||||||||||
Gathering requirements and developing user stories |
5 (Expert) of 5 (Expert) and 5+ Years of experience. |
And __ Years of experience. | |||||||||||
Translating business requirements into technical specifications |
5 (Expert) of 5 (Expert) and 5+ Years of experience. |
And __ Years of experience. | |||||||||||
Performing root cause analysis for systems and performing data analysis with complex datasets to identify patterns, trends, and insights |
5 (Expert) of 5 (Expert) and 5+ Years of experience. |
And __ Years of experience. | |||||||||||
Planning and executing rigorous testing procedures to ensure system functionality, performance, and reliability. Performing data reconciliation and analysis of results. Conducting user acceptance testing and collaborating with stakeholders to resolve any issues or defects. |
and 2+ Years of experience.
|
And __ Years of experience. | |||||||||||
Nice to Have Skills | |||||||||||||
Performing gap analysis and cost benefit analysis |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Mentoring and training users on business and systems analysis methodology |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Experience with data quality tools and frameworks |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Experience with business intelligence platforms |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Experience with data governance including security and privacy policies |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Eliciting and refining requirements for dashboards |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Strong understanding of different types of data models |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Creating comprehensive documentation, including system requirements, design specifications, and user manuals. Conduct training sessions and workshops to educate end-users on system functionalities and best practices. |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience.
|
And __ Years of experience. | |||||||||||
Managing multiple, concurrent projects and tasks |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Strong interpersonal skills including communication, mentoring, collaborating, and team building |
3 (Moderately Strong) of 5 (Expert) and 3+ Years of experience. |
And __ Years of experience. | |||||||||||
Key Engagements over the last two years REQUIRED. Please have candidate complete.
|
| ||||||||||||
Describe how past work experience relates to this position REQUIRED. Please have candidate complete. |
| ||||||||||||
Candidate / Vendor Comments:
Use the space to the right to briefly state (one or two paragraphs) why the candidate is a great fit for this position.
This is a text-only field. Please do not copy/paste from the resume as that is available.
|
| ||||||||||||
Thanks & Regards,
Varshitha,
IT Recruiter
Email: | ;/div>