W2 - Business Analyst/Consultant IV (SQL, Reporting, Data warehouse, S2T, User stories, root cause analysis) - Remote/Local

  • Madison, WI
  • Posted 1 day ago | Updated 19 hours ago

Overview

Remote
On Site
Compensation information provided in the description
Contract - W2
Contract - 3 day((s))

Skills

data warehouse
Reporting
user stories
Root Cause Analysis
Business Analyst/Consultant IV (SQL
S2T

Job Details

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 client is looking for a Business Analyst/Consultant IV
Will close to submissions on 6/6/2025 at 4:00PM CST.

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
Duration: 6/30/2026, likely to extend
Onsite or Remote? Candidates must be CURRENT WI residents. No relocation is allowed. This position can work 100% remote within the state of WI.

We have an immediate opening 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
ssrv1S
Squirrel
SQL Server
Tableau
Semarchy
Git & github
Pay rate: $40/hr on W2.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.