Devonshire Recruiting & Consulting Partners is currently seeking a Data Integration Engineer to work in an internal analytics technology group focused on developing a suite of advanced analytics products and supporting business strategy consulting teams to meet the evolving needs. Must have strong problem solving skills and a passion for working with large data sets.

Responsibilities

• Build Extract, Transform, Load (ETL) pipelines for
• Manage sensitive data
• Build and maintain master databases / data warehouses for consulting teams by pulling together disparate data sources
• Identify and report potential data quality issues
• Determine ways to optimize process and data quality

Qualifications:

• Ability to excel as an individual contributor as well as communicate effectively with internal project teams
• 2+years’ experience working with Python
• Experience running ETLs on a data warehouse– AWS Redshift, Presto, Hive, Big Query, Teradata
• Experience working with and running ETLS on traditional relational databases – MySQL, PostgreSQL, MSSQL, Oracle SQL
• Experience using a workflow management tool such as Airflow, Luigi, Oozie, or Azkaban
• Experience publishing data that will be viewable though BI solution such as Tableau, Qlik, Looker, or Power BI
• 2+ years’ experience cleaning and transforming large data sets, as well as working with remote compute resources
• Bachelor’s Degree (Computer Science, MIS or related IT/Engineering field preferred) or equivalent work experience