SSRS/SSIS Reporting Business Analyst

Gainwell Technologies LLC; United States; Remote; USD 52,000 - 74,000; Full time

Benefits offered by this job

Health benefits

401(k) employer match

Generous vacation policy

Educational assistance

Job summary

Gainwell Technologies LLC is seeking an experienced SSRS/SSIS Reporting Business Analyst to bridge business needs with technical delivery. You will gather reporting requirements, translate them into data mappings and functional specs, and support SSRS/SSIS development and validation of data integrations.

The ideal candidate combines strong BA skills with hands-on SQL and reporting experience, with fully remote options available for Contiguous US locations.

Qualifications

• 3–5+ years as a BA, Reporting Analyst, Data Analyst, or similar technical role.
• Experience with Microsoft SQL Server Reporting Services (SSRS).
• Working knowledge of SSIS and ETL concepts.
• Strong SQL/T-SQL skills for data querying and validation.
• Experience drafting report specs, data mappings, and user stories.
• Experience with source-to-target mapping and data transformations.
• Knowledge of relational databases and data relationships.
• Experience with test planning including UAT.

Responsibilities

• Gather, analyze, document, and manage business, reporting, and data requirements.
• Translate needs into functional requirements, user stories, and data mappings.
• Define SSRS report requirements: fields, parameters, filters, calculations, grouping, sorting.
• Partner with developers to support SSRS/SSIS development and ETL processes.
• Analyze data sources, validate reports, and resolve discrepancies.
• Document transformation rules for SSIS and support testing efforts.
• Develop test scenarios, execute tests, and coordinate UAT with stakeholders.
• Maintain traceability to ensure delivered solutions meet requirements.

Skills

SSRS

SSIS

SQL

Data analysis

Requirements gathering

UAT

Communication

Troubleshooting

Tools

SQL Server

SSRS

SSIS

SSDT

Visual Studio

Power BI

Job description

Great companies need great teams to propel their operations. Join the group that solves business challenges and enhances the way we work and grow. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values your contributions and puts a premium on work flexibility, learning, and career development.

Summary

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.

Your role in our mission

• 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.

What we’re looking for

• 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.

What you should expect in this role

• Fully remote options from Contiguous US locations only
• Video cameras must be used during all interviews, as well as during the initial week of orientation
• Photo will be taken during screening for verification in all steps of the recruitment process.

The deadline to submit applications for this posting is November 12, 2026

The pay range for this position is $51,900.00 - $74,200.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job‑related knowledge, skills, and experience among other factors.

All salaried, full‑time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits , and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.

We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll have joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.

Gainwell Technologies is an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), age, sexual orientation, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. Gainwell Technologies defines “wages” and “wage rates” to include “all forms of pay, including, but not limited to, salary, overtime pay, bonuses, stock, stock options, profit sharing and bonus plans, life insurance, vacation and holiday pay, cleaning or gasoline allowances, hotel accommodations, reimbursement for travel expenses, and benefits.