Data Systems Analyst

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
5+ years of experience
Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics, or a related field
Skills
SQL
Snowflake
ETL/ELT Processes
System Integrations and APIs
Test Plan and Test Case Development
Data Quality Validation
SDLC
Cloud Data Warehousing
Business Analysis
Requirements Gathering
Stakeholder Management
Software Quality Assurance
System Integration Testing (SIT)
User Acceptance Testing (UAT)
Regression Testing
Production Validation
Defect Management
Requirements Traceability
Impact Analysis
Data Governance
Root Cause Analysis
Agile Delivery
Process Mapping
Technical Documentation
Schedule
Start date: 2026-11-10