Data Management - Systems Architect II

Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).

Job Description:

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 dataliterate and datadriven 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 problemsolving skills with the ability to think critically and identify innovative solutions.

Desired Experience:

• 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 years
• Developing complex SQL 5 years
• Gathering requirements and developing user stories 5 years
• Translating business requirements into technical specifications 5 years
• Performing root cause analysis for systems and performing data analysis with complex datasets to identify patterns trends and insights 5 years
• 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 collaborate with stakeholders to resolve any issues or defects. 2 years
• Performing gap analysis and cost benefit analysis
• Mentoring and training users on 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 endusers on system functionalities and best practices.
• Managing multiple concurrent projects and tasks
• Having strong interpersonal skills including communication mentoring collaborating and team building

ETF Technologies:

• Jira
• SharePoint
• Teams
• Alteryx
• SSIS
• SSRS
• SSMS
• Squirrel
• SQL Server
• Tableau
• Semarchy
• Git & github