REMOTE Data Warehouse Reporting/SQL Business Analy...

Sundial Software Corporation; Madison (WI); Remote; USD 85,000 - 110,000; Full time

Job summary

The Department of Employee Trust Funds (ETF) seeks a Business/Systems Analyst to join our Data Management Program. You will contribute to data integration and reporting initiatives, focusing on source-to-target mapping and robust SQL development in a collaborative, agile setting.

You will gather requirements, write user stories, translate business needs into technical specs, and perform root cause analysis on complex datasets to identify patterns and insights.

Qualifications

• SQL proficiency is required and must be used for data tasks.
• Serve as a liaison between business and technical staff to design data integrations.
• Create and maintain S2T documentation (5+ years).
• Develop complex SQL queries (5+ years).
• Gather requirements and write user stories (5+ years).
• Translate business requirements into technical specs (5+ years).
• Perform root cause analysis and data analysis on complex datasets (5+ years).
• Plan and execute testing and UAT with stakeholders (2+ years).

Responsibilities

• Participate in the Data Management Program with agile practices.
• Design and implement efficient data integration processes.
• Create comprehensive system documentation and dashboards.
• Collaborate with stakeholders to resolve issues and defects.

Skills

SQL

Liaison between business and technical

Requirements gathering

User stories development

Translating requirements into specs

Root cause analysis

Data analysis

Testing procedures

Stakeholder collaboration

Communication

Tools

Jira

SharePoint

Teams

Alteryx

SSIS

SSRS

SSMS

Squirrel

SQL Server

Tableau

Semarchy

Git & github

Job description

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.

The State of Wisconsin ETF is looking for a Business Analyst/Consultant IV

Top Required Skills & Years of Experience:

• 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

Nice to Have (Preferred) Skills:

• 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

Interview Process: remote via MS Teams

Onsite or Remote? No WI residency required. Open to nationwide candidates. This position can work 100% remote.

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