W2 - Business Analyst/Consultant IV (SQL, Reporting, Data warehouse, S2T, User stories, root ca[...]

Jobs via Dice; Madison (WI); Remote; USD 83,000 - 112,000; Full time

Job summary

A leading technology staffing firm is seeking a Business Analyst/Consultant IV with extensive experience in SQL and data warehousing. This remote position requires strong analytical skills to drive data integration processes and deliver value through agile methodologies. The successful candidate will work collaboratively in a team-oriented environment focused on improving the organization’s data literacy and utilization.

Qualifications

• 5 years of SQL experience required.
• Strong problem-solving and analytical skills.
• Excellent communication skills.

Responsibilities

• Liaising between technical and business staff to implement data integration.
• Creating and maintaining source to target documentation.
• Conducting user acceptance testing and collaborating with stakeholders.

Skills

SQL

Data analysis

Communication

Problem-solving

Documentation

Tools

Jira

SharePoint

Alteryx

SSIS

SSRS

SQL Server

Tableau

Git & GitHub

Job description

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

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

1 week ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Tanson Corp, is seeking the following. Apply via Dice today!

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at Jobs via Dice by 2x

Sign in to set job alerts for “Business Analyst” roles.

Strategic Analyst Parcel Insights & Operations- REMOTE

Remote Cerner Oracle EMR EHR Business Analyst. Remote Part time or Full time

Madison, WI $70,700.00-$106,100.00 1 week ago

Business Intelligence Analyst - Tableau - Remote US

Madison, WI $70,000.00-$90,000.00 7 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.