Remote - ETL Developer IV (MUSTS: Python and Snowflake)

JOB SUMMARY:

We are currently looking for an 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.

ACCOUNTABILITIES

These accountabilities are not intended as a complete list of specific duties and responsibilities and does not limit or modify the right of any supervisor to assign, direct, and control the work of employees assigned to this job.

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.

*Work with Data team to ensure solution is supportable

QUALIFICATIONS

The requirements listed below are representative of the experience, knowledge, skills and/or abilities required to perform this job. Educational Requirements Education Level Field of Study Required/Preferred 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.

• Involves cycling through multiple sites and hardware components via multiple API calls

• Experience with requests library and optimizing multiple calls to an API

Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.

If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: https://jobs.beaconhillstaffing.com/eeoc/

Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records.

Company Profile:

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.

Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.

Learn more about Beacon Hill Staffing Group and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.beaconhillstaffing.com.

We look forward to working with you.

Beacon Hill. Employing the Future (TM)

Key Skills

• SQL