Data & Systems Analyst — SQL, BI & Data Integration

Prospect Infosystem Inc.; Madison (WI); On-site; USD 70,000 - 110,000; Full time

Job summary

Prospect Infosystem Inc. in Madison, WI is seeking a Business/Data Analyst to design and implement efficient data integration processes, translate business needs into technical specs, and develop robust SQL-based solutions.

You will gather requirements, create user stories, perform root-cause analysis on complex datasets, and collaborate with stakeholders to ensure system reliability, testing, and data quality across projects.

Qualifications

• SQL proficiency is required.
• Experience documenting source-to-target data flows for data integration.
• Develop complex SQL queries with 5+ years of experience.
• Gather requirements and write user stories with 5+ years.
• Translate business requirements into technical specifications with 5+ years.
• Perform root cause analysis and data analysis on complex datasets with 5+ years.
• Plan and execute testing, including UAT, and ensure data reconciliation.

Skills

SQL

S2T documentation

Data integration

Complex SQL development

Requirements gathering

User stories

Translate requirements into specs

Root cause analysis

Data analysis

Testing & UAT

Gap analysis

Mentoring users

Data quality tools

BI platforms

Data governance

Dashboards requirements

Data modeling

Documentation writing

Project management

Interpersonal skills

Job description

Prospect Infosystem Inc. in Madison, WI is seeking a Business/Data Analyst to design and implement efficient data integration processes, translate business needs into technical specs, and develop robust SQL-based solutions.

You will gather requirements, create user stories, perform root-cause analysis on complex datasets, and collaborate with stakeholders to ensure system reliability, testing, and data quality across projects.