Python ETL Developer

Python ETL Developer

Remote

Will need their own laptop and monitor but will log into a virtual machine for development work.

We are currently looking for a Python ETL Developer to work with our Data team on a short term project. This project is estimated to be 1-2 months and will involve the development of an integration to pull from a web API endpoint into the company Snowflake platform. As part of this project, the ideal candidate will work with business stakeholders to implement a solution that pulls near real time data from an external API and is landed in a set of Snowflake tables for consumption by a third party application.

Primary Accountabilities

• Develops robust, supportable solutions for extracting, transforming, and moving data from web based API to Snowflake data platform.
• Performs data profiling and data analysis to assist in understanding the data.
• Optimizes data models through normalization, table analysis and review of queries.
• Conducts requirements gathering with business stakeholders and users to plan a roadmap of project activities.
• Works with the business to assess the validity of the data and achieve minimum levels of quality.
• Gathers and compiles data using various data collection techniques in response to data requests.
• Creates code or GUI data mappings while following company data standards and approaches.
• Collaborates with others responsible for pipeline development.
• Works with Data team to ensure solution is supportable.

Qualifications

• Educational Requirements
• Bachelor's Degree Emphasis in CIS, Software Development, analytics, operations research, computer science or other applicable field Required
• Experience
• 4 years of direct experience in a related field (coding, ETL Development/Engineering, analytics, or research)
• Experience in extracting data from web endpoints using Python scripts. Emphasis on candidates that have experience landing data in Snowflake.
• Experience working with Snowflake
• Proficiency in SQL required.
• High Level Project Requirements
• Extract measurement/sensor type data from web API utilizing parameters to run job every 15 minutes.