Business Analyst/Consultant IV

Business Analyst/Consultant IVJoin 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.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.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.