Business Analyst/Consultant IV

Jobgether; Oregon; Híbrido; USD 90.000 - 130.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

100% remote within the United States

Descripción de la vacante

Jobgether is seeking a Business Analyst/Consultant IV for a fully remote, one-year contract with a public-sector data initiative in the United States. You will bridge business needs with technical teams to design data integration, reporting, data warehousing, and quality initiatives using SQL within an agile environment.

You will lead requirements, create user stories, perform gap analyses, and coordinate testing and UAT while ensuring data accuracy and security.

Formación

• 5+ years as a Business Analyst or Business Systems Analyst.
• 5+ years developing complex SQL queries.
• 5+ years creating source-to-target mapping documentation and supporting data integration.
• 5+ years gathering requirements, developing user stories, translating business needs into technical specs.
• 5+ years conducting root cause analysis and analyzing complex datasets.

Responsabilidades

• Lead business and systems analysis across the data management lifecycle with stakeholders to define requirements and improve data processes.
• Design and implement data integration processes between systems and data warehouses.
• Develop and optimize SQL queries for reporting, analysis, and troubleshooting.
• Translate business requirements into detailed technical specifications and user stories.
• Coordinate testing, data reconciliation, and UAT with stakeholders to resolve defects.
• Support dashboards, data quality initiatives, and data governance practices.

Conocimientos

Business analysis

SQL

Data analysis

Communication

Herramientas

Jira

SharePoint

Microsoft Teams

Alteryx

SSIS

SSRS

SSMS

Squirrel

SQL Server

Tableau

Semarchy

Git

GitHub

Descripción del empleo

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Business Analyst/Consultant IV based in the United States.Join a collaborative data management team supporting a public-sector organization in its mission to become more data-driven and data-literate. As a Business Analyst/Consultant IV, you will bridge business stakeholders and technical teams to design effective data integration processes and translate complex requirements into actionable technical solutions. You will contribute to reporting, data warehousing, and data quality initiatives while using SQL and advanced analytical techniques to uncover insights and resolve system issues. Working within an agile environment, you will help ensure data accuracy, system reliability, and alignment with business needs. This fully remote, one-year contract is open to candidates nationwide and offers the opportunity to contribute to meaningful data initiatives in government services.

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.