Senior Data Analyst - support database, ETL, and data integration initiatives
Type: W2 With Benefits - No C2C
Location: Hybrid 2-3 days onsite in Reston, VA
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:
SESC was founded in 1989, is a leading provider of technology solutions to Fortune 1000 companies and government organizations. Specializing in Accelerated Development (agile application development, mobile, systems integration, project and program management), Architecture (SOA, microservices, cloud), Data (analytics, DW, BI, big data), Testing (test architecture, manual, automation, data), Cyber Security (SSO, mobile, IAM) and DevOps (roadmap creation, assessments, CICD, tool evaluation, implementation), Employer is guided by a corporate mission to provide valuable solutions to our client s technology needs through responsive quality services.
Benefits:
SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical dental vision life LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more.
Please contact me to discuss the details of this position further.
*Please forward resume directly to for immediate consideration - rstarinieri at sesc .com
I look forward to speaking with you soon!
Robin Starinieri
Director of Recruiting
Systems Engineering Services
Never miss an opportunity! Create an alert based on the job you applied for.