Remote ETL Developer — Azure Data Factory & Fabric

AFL; Duncan (SC); Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Flexible time off policy

401K Company match (up to 4%)

Professional development and tuition

Excellent medical, dental, vision, and

Opportunities for career advancement

Job summary

AFL is seeking an experienced ETL Developer to design, develop, maintain, and optimize enterprise data integration solutions. The role focuses on extracting data from multiple sources, transforming it per business rules, and loading into the data warehouse.

Remote work is available from anywhere in the United States. The ideal candidate has strong SQL skills, data warehousing knowledge, and experience with modern data integration tools.

Qualifications

• 3+ years of experience developing ETL/ELT solutions.
• Strong experience with SQL and relational database platforms.
• Experience with data warehouse concepts, dimensional modeling, and data integration.
• Experience with ETL tools such as Azure Data Factory & Fabric.
• Strong analytical and problem-solving skills.
• Experience working with APIs, flat files, XML, JSON, and other data formats.

Responsibilities

• Design, develop, and maintain ETL/ELT processes to support enterprise reporting and analytics.
• Develop source-to-stage and stage-to-data warehouse data pipelines.
• Create and maintain data transformation logic, mappings, and business rules.
• Develop and optimize database views, stored procedures, and SQL scripts.
• Integrate data from databases, APIs, file systems, and third-party applications.
• Implement error handling, logging, monitoring, and recovery processes within ETL workflows.
• Support data warehouse architecture and data modeling initiatives.
• Ensure data quality, consistency, and integrity throughout the data lifecycle.
• Perform data validation, reconciliation, and root cause analysis.
• Collaborate with business analysts and stakeholders to translate requirements into technical solutions.
• Document data flows, mappings, technical specifications, and operational procedures.
• Develop and maintain workflow scheduling and orchestration processes.
• Configure job dependencies, alerts, notifications, and automated recovery procedures.
• Monitor ETL jobs and proactively identify performance bottlenecks.
• Support production deployments and post-deployment validation activities.
• Troubleshoot ETL failures and data quality issues.
• Participate in code reviews and adherence to development standards.
• Recommend improvements to data integration processes and system performance.
• Support production incidents and perform impact analysis as needed.

Skills

SQL

Data Warehousing concepts

ETL/ELT development

Azure Data Factory

Fabric

APIs, XML, JSON data formats

Analytical thinking

Problem solving

Tools

Azure Data Factory

Fabric

Job description

AFL is seeking an experienced ETL Developer to design, develop, maintain, and optimize enterprise data integration solutions. The role focuses on extracting data from multiple sources, transforming it per business rules, and loading into the data warehouse.

Remote work is available from anywhere in the United States. The ideal candidate has strong SQL skills, data warehousing knowledge, and experience with modern data integration tools.