Business Analyst – SQL, Data Warehouse & Reporting

Business Systems Analyst – Data & Reporting

Key Responsibilities:

• Serve as a liaison between business stakeholders and technical teams to define and implement data solutions.
• Gather, analyze, and document business and reporting requirements.
• Develop user stories, technical specifications, and source-to-target mapping documents.
• Write complex SQL queries to validate data, investigate issues, and support reporting requirements.
• Analyze data discrepancies, perform root cause analysis, and recommend solutions.
• Support data integration, data warehouse, reporting, and dashboard initiatives.
• Develop test scenarios, perform data reconciliation, support UAT, and coordinate defect resolution.
• Prepare and maintain functional documentation, technical specifications, and user guides.
• Collaborate with cross-functional teams to improve data quality, governance, and reporting processes.
• Support Agile team activities and manage multiple assignments while meeting project deadlines.

Required Skills & Qualifications:

• Minimum 5 years of experience as a Business Systems Analyst, Business Analyst, or in a similar role.
• Minimum 5 years of experience developing complex SQL queries and performing data analysis.
• Minimum 5 years of experience gathering business requirements, developing user stories, and translating requirements into technical specifications.
• Minimum 5 years of experience creating and maintaining source-to-target (S2T) mapping documentation and supporting data integration processes.
• Minimum 5 years of experience performing root cause analysis and analyzing complex datasets to identify data issues, patterns, and trends.
• Minimum 2 years of experience developing and executing test plans, performing data reconciliation, supporting User Acceptance Testing (UAT), and resolving defects.
• Experience with data warehouse requirements, reporting, and dashboard development.
• Strong understanding of data models, data integration, and data quality principles.
• Excellent written and verbal communication skills, with the ability to work effectively with business and technical stakeholders.
• Strong analytical, problem-solving, documentation, and organizational skills.

Preferred Qualifications:

• Experience with Business Intelligence (BI) and reporting tools such as Tableau or SSRS.
• Familiarity with SQL Server, SSMS, SSIS, and other data integration tools.
• Experience with data quality frameworks, data governance, and data security and privacy policies.
• Experience performing gap analysis and cost-benefit analysis.
• Familiarity with Agile methodologies and tools such as Jira.
• Experience preparing system requirements, technical specifications, user documentation, and training materials.
• Ability to manage multiple projects, facilitate stakeholder discussions, and provide guidance to end users.