Business Analyst, SSRS/SSIS Reporting
Gainwell Technologies
Posted: 10/21/2026ETLMS SQL ServerSQLSSIS
Technical Business Analyst
Polaris Software
Posted: 10/21/2026
Business Systems Analyst – ServiceNow, IT Infrastructure
Stafford Gray LLC
Posted: 10/21/2026ServiceNowVoIP
Senior Business Analyst, Growth Operations, Reporting & Analytics
CETERA
Posted: 10/21/2026SQLTableau
Lead Business Systems Analyst – CAD/RMS
Maricopa County Sheriff's Office
Posted: 10/20/2026CloudSQL
IT Business Analyst, Entry Level, Insurance
Marsh McLennan
Posted: 10/20/2026SQL
Senior Business Analyst, Global Ops Scalability
Equinix
Posted: 10/20/2026
Data Business Systems Analyst
Kemper
Posted: 10/20/2026AWSAzureCloudETLInformaticaOraclePythonSQL
Business Analyst Intern
Tokio Marine North America Services
Posted: 10/20/2026AzureSDLCServiceNow
Commercial Business Analyst
ZT Systems
Posted: 10/20/2026CloudOraclePMP
Senior Analyst, Business Analysis
CVS Health
Posted: 10/20/2026CloudSQLTableau
Business Management Analyst 2
Northrop Grumman
Posted: 10/20/2026CognosERPVBA
Lead Analyst, Business Transformation
The AES Corporation
Posted: 10/20/2026PMP
Lead Business Analyst
Broadridge
Posted: 10/20/2026ETLPythonSQL
Configuration Management Analyst I – Software Systems
Sierra Space
Posted: 10/20/2026Property and Asset Management Analyst
Northrop Grumman
Posted: 10/20/2026ERP
Business Analyst
Public Consulting Group
Posted: 10/20/2026
Senior Balance Sheet Management Analyst – Executive Analytics, Strategic Initiatives
WF
Posted: 10/20/2026PythonSQL
Account Risk Management Analyst
Federal Reserve Board
Posted: 10/20/2026
IT Configuration and Change Business Analyst
Computer World Services
Posted: 10/20/2026ITSMServiceNow
Business Analyst, SSRS/SSIS Reporting
Gainwell TechnologiesCore Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in gathering and analyzing business requirements, translating them into functional specifications, and developing comprehensive reporting solutions using SQL Server Reporting Services (SSRS) and SQL. Proficient in data validation, UAT coordination, and maintaining requirements traceability to ensure alignment with business objectives.
Highest-signal resume keywords
SQL Server Reporting Services (SSRS)SQL/T-SQL SkillsSQL Server Integration Services (SSIS)Data Mapping and TransformationUser Acceptance Testing (UAT)
Tech Stack
Tools & technologiesAbout the role
Key responsibilities & impact- 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
Requirements
What you’ll need- 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
- 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
- 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
- Fully remote options from Contiguous US locations only
- Video cameras must be used during all interviews and during the initial week of orientation
- Photo will be taken during screening for verification in all steps of the recruitment process
- Must join screenings, interviews, and meetings from a quiet location with a stable internet connection
- Video is required for screenings and interviews
- Must not use AI tools, virtual backgrounds/filters, or visual enhancements during the interview
Benefits
Comp & perks- Work flexibility
- Learning and career development
- Generous, flexible vacation policy
- 401(k) employer match
- Comprehensive health benefits
- Educational assistance
- Leadership and technical development academies
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data AnalysisReport Specification DevelopmentSource-to-Target MappingRelational Database UnderstandingData ValidationDefect ManagementRoot-Cause AnalysisTest Scenario DevelopmentComplex SQL QueriesBusiness Requirements Documentation
Soft Skills
Analytical SkillsTroubleshooting SkillsWritten CommunicationVerbal Communication
Tools & Technologies
SQL ServerSSRSSSISSSDTVisual StudioPower BIData WarehousingBusiness Intelligence Solutions