Business System Analyst

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

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