Sr Data Analyst - ETL, Data Integration

We are seeking an experienced Senior Data Analyst to support database, ETL, and data integration initiatives. This role will work closely with business stakeholders, technical teams, and QA resources to gather requirements, define data needs, support ETL development, and validate data loads.

The ideal candidate has strong experience with the software development lifecycle, SQL, data analysis, source-to-target mapping, requirements documentation, and test script execution. This person must be able to translate business needs into clear technical specifications and help identify, escalate, and resolve data-related issues throughout the project lifecycle.

Key Responsibilities

• Gather, analyze, and document business and user requirements related to database changes, data integration, and ETL processes.
• Translate high-level business requirements into detailed database and ETL requirements, including source-to-target mappings.
• Work with business users, developers, ETL teams, QA teams, and project stakeholders during requirements, design, development, testing, and implementation phases.
• Participate in functional design sessions and contribute to the definition of data flows, business rules, transformation logic, and validation requirements.
• Create detailed functional specifications and supporting documentation for ETL and database development teams.
• Write and execute test scripts to validate database loads, data transformations, and downstream data accuracy.
• Query databases using SQL to perform data analysis, validation, reconciliation, and issue investigation.
• Support defect identification, documentation, escalation, and resolution related to data quality, data movement, and system processing.
• Document current and future-state business processes as needed.
• Support testing activities, including functional testing, data validation, regression testing, and automation support using tools such as Selenium.
• Manage multiple priorities in a fast-paced project environment while maintaining strong attention to detail.

Required Skills and Experience

• Strong knowledge of the Software Development Lifecycle.
• Proven experience gathering and documenting business, database, and ETL requirements.
• Ability to create source-to-target mappings and define transformation rules.
• Strong SQL skills for querying, analyzing, and validating data.
• Experience creating and executing test scripts for database, ETL, or data integration projects.
• Ability to document business processes, workflows, data flows, and functional specifications.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent written and verbal communication skills.
• Ability to work effectively with both business and technical teams.
• Strong organizational skills with the ability to manage multiple tasks and priorities.
• Experience with Selenium or similar test automation tools is desired.

Education and Experience

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field preferred.
• Professional certifications are a plus.
• 15 years of software development, data analysis, database, ETL, or related project experience.
• Prior experience supporting projects of similar scope and complexity is strongly preferred.

Preferred Qualifications

• Experience working on enterprise data warehouse, data migration, data integration, or application modernization projects.
• Familiarity with ETL tools, relational databases, reporting platforms, and QA/test management processes.
• Experience working in Agile, Waterfall, or hybrid delivery environments.
• Ability to bridge communication between business users, development teams, ETL teams, and QA teams.

About SES Systems Engineering Services Corporation: