Business Analyst, SSRS/SSIS Reporting

This is a fully remote position, open to applicants in United States.

📋 Description

• Collect, analyze, document, and oversee business, reporting, and data requirements.

• Convert business needs into functional requirements, user stories, acceptance criteria, report specifications, and data mappings.

• Establish SSRS report requirements, encompassing fields, parameters, filters, calculations, grouping, sorting, and business rules.

• Collaborate with developers to facilitate the development and enhancement of SSRS reports and SSIS/ETL processes.

• Examine source and target data, creating source-to-target mapping documentation.

• Utilize SQL queries to investigate data, verify report outcomes, reconcile discrepancies, and assist with root-cause analysis.

• Document data transformation and validation rules for SSIS processes.

• Engage with business and technical teams to comprehend database tables, views, stored procedures, data relationships, and system interfaces.

• Create test scenarios and test cases, and execute functional, integration, regression, and data-validation testing.

• Coordinate and support User Acceptance Testing (UAT) and facilitate business sign-off.

• Address production reporting and data issues, coordinating resolution across business, development, and database teams.

• Maintain requirements traceability and ensure that delivered solutions align with approved business requirements.

⛳️ Requirements

• 3–5+ years of experience in a role such as Business Analyst, Reporting Analyst, Data Analyst, or a comparable technical position.

• Proficiency in working with Microsoft SQL Server Reporting Services (SSRS).

• Familiarity with SQL Server Integration Services (SSIS) and ETL/data-integration concepts.

• Strong skills in SQL/T-SQL.

• Experience in developing report specifications, business requirements, data mappings, user stories, and acceptance criteria.

• Background in source-to-target mapping and data-transformation requirements.

• Solid understanding of relational databases and data relationships.

• Experience in report and data validation, defect management, and UAT.

• Strong analytical, troubleshooting, and root-cause-analysis capabilities.

• Excellent written and verbal communication skills.

• Familiarity 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 available for candidates located in the contiguous United States only.

• Video cameras are required for all interviews and during the initial week of orientation.

• A photo will be taken during screening for verification throughout all stages of the recruitment process.

• Candidates must participate in screenings, interviews, and meetings from a quiet location with a stable internet connection.

• Video is mandatory for screenings and interviews.

• The use of AI tools, virtual backgrounds/filters, or visual enhancements during the interview is prohibited.

🏝️ Benefits

• Flexible work arrangements.

• Opportunities for learning and career advancement.

• Generous and flexible vacation policy.

• 401(k) employer matching.

• Comprehensive health benefits.

• Educational assistance.

• Leadership and technical development academies.