Referral Eligible
Summary:
The Engineer will collaborate closely with our ETL team and the customer in transforming AAG RFL data infrastructure. This role involves utilizing custom applications developing Postgres stored procedures and migrating existing VBA scripts to modern platforms to build and manage ETL processes. Essential for meeting the customers current needs the position also requires preparation for a future transition to modern ETL tools such as Apache NiFi.This position requires extensive experience in data engineering database management and designing efficient ETL workflows without relying on traditional ETL tools and work in collaborative environments involving both team members and customers.
Check out the details below and our awesome benefits here.
Job Qualifications:
Qualifications and skills include:
- Design and develop modular ETL solutions that facilitate data ingestion and delivery across various systems utilizing custom applications and Postgres stored procedures.
- DevelopandmaintainscalabledatastoragesystemsfocusingonPostgresorotherrelational databases to support efficient data retrieval and transformation processes.
- Develop optimized SQL queries and stored procedures that process and transform both structuredandunstructureddataensuringperformanceandreliabilityindatahandling.
- Buildandmanagedatapipelinestailoredforreportingandanalyticsleveragingcustom scripting rather than relying on third-party ETL tools to maintain flexibility and control.
- Collaborate with cross-functional teams to understand data requirements and implement custom data solutions that support the organizations analytics and reporting needs.
- Createcustomscriptsandapplicationstoenhancedatatransformationcapabilitiesand address specific data management requirements.
- Documentdataingestionandtransformationprocessesthoroughlyensuringcompliancewith data governance frameworks including HRPP Privacy HIPAA and SOP guidelines.
- Performqualityassurancetaskstovalidatedataaccuracyandtroubleshootdataquality issues upholding system integrity and reliability.
- Support metadata management practices ensuring all data processes comply with governance standards and industry best practices.
Preferred Qualifications and Skills include:
- Experience with C# and related web application development frameworks.
- Advanced knowledge of Postgres particularly in writing complex stored procedures query optimization and transitioning data infrastructure to Postgres.
- StrongfamiliaritywithAWScloudenvironmentswithexperienceinmigratingdatasystemsto AWS.
- Experiencewithlow-code/no-codeplatformsanddistributeddataprocessingtoolssuchas Spark Databricks or similar.
- Knowledgeofreal-timedataprocessingstreamingapplicationsanddatawarehousing concepts especially in cloud-native environments.
- Proficiencyinshellscriptingandautomationtosupportcloudmigrationsandsystem integrations.
- ExperienceworkinginAgilemethodologiesparticularlywithincloud-basedorhybridcloud environments.
- Requires Security Certification.
Education/Experience includes:
- 4 years of Software Development
Working Conditions:
Prolonged periods sitting at a desk and working on acomputer
Position Type/Expected Hours of Work:
Full time position
Clearance:
This position requires an activeSecret clearance with the ability to obtain TS/SCI.
AAP/EEO Statement:
Equal Opportunity Employer M/F/Disabled/Veteran
Qualified applicants will receive consideration for employment without regard to race color religion sex national origin sexual orientation gender identity disability or protected veteran status.
Zapata Technology accommodation to applicants who are veterans or who have disabilities and are unable to fully use our company application system. If you need a reasonable accommodation for any part of the application and hiring process pleasenotify Christina Hall EEO Coordinator at