What are the responsibilities and job description for the Sr Data Analyst - ETL position at SES?
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
- 12 years of overall 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 (SESC), founded in 1989, is a leading provider of technology solutions to Fortune 1000 companies and government organizations. Specializing in Accelerated Development Services (agile application development, mobile, systems integration, project and program management), Architecture Services (SOA, microservices, Cloud), Data Services (DW, BI, Big Data), Testing, Cyber Security and DevOps, SESC is guided by a corporate mission to provide valuable solutions to our client s technology needs through responsive quality services.
Contact Information:
Please contact me for all of the details of the client company, environment, and the position. I look forward to speaking with you.
Jim Murphy