Business Analyst/Consultant IV

Jobgether; United States; Remote; USD 85,000 - 125,000; Full time

Benefits offered by this job

100% remote within the United States

Job summary

Jobgether is seeking a skilled Business Analyst to lead data management activities across the lifecycle, bridging business needs and technical teams to design efficient data integration, map source-to-target data, and craft precise technical specifications.

You will develop and optimize SQL queries, support dashboards, ensure data quality and governance, and drive testing and UAT in an agile remote environment.

Qualifications

• 5+ years as Business Analyst or Business Systems Analyst.
• 5+ years creating and maintaining source-to-target mappings.
• 5+ years developing complex SQL queries.
• 5+ years gathering requirements and translating them into technical specifications.
• 5+ years conducting root cause analysis on complex datasets.
• 2+ years planning testing, data reconciliation, and UAT.
• Strong analytical, critical-thinking, and problem-solving skills.
• Excellent written and verbal communication with non-technical stakeholders.

Responsibilities

• Lead data management analyses across the lifecycle.
• Serve as liaison between business stakeholders and technical teams.
• Create and maintain S2T mappings for data warehousing.
• Develop and optimize SQL queries for analysis and reporting.
• Gather requirements, write user stories, and translate needs into specs.
• Perform root cause analysis and identify actionable insights.
• Plan, execute, and coordinate testing and UAT.
• Support dashboards, data quality, and governance initiatives.
• Produce documentation including system requirements and user manuals.
• Coordinate training sessions for end users.
• Manage multiple projects in an Agile team.

Skills

Analytical thinking

Critical thinking

Problem solving

Communication

Stakeholder management

Prioritization

Documentation

Tools

Jira

SharePoint

Microsoft Teams

Alteryx

SSIS

SSRS

SSMS

SQuirreL SQL

SQL Server

Tableau

Semarchy

Git

GitHub

Job description

Accountabilities:

In this role, you will lead business and systems analysis activities throughout the data management lifecycle, collaborating with stakeholders to define requirements, improve data processes, and deliver reliable solutions. Your responsibilities will include:

• 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 to support data warehouse and reporting requirements.
• Develop and optimize complex SQL queries to support data analysis, reporting, and troubleshooting.
• Gather business requirements, develop user stories, and translate business needs into detailed technical specifications.
• Perform root cause analysis and analyze complex datasets to identify patterns, trends, discrepancies, and actionable insights.
• Plan and execute testing procedures to validate system functionality, performance, and reliability.
• Conduct data reconciliation, evaluate testing results, and coordinate user acceptance testing with stakeholders to resolve defects.
• Perform gap analysis and cost-benefit assessments to support informed decision‑making.
• Support dashboard requirements gathering, data quality initiatives, and data governance practices, including security and privacy considerations.
• Produce and maintain comprehensive documentation, including system requirements, design specifications, and user manuals.
• Coordinate training sessions and workshops to help end users understand systems, tools, and best practices.
• Manage multiple concurrent projects and tasks while contributing to an agile, collaborative team environment.

Requirements:

The ideal candidate combines strong business analysis expertise with advanced SQL skills, data analysis experience, and excellent communication abilities. You should be comfortable translating complex business needs into technical solutions and collaborating with stakeholders across different functions.

• At least 5 years of experience working as a Business Analyst or Business Systems Analyst.
• At least 5 years of experience developing complex SQL queries.
• At least 5 years of experience creating and maintaining source-to-target mapping documentation and supporting data integration processes.
• At least 5 years of experience gathering requirements, developing user stories, and translating business requirements into technical specifications.
• At least 5 years of experience conducting root cause analysis and analyzing complex datasets to identify patterns, trends, and insights.
• At least 2 years of experience planning and executing testing procedures, performing data reconciliation, analyzing results, and conducting user acceptance testing.
• Strong analytical, critical-thinking, and problem-solving skills.
• Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Ability to collaborate effectively, manage competing priorities, and work across multiple projects.

Preferred qualifications and experience include:

• Experience performing gap analysis and cost-benefit analysis.
• Familiarity with data quality tools and frameworks, business intelligence platforms, and data governance practices.
• Understanding of data security and privacy policies.
• Experience gathering and refining requirements for dashboards.
• Strong knowledge of different data modeling approaches.
• Experience creating technical documentation and delivering user training.
• Ability to mentor colleagues and users in business and systems analysis methodologies.
• Strong interpersonal, collaboration, mentoring, and team‑building skills.
• Experience with relevant tools and technologies, including Jira, SharePoint, Microsoft Teams, Alteryx, SSIS, SSRS, SSMS, Squirrel, SQL Server, Tableau, Semarchy, Git, and GitHub.

Benefits:

• Work arrangement: 100% remote within the United States; Wisconsin residency is not required.
• Contract duration: Initial one-year contract, with an expected end date of June 30, 2027, and the possibility of extension.
• Work environment: Join a small, collaborative team using agile practices to deliver value to business partners.
• Interview process: Remote interviews conducted through Microsoft Teams.
• Compensation and additional benefits: Salary details, healthcare coverage, paid leave, and other benefits were not specified in the job description.