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 NA% 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 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.

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 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

ETF Technologies:

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

Required Skills : Tableau,SSRS,SSIS,SQL
Additional Skills : Big Data