ETL Consultant (ADF & Snowflake)

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.