Job Summary
The Data Systems Analyst will serve as a bridge between business stakeholders, product teams, data engineers, developers, and QA teams to deliver high-quality data and technology solutions. The role involves gathering and documenting requirements, analyzing business processes, supporting solution design, coordinating testing activities, and validating system and data quality across enterprise platforms. The ideal candidate will have strong business analysis skills, a thorough understanding of the Software Development Life Cycle (SDLC), and hands-on experience testing complex system integrations and data platforms. The analyst will ensure business requirements are translated into scalable solutions and thoroughly validated before deployment.
Key Responsibilities
• Partner with business stakeholders to understand business objectives, operational challenges, and system requirements.
• Gather, analyze, document, and validate functional and non-functional requirements.
• Conduct discovery sessions, workshops, stakeholder interviews, and requirements review sessions.
• Translate business needs into user stories, acceptance criteria, process flows, business rules, and functional specifications.
• Create and maintain process maps, workflow diagrams, data mappings, and system documentation.
• Perform impact analysis and identify risks, dependencies, and upstream and downstream system impacts.
• Collaborate with Product Owners, Architects, Developers, Data Engineers, QA teams, and business stakeholders throughout the delivery lifecycle.
• Develop test strategies, test plans, test cases, test scripts, and traceability matrices.
• Coordinate and support System Integration Testing (SIT), User Acceptance Testing (UAT), Regression Testing, and Production Validation activities.
• Design and execute test scenarios to validate business processes, data accuracy, integrations, and system functionality.
• Collaborate with QA and Engineering teams to identify, document, prioritize, and track defects through resolution.
• Validate implemented solutions against documented requirements and acceptance criteria.
• Support release readiness reviews, deployment validation, and post-production verification.
• Ensure end-to-end traceability between requirements, development deliverables, and testing outcomes.
• Develop SQL queries to analyze, reconcile, profile, and validate enterprise data.
• Perform source-to-target validation across data pipelines and integrations.
• Validate ETL/ELT processes, transformation logic, and business rule implementation.
• Conduct root cause analysis for data and system issues.
• Analyze trends, anomalies, and data quality concerns.
• Partner with Data Engineering teams to investigate production issues and identify corrective actions.
• Support data governance, metadata, lineage, and data quality initiatives.
• Query and validate data within Snowflake using advanced SQL.
• Work with Snowflake concepts, including databases, schemas, warehouses, stages, streams, tasks, and secure views.
• Support testing and validation of data pipelines, integrations, and reporting datasets.
• Collaborate with Data Engineers supporting Matillion, dbt, Informatica, or comparable ETL/ELT platforms.
• Validate data consistency across enterprise applications, data warehouses, and reporting environments.
• Participate in Agile ceremonies, including sprint planning, backlog refinement, stand-ups, reviews, and retrospectives.
• Communicate project status, risks, issues, testing results, and recommendations to leadership and stakeholders.
• Support implementation planning, release validation, and post-production stabilization efforts.
• Drive continuous improvement in requirements management, testing practices, and solution delivery processes.
Required Qualifications
• Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics, or a related field; equivalent experience may be considered.
• 5+ years of experience in Systems Analysis, Business Analysis, Software Quality Assurance, or related disciplines.
• Experience gathering and documenting business and system requirements.
• Strong requirements elicitation, analysis, and documentation skills, including user story creation, acceptance criteria, and process documentation.
• Strong experience developing test plans, test cases, test scripts, and validation strategies.
• Experience supporting SIT, UAT, Regression Testing, and Production Validation.
• Strong testing expertise, including defect management and end-to-end traceability.
• Advanced SQL skills for data analysis, reconciliation, profiling, and validation.
• Hands-on experience with Snowflake or a comparable cloud data platform.
• Experience working with enterprise system integrations, APIs, ETL/ELT processes, and data pipelines.
• Experience validating system integrations, data workflows, and reporting datasets.
• Experience working within Agile/Scrum environments and supporting software and data product delivery.
• Strong analytical thinking, troubleshooting, and root cause analysis skills.
• Ability to communicate effectively with technical teams, business stakeholders, and leadership.
• Strong organizational skills with the ability to manage multiple priorities.
• Excellent verbal, written, presentation, and stakeholder management skills.
• Commitment to solution quality, testing rigor, and continuous improvement.
