Business/Systems Analyst – SQL & Data Mapping

FUSTIS LLC; United States; Remote; USD 50,000 - 83,000; Full time

Job summary

The Wisconsin Department of Employee Trust Funds (ETF) seeks an experienced Business/Systems Analyst to support its Data Management Program. This remote role requires strong SQL skills, data mapping expertise, and the ability to bridge business and technical teams to deliver data-driven solutions.

You will translate business requirements into technical specs, support reporting and data warehouse initiatives, and participate in Agile team activities to deliver high-quality data management

Qualifications

• Minimum 8-10 years of experience as a Business/Systems Analyst.
• Strong hands-on SQL development skills.
• Experience with source-to-target data mapping and data integration analysis.
• Ability to translate business requirements into technical specifications.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Serve as liaison between business stakeholders and technical teams to design data integration processes.
• Develop and document source-to-target mappings and transformation rules.
• Develop and execute complex SQL queries for data analysis and validation.
• Gather requirements, develop user stories, and define acceptance criteria.
• Translate requirements into technical specifications and system requirements.
• Perform root cause analysis and investigate complex datasets for insights.
• Support reporting and data warehouse requirements development.
• Plan and execute system testing, data validation, and UAT.
• Collaborate with stakeholders to troubleshoot issues and validate solutions.
• Prepare system documentation and design specifications.

Skills

SQL

Data mapping

Business analysis

User stories

Acceptance criteria

Root cause analysis

Testing

Job description

Hiring : Business/Systems Analyst – SQL & Data Mapping

Location : 100% Remote

Pay Rate : Up to $60/hr C2C

Experience : 8-10 years

Eligibility : USC, GC-EAD and H4-EAD

Interview : Virtual Interview

Position Overview

The Wisconsin Department of Employee Trust Funds (ETF) is seeking an experienced Business/Systems Analyst to support its Data Management Program. The selected candidate will work with a small, collaborative team that follows Agile practices to deliver data-driven solutions and support business objectives.

The ideal candidate will have strong hands-on SQL development skills, experience with source-to-target data mapping, and a solid background in business and systems analysis. This role requires the ability to bridge the gap between business stakeholders and technical teams, translate business requirements into technical specifications, and analyze complex datasets to support reporting, data integration, and data management initiatives.

Key Responsibilities

• Serve as a liaison between business stakeholders and technical teams to design and implement efficient data integration processes.
• Develop, maintain, and document source-to-target (S2T) mappings, including data fields, transformation rules, and integration requirements.
• Develop and execute complex SQL queries to analyze, validate, and reconcile data.
• Gather and document business requirements, develop user stories, and define acceptance criteria.
• Translate business requirements into clear technical specifications and system requirements.
• Perform root cause analysis of system issues and investigate complex datasets to identify patterns, trends, and insights.
• Support reporting and data warehouse requirements development.
• Plan and execute system testing, data validation, and user acceptance testing (UAT).
• Reconcile data and analyze test results to ensure system functionality, performance, and reliability.
• Collaborate with stakeholders and technical teams to troubleshoot issues, resolve defects, and validate solutions.
• Prepare and maintain system documentation, design specifications, user manuals, and other project deliverables.
• Participate in Agile team activities and collaborate with business partners to deliver effective data management solutions.

Required Qualifications

• Minimum of 5 years of experience as a Business Analyst.
• Minimum of 5 years of experience developing complex SQL queries; hands-on SQL expertise is mandatory.
• Minimum of 5 years of experience in source-to-target mapping, data integration analysis, and related documentation.
• Minimum of 5 years of experience gathering requirements and developing user stories.
• Minimum of 5 years of experience translating business requirements into technical specifications.
• Minimum of 5 years of experience performing systems root cause analysis and analyzing complex datasets.
• Minimum of 2 years of experience in system testing, data reconciliation, result analysis, and user acceptance testing.
• Excellent analytical, problem-solving, critical-thinking, and communication skills.
• Ability to collaborate effectively with business and technical stakeholders.

Preferred Qualifications

• Experience with data quality tools and frameworks.
• Knowledge of business intelligence (BI) platforms and reporting solutions.
• Experience with data governance, data security, and privacy policies.
• Understanding of different data modeling concepts.
• Experience gathering and refining dashboard requirements.
• Experience conducting gap analysis and cost-benefit analysis.
• Ability to create technical documentation, user manuals, and training materials.
• Experience mentoring and training users on business and systems analysis methodologies.
• Ability to manage multiple concurrent projects and priorities.
• Strong interpersonal, collaboration, and team-building skills.

Technical Environment

The ETF technology environment includes: