ETL Developer

Benefits: 401(k) 401(k) matching Bonus based on performance Competitive salary Dental insurance Donation matching Health insurance Opportunity for advancement Paid time off Profit sharing Training & development Tuition assistance Vision insurance Wellness resources Location: Fully Remote (United States) — no onsite work required Employment Type: Contract (Full-Time), multi-year engagement with potential for extension About AKIVA AKIVA is an AI-native engineering firm specializing in enterprise services, domain-specific solutions, and high-performance infrastructure from strategy through deployment. We build innovative systems that drive measurable results for commercial enterprises and government agencies. AKIVA is a certified Service-Disabled Veteran-Owned Small Business (SDVOSB). Position Overview AKIVA is seeking ETL Developers to design, develop, and maintain extract-transform-load (ETL) processes in support of a multi-year public-sector application modernization program. In this role you will build ETL strategies that move structured and unstructured data from legacy source systems into modern target platforms — developing robust data mappings, automated workflows, validation routines, and audit logging. You will collaborate closely with client stakeholders, data architects, and application development teams in a Scrum-based delivery environment. AKIVA-provided AI-assisted pipeline generation, data-profiling, and anomaly-detection tools may be used to accelerate development and improve data quality. Key Responsibilities • Design, develop, test, and maintain ETL processes that move data from source systems to target data stores, data warehouses, and modern applications • Develop and evolve ETL strategies that support the full data lifecycle — ingestion, transformation, validation, loading, and audit • Collect, clean, and integrate structured and unstructured data from diverse source systems, including legacy relational databases, flat files, APIs, and third-party feeds • Build and maintain data models, data mappings, and transformation rules in coordination with data architects and business analysts • Implement automated workflows with performance tuning, error handling, and audit logging • Implement and monitor data-quality controls — profiling, deduplication, standardization, and reconciliation • Develop and maintain API-based integrations between source and target systems • Troubleshoot production ETL jobs, diagnose failures, and implement remediation • Collaborate with client stakeholders to understand source-system semantics, data ownership, and business rules • Support knowledge transfer to client technical staff through documentation, walkthroughs, and pair-work • Participate in Scrum ceremonies (sprint planning, daily stand-ups, reviews, and retrospectives) Required Qualifications • Bachelor's degree in Computer Science, Information Systems, or related field — or equivalent experience • 2+ years of hands-on experience with advanced SQL, including complex joins, window functions, CTEs, stored procedures, and performance tuning • 4+ years of experience in data migration and integration with automated workflows, performance tuning, data cleansing, API integration, and audit logging • Demonstrated experience designing end-to-end ETL pipelines across heterogeneous source and target systems • Strong problem-solving, troubleshooting, and documentation skills • Excellent written and verbal communication skills and ability to work directly with non-technical stakeholders • Ability to work effectively in a fully remote environment • Must be authorized to work in the United States Preferred Qualifications • Experience leading or contributing to full-scale data migrations from legacy systems to cloud, ERP, or CRM platforms • Hands-on experience with one or more ETL/data-integration platforms — Informatica PowerCenter or IICS, Talend, AWS Glue, Azure Data Factory, or SQL Server Integration Services (SSIS) • Proficiency in at least one scripting or programming language — Python, PowerShell, or Java • Experience working on Agile / Scrum delivery teams • Experience supporting public-sector data modernization initiatives • Familiarity with AI-assisted pipeline generation, schema-mapping, and anomaly-detection tools Tools, Technologies & Frameworks ETL / Integration: Informatica PowerCenter, Informatica IICS, Talend, AWS Glue, Azure Data Factory, SSIS | Databases: SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Redshift | Scripting: Python, PowerShell, Java | APIs: REST, SOAP, JSON, XML | DevOps: Git, CI/CD pipelines, Jira, Confluence | Delivery: Agile / Scrum | AI Assist: pipeline generation, schema mapping, anomaly detection What AKIVA Offers • Professional development and skill-building opportunities • Supportive management team with veteran-owned company values • Opportunity to contribute to impactful public-sector data modernization initiatives • Fully remote engagement with no required onsite travel • AI productivity tools and training provided at no cost to employees Comprehensive Benefits Package • 401(k) with generous company match • Medical Insurance • Dental Insurance • Vision Insurance • Short-Term & Long-Term Disability Insurance • Paid Time Off (PTO) • Profit Sharing Join Our AI Innovation Network Interested in staying connected with AKIVA's AI initiatives, research, and opportunities? Join our AI Innovation Network here: Equal Employment Opportunity Statement AKIVA is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, national origin, age, physical disability, marital status, military and veteran status, or any other characteristic protected by applicable law. We believe that diversity among our teammates is critical to our success as a company, and we seek to recruit, develop, and retain the most talented people within a qualified candidate pool. AKIVA is a certified Service-Disabled Veteran-Owned Small Business (SDVOSB). This is a remote position.