Onyx Government Services · 1 day ago
Senior ETL Developer
United States
Full-time
Remote
Senior Level
7+ years expOnyx Government Services is a Service-Disabled Veteran-Owned Small Business specializing in data management and integration solutions. They are seeking a Senior ETL Developer with experience in data warehousing and Cloud migration to support Federal data management and Advanced Analytics projects, focusing on designing ETL processes and ensuring data quality assurance.
Big DataGovernmentInformation Technology
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Design and develop ETL processes
Convert existing PL/SQL procedures into SSIS packages
Troubleshoot existing ETL solutions
Query Oracle databases for data analysis and data quality assurance
Qualification
Required
Must possess active BI or NACLC Public Trust security clearance
Bachelor's degree with 7 years of database (specifically ETL) development, or data processing/analytical experience or combination thereof
Strong SQL and PL/SQL skills
Expertise with data warehouse designs and the Kimball dimensional model
Experience with writing complex SSIS transformations, reverse engineering from Oracle PL/SQL
Experience with Oracle and PostgreSQL databases
Strong conceptual, analytical, and decision-making skills
Ability to work as a collaborative team, mentoring and training the client on the various tools and techniques to build a complete data warehouse solution
Experience with Jira in managing tasks and good understanding of Agile process
Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools quickly
Excellent innovation, interpersonal, and communication skills required
Must have good communication and writing skills
Familiarity with Gilab CI/CD Pipelines
Familiarity with SQL Server Agent orchestration framework
Preferred
Previous consulting experience using an agile delivery methodology is a plus
Experience in Tableau dashboard design and development
SAS Enterprise Guide development
Quality assurance and validation experience, specifically comparing multiple data sources for discrepancies and inconsistencies
Company
Onyx Government Services
Onyx Government Services is an IT company specializing in data-driven solutions.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase