The Data ETL Specialist defines the client's data migration requirements, analyzes the tech stack required for client's end-to-end (E2E) data migration, and builds custom ETL scripts/tools and data validation reports to ingest client data into the digital environment. This position requires 1: an expert understanding of ETL processes, APIs, and automation scripting to streamline the receiving, transforming, and loading of the delivered data; 2: an understanding of data schemas and bulk data-loading tools and techniques ; 3: ability to obtain a Secret clearance; 4: ability to acquire and maintain an IAT II certification such as Security+. The ETL specialist will be a part of a broader solution team which spans expertise across a larger digital ecosystem, and communication across domains will be required for understanding data model changes/updates, cyber security constraints, infrastructure requirements, and access controls that will impact data migration activities. Understanding of Agile software development is preferred. The ideal candidate is located near Dayton OH to support future classified activities, configuration and data load work on client site. Full telework will be considered. Experience with Siemens Teamcenter as well as CAD and CAD integration software (installation, configuration, mapping, etc.) are desired.
What You'll Do
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.
- Elicit requirements from clients
- Support bulk migration of data into through automation scripts and utilization of APIs
- Create reports to assist clients in data analysis decisions
- Create technical documentation for data migration processes and utilities
- Create test cases to support the generation of automation scripts
- Test executed solutions and troubleshoot anomalies to resolution
- Coordinate issue resolution with Technical Support and similar infrastructure / software support activities
- Analyze migration performance and optimize solutions
- Coordinate with Scrum Master, Product Owners, Information System Security Engineering (ISSE), Engineering Subject Matter Experts and Infrastructure/Network administrators on broader team to accomplish objectives
- Other Duties as assigned
Your Qualifications
- US Citizen
- Ability to obtain Secret clearance
- IAT II certification such as Security +
- 4+ years of writing automation scripts using Python or PowerShell
- Experience reading and understand API documentation
- Experience creating documentation around tools and processes
- Strong spoken and written English skills
- Experience delivering presentations to clients
- Adequate home working environment to include dedicated office-space to enable productive remote work
Equal Opportunity Employer including Disability and Veterans
Employees must abide by Sabel System's government contracts and any federal, state, and local laws regarding COVID-19 vaccination and related requirements.