> Markdown version of [/jobs/ext/3874700-ssrs-ssis-reporting-business-analyst](https://www.wearedevelopers.com/jobs/ext/3874700-ssrs-ssis-reporting-business-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SSRS/SSIS Reporting Business Analyst

- **Company:** Gainwell Technologies
- **Location:** United States (Remote available)
- **Experience:** Experienced
- **Salary:** $51,900.0 - $74,200.0
- **Contract:** Permanent contract
- **Skills:** Sql Server Data Tools (SSDT), Data Analysis, Software Bug Management, Databases, Data Validation, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Warehousing, Relational Databases, Document-Oriented Databases, Microsoft Visual Studio, Microsoft SQL Server, Power BI, Requirements Traceability, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Transact-SQL, Freeform SQL, Tools for Reporting
- **Published:** October 22, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=522289ae02428953

## About the Role

* 3-5+ years of experience as a Business Analyst, Reporting Analyst, Data Analyst, or similar technical role.
 * Experience working with Microsoft SQL Server Reporting Services (SSRS).
 * Working knowledge of SQL Server Integration Services (SSIS) and ETL/data-integration concepts.
 * Strong SQL/T-SQL skills with the ability to query, analyze, reconcile, and validate data.
 * Experience developing report specifications, business requirements, data mappings, user stories, and acceptance criteria.
 * Experience with source-to-target mapping and data-transformation requirements.
 * Strong understanding of relational databases and data relationships.
 * Experience performing report and data validation, defect management, and UAT.
 * Strong analytical, troubleshooting, and root-cause-analysis skills.
 * Excellent written and verbal communication skills with the ability to work effectively with both technical and business stakeholders.

What sets you apart

 * Experience with SQL Server, SSRS, SSIS, SSDT, Visual Studio, and T-SQL.
 * Knowledge of stored procedures, views, functions, and complex SQL queries.
 * Experience with Power BI, data warehousing, or business intelligence solutions.
 * Healthcare, Medicaid, pharmacy, claims, or government program experience preferred., #LI-SQL Server

#LI-SSRS

#LI-SSIS

#LI-T-SQL

Please ensure you join all screenings, interviews and meetings from a quiet location with a stable internet connection.

## Description

As a SSRS/SSIS Reporting Business Analyst at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve - a community's most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare's biggest challenges. Here are the details on this position., We are seeking an experienced SSRS/SSIS Reporting Business Analyst to serve as the liaison between business stakeholders and technical teams. This role will gather and translate business reporting needs into detailed requirements, analyze data, define source-to-target mappings, support SSRS/SSIS development, and validate reporting and data-integration solutions. The ideal candidate combines strong Business Analyst skills with hands-on SQL and reporting/data analysis experience., * Gather, analyze, document, and manage business, reporting, and data requirements.

 * Translate business needs into functional requirements, user stories, acceptance criteria, report specifications, and data mappings.
 * Define SSRS report requirements including fields, parameters, filters, calculations, grouping, sorting, and business rules.
 * Partner with developers to support development and enhancement of SSRS reports and SSIS/ETL processes.
 * Analyze source and target data and develop source-to-target mapping documentation.
 * Use SQL queries to research data, validate report results, reconcile discrepancies, and support root-cause analysis.
 * Document data transformation and validation rules for SSIS processes.
 * Work with business and technical teams to understand database tables, views, stored procedures, data relationships, and system interfaces.
 * Develop test scenarios and test cases and perform functional, integration, regression, and data-validation testing.
 * Coordinate and support User Acceptance Testing (UAT) and business sign-off.
 * Investigate production reporting and data issues and coordinate resolution across business, development, and database teams.
 * Maintain requirements traceability and ensure delivered solutions meet approved business requirements.