ETL Consultant (ADF & Snowflake)

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

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract