Business Analyst - Consultant

COOLSOFT; Madison (WI); Vor Ort; USD 71.000 - 107.000; Vollzeit

Zusammenfassung

COOLSOFT in the United States is seeking a Business Analyst - Consultant to join a data management program within ETF. The role focuses on bridging business needs with technical teams to design robust data integration and governance processes.

You will contribute to agile delivery, develop user stories, and ensure data quality across platforms. Ideal candidates bring strong SQL skills, experience with BI tools, and the ability to translate complex requirements into actionable instructions.

Qualifikationen

• 5+ years serving as liaison between business and technical staff to design and implement data integration processes.
• Developing source-to-target (S2T) documentation and data mapping.
• Gathering requirements and developing clear user stories for IT projects.
• Translating business needs into technical specifications for data systems.
• Root cause analysis for systems and data sets; identifying patterns and insights.
• Designing test plans including UAT and data reconciliation.

Aufgaben

• Act as liaison between business and IT to design data integration workflows.
• Create and maintain S2T documentation and data models.
• Elicit and refine requirements for dashboards and BI reports.
• Translate business requirements into technical specs and data pipelines.
• Perform rigorous testing and data validation; collaborate with stakeholders to resolve defects.
• Mentor users on business analysis methodologies and tools.
• Support multiple concurrent projects with strong communication.

Kenntnisse

Business Analyst

SQL

Tools

Jira

SharePoint

Teams

Alteryx

SSIS

SSRS

SSMS

Squirrel

SQL Server

Tableau

Semarchy

Git & github

Jobbeschreibung

Business Analyst - Consultant

(Jobs in Madison, WI)

Job title Consultant

Job location in Madison, WI

Skills required Business Analyst, SQL, -,

Open Date 23-Oct-2026

Close Date

Job type Contract

Duration 7 Months

Compensation DOE

Status requirement ---

Job interview type ---

Job Description Consultant: Business Analyst, SQL, -,

Start date : 11/30/2026

End Date : 06/30/2027

Submission deadline :10/30/2026 4:00:00 PM

Client Info :ETF

Note:

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

EOE Protected Veterans/Disability