Remote SSRS/SSIS Reporting Business Analyst

Gainwell Technologies LLC; Columbus (OH); Remote; USD 52,000 - 74,000; Full time

Benefits offered by this job

401(k) employer match

Health benefits

Educational assistance

Job summary

Gainwell Technologies LLC is seeking a SSRS/SSIS Reporting Business Analyst to bridge business stakeholders and technical teams. You will translate reporting needs into detailed requirements, analyze data, and validate reporting and data-integration solutions, leveraging your SQL and BI expertise.

You will gather and document requirements, define mappings, support SSRS/SSIS development, and coordinate testing including UAT, with focus on healthcare data and reporting accuracy.

Qualifications

• 3-5+ years of experience as a Business Analyst, Reporting Analyst, Data Analyst, or similar technical role.
• Experience with Microsoft SQL Server Reporting Services (SSRS).
• Working knowledge of SSIS and ETL/data-integration concepts.
• Strong SQL/T-SQL skills 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.

Responsibilities

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

Skills

Analytical thinking

Communication skills

Requirements gathering

Requirements translation

Business analysis

Tools

SSRS

SSIS

SSDT

Visual Studio

SQL Server

Power BI

Job description

Gainwell Technologies LLC is seeking a SSRS/SSIS Reporting Business Analyst to bridge business stakeholders and technical teams. You will translate reporting needs into detailed requirements, analyze data, and validate reporting and data-integration solutions, leveraging your SQL and BI expertise.

You will gather and document requirements, define mappings, support SSRS/SSIS development, and coordinate testing including UAT, with focus on healthcare data and reporting accuracy.