[Remote] SSRS/SSIS Reporting Business Analyst

Note: The job is a remote job and is open to candidates in USA. Gainwell Technologies is seeking an SSRS/SSIS Reporting Business Analyst to serve as a liaison between business stakeholders and technical teams. The role translates reporting needs into requirements, analyzes and maps data, supports SSRS/SSIS development, and validates reporting and data-integration solutions.

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

Skills

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

Benefits

• Fully remote options from Contiguous US locations only
• All salaried, full-time candidates are eligible for our generous, flexible vacation policy
• A 401(k) employer match
• Comprehensive health benefits
• Educational assistance
• Leadership and technical development academies to help build your skills and capabilities

Company Overview

Company H1B Sponsorship