ETL Developer

Alongside a team, the ETL/ELT Developer will be responsible for the development of integrations employing industry standard tools for data extraction, transformation and loading (ETL) to / from core critical enterprise systems. The ETL developer should specialize in designing, building, and maintaining data pipelines that move data to / from various sources and to / from cloud-based data warehouses or data lakes. They will focus on ensuring data is extracted, transformed, and loaded efficiently and reliably for analytics and other downstream systems uses.
 

The ETL/ELT Developer Responsibilities:

• Data Transformation: Develop and optimize data transformations using cloud-based tools and technologies to cleanse, enrich, aggregate, and reshape data according to business requirements.
  • Load transformed data into cloud data warehouses (like Snowflake, Azure Synapse, or BigQuery) or data lakes for storage and further analysis.
• Performance Optimization: Ensue efficient data processing and pipeline performance within on-premises and cloud environments by leveraging cloud-native services and optimizing resource utilization.
  • Utilizing cloud-specific tools and services (e.g., FiveTran, Snowpipe, Streams and Tasks, Azure Data Factory) for ETL processes.
• Orchestration and Automation: Automate ETL workflows using orchestration tools or cloud-based workflow services.
• Data Integration: Design and implement ETL pipelines that extract data from diverse cloud and on-premises sources (databases, APIs, files, etc.).
• Collaborate with data analysts, systems analysts, developers and other stakeholders to understand data requirements and ensure the successful delivery of data for analytics and other business needs.
• Create and/or update knowledge base articles regarding procedures, workflows, user guides, process run books, etc.
• Participate within the change management process.

Job Requirements

• BS in Information Systems, Information Technology, or a related field is required. Work experience in lieu of degree or concentration is acceptable.
• Minimum of 5 – 7 years of similar work experience as a ETL Developer in a comparable environment and industry.
• Snowflake - Intermediate level knowledge required.
• Proficiency in Python and/or R is a plus
• Excellent analytical and troubleshooting skills.
• Excellent organizational, teamwork and time management skills.
• Excellent oral and written communication skills.
• Ability to handle multiple parallel tasks