Business Systems Analyst / Business Analyst Consultant

Posted 2 Days Ago
Madison, WI, USA
In-Office
Senior level
Information Technology
The Role
Analyzes business and technical needs for data integration initiatives. Responsibilities include requirements gathering, source-to-target mapping, complex SQL development, data validation, reconciliation, testing, UAT, root cause analysis, documentation, data quality and governance support, dashboard requirements, stakeholder collaboration, and user training within an Agile environment.
Summary Generated by Built In
Company Description

StarTekk’s adoption of Digital Transformation is to accelerate organizational growth, increase efficiencies and help Star Workforce achieve focused business goals. The Employee will help our organization to identify and bridge the gap that exists in the business by analyzing the data, scale and support digital transformation initiatives.

Job Description

We are seeking an experienced Business Systems Analyst to join a collaborative Data Management Program team. The ideal candidate will have strong experience in SQL development, data analysis, data warehouse requirements, source-to-target mapping, and business systems analysis.

The candidate will work closely with business stakeholders and technical teams to define requirements, develop technical specifications, support data integration initiatives, and ensure data quality and accuracy. Experience working in an Agile environment and excellent communication skills are essential.

Key Responsibilities

  • Act as a liaison between business stakeholders and technical teams to design and implement efficient data integration processes.

  • Create and maintain Source-to-Target (S2T) mapping documentation.

  • Write and analyze complex SQL queries for data validation, reconciliation, and troubleshooting.

  • Gather business requirements and develop user stories.

  • Translate business requirements into detailed technical specifications.

  • Perform root cause analysis and analyze complex datasets to identify patterns, trends, and discrepancies.

  • Develop and execute test plans to ensure system functionality, performance, and reliability.

  • Perform data reconciliation and validate testing results.

  • Support User Acceptance Testing (UAT) and collaborate with stakeholders to resolve defects.

  • Conduct gap analysis and cost-benefit analysis as needed.

  • Gather and refine requirements for reports and dashboards.

  • Create and maintain system documentation, design specifications, and user guides.

  • Support data quality, data governance, and data security initiatives.

  • Collaborate with cross-functional teams in an Agile environment.

  • Provide training and guidance to end users on business and systems analysis methodologies.

Qualifications

  • Minimum 5 years of experience serving as a liaison between business and technical teams for data integration initiatives, including Source-to-Target (S2T) mapping.

  • Minimum 5 years of experience developing complex SQL queries.

  • Minimum 5 years of experience gathering requirements and developing user stories.

  • Minimum 5 years of experience translating business requirements into technical specifications.

  • Minimum 5 years of experience performing root cause analysis and analyzing complex datasets.

  • Minimum 2 years of experience with testing, data reconciliation, and User Acceptance Testing (UAT).

  • Strong analytical, critical-thinking, and problem-solving skills.

  • Excellent written and verbal communication skills.

  • Ability to manage multiple tasks and collaborate effectively with stakeholders.

Additional Information

  • Experience with data quality tools and frameworks.

  • Experience with Business Intelligence (BI) platforms and dashboard requirements.

  • Knowledge of data governance, data security, and privacy policies.

  • Strong understanding of data modeling concepts.

  • Experience conducting gap analysis and cost-benefit analysis.

  • Experience preparing technical documentation and conducting user training.

  • Experience mentoring team members and business users.

  • Familiarity with Agile methodologies and project management practices.

Technical Environment

  • SQL Server

  • SQL Server Management Studio (SSMS)

  • SQL Server Integration Services (SSIS)

  • SQL Server Reporting Services (SSRS)

  • Tableau

  • Alteryx

  • Jira

  • SharePoint

  • Microsoft Teams

  • Semarchy

  • Git / GitHub

  • SQuirreL SQL Client

Skills Required

  • Minimum 5 years serving as a liaison between business and technical teams for data integration initiatives, including source-to-target mapping
  • Minimum 5 years developing complex SQL queries
  • Minimum 5 years gathering requirements and developing user stories
  • Minimum 5 years translating business requirements into technical specifications
  • Minimum 5 years performing root cause analysis and analyzing complex datasets
  • Minimum 2 years of experience with testing, data reconciliation, and User Acceptance Testing
  • Strong analytical, critical-thinking, and problem-solving skills
  • Excellent written and verbal communication skills
  • Ability to manage multiple tasks and collaborate effectively with stakeholders
  • Experience with data quality tools and frameworks
  • Experience with Business Intelligence platforms and dashboard requirements
  • Knowledge of data governance, data security, and privacy policies
  • Strong understanding of data modeling concepts
  • Experience conducting gap analysis and cost-benefit analysis
  • Experience preparing technical documentation and conducting user training
  • Experience mentoring team members and business users
  • Familiarity with Agile methodologies and project management practices
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
Dallas, TX
23 Employees
Year Founded: 2013

What We Do

StarTekk puts the power back in your hands & lets you seek out your concepts and ideas to make it a reallity the way you want. With our seasoned and brilliant workforce, we serve business from the inside. Partnering with client teams, we solve problems, implement initiatives and help drive change through all levels of business over the nation.

Similar Jobs

Sprinter Health Logo Sprinter Health

Credentialing & Payor Enrollment Analyst

Artificial Intelligence • Healthtech • Logistics • Social Impact • Software • Telehealth
Remote or Hybrid
United States
500 Employees
70K-75K Annually

Toast Logo Toast

Bilingual Hybrid Development Representative - Mandarin

Cloud • Fintech • Food • Information Technology • Software • Hospitality
Remote or Hybrid
United States
5000 Employees
75K-120K Annually
Easy Apply
Remote or Hybrid
United States
2200 Employees
21-21 Annually

Hewlett Packard Enterprise Logo Hewlett Packard Enterprise

VLSI Physical Design Lead Engineer

Artificial Intelligence • Cloud • Information Technology • Consulting
In-Office
3 Locations
85422 Employees
160K-367K Annually

Similar Companies Hiring

Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account