Python ETL Developer

Python ETL Developer RemoteWill 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 AccountabilitiesDevelops 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.QualificationsEducational RequirementsBachelor's Degree Emphasis in CIS, Software Development, analytics, operations research, computer science or other applicable field RequiredExperience4 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 SnowflakeProficiency in SQL required.High Level Project RequirementsExtract measurement/sensor type data from web API utilizing parameters to run job every 15 minutes.