ETL Developer (Azure Data Factory/MS Fabric) - Remote Opportunity

AFL Telecommunications, LLC; Northern (KY); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

401K match

Professional development

Insurance benefits

Flexible time off

Tuition reimbursement

Career advancement

Job summary

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

Strong SQL skills and data warehousing knowledge are essential. The position offers remote work from anywhere in the United States and opportunities to advance within a leading telecom equipment company.

Qualifications

• 3+ years of experience developing ETL/ELT solutions.
• Strong SQL skills and relational database experience.
• Experience with data warehouse concepts and dimensional modeling.
• Experience with ETL tools such as Azure Data Factory and Fabric.
• Analytical and problem-solving skills.
• Experience 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 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 in ETL workflows.
• Support production deployments and post-deployment validation.

Skills

SQL

ETL/ELT

Data warehousing concepts

APIs & data formats (XML/JSON)

Problem solving

Education

3+ years ETL/ELT development experience

Tools

Azure Data Factory

Fabric

Job description

Job Category: IT - Business Analysts

Requisition Number: ETLDE009306

Locations

Showing 1 location

Duncan, SC 29334, USA

Description

AFL manufactures industry-leading fiber optic cable, connectivity and accessories and provides engineering and installation services for some of the largest telecom customers in the world. Our company was founded in 1984 with a single fiber optic cable and today, we manufacture thousands of products, generate an excess of $4B in revenue, and employ approximately 12,000 associates worldwide. At AFL, we recognize that our employees are our greatest asset. We hire and train each individual, investing in them to ensure success in their careers. With a commitment to professional development and growth, let us connect you to your next career opportunity.

What We Offer:

• Flexible time off policy
• 401K Company match (up to 4% - dollar for dollar)
• Professional development, training, and tuition reimbursement programs
• Excellent medical, dental, vision, and life insurance policy options
• Opportunities for career advancement with an industry leading company!

We are seeking an experienced ETL Developer to design, develop, maintain, and optimize enterprise data integration solutions. The ideal candidate will be responsible for extracting data from multiple source systems, transforming data according to business requirements, and loading it into data warehouse. This role requires strong SQL skills, expertise in data warehousing concepts, and experience with modern data integration and orchestration tools. The position will be able to work remotely from anywhere in the United States.

Key Responsibilities:

Data Integration & Development

• 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.

Data Warehouse & Data Management

• Support enterprise 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.

Orchestration & Automation

• 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.

Required 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.

Preferred Qualifications:

• Knowledge of data lake and lakehouse architectures.
• Experience with workflow scheduling tools such as Redwood RunMyJobs or equivalent.
• Experience with Service Now.
• Familiarity with Power BI and enterprise reporting platforms.
• Familiarity with Linux.
• Experience with Change Data Capture (CDC) and real-time data integration.
• Understanding of DevOps, CI/CD, and source control tools.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.