ETL Developer
Remote Direct Hire May 12, 2022

About us

Newbury Partners is a business process and IT services consulting firm that has been implementing staffing industry applications for the Staffing Industry since 2005.

We assist clients with software implementation, optimization, data migration, customizations, analytics, Canvas reporting, training and support. 

Job Description

We are looking for a data driven, analytical, and self-motivated Business Intelligence developer to join our innovative team. As a developer you will be responsible for interacting with clients and teammates to capture technical specifications and translate them into comprehensive ETL design specifications that can be developed into a complete ETL process.

In this role, you should have a background in data and business analysis with a passion for designing and developing BI and analytic solutions that turn data into insights for our clients. If you are an excellent communicator and have a business acumen and problem-solving aptitude, this could be the role for you.

As a ETL Developer, a typical day might include:

  • Working closely with clients, Solution Architects, and project teams to translate customer technical specifications into ETL and Data Warehousing solutions.

  • Developing ETL scripts with one or more of the following tools:

    • IBM Datastage v 12

    • SSIS 

    • SSAS

    • Data Factory

    • Talend

    • Informatica

    • Alteryx

    • Domo

  • Analyzing data sets

  • Set and manage expectations with project team regarding project deliverables

Required Skills

  • Advanced level of writing Structured Query Language (SQL)

  • Creating Facts and Dimensions

  • Creating Type 2 dimensions

  • Familiarity with Change Data Capture (CDC) Methodologies

  • Scripting (Stored Procedures)

  • Organizing Data

  • Debugging/Problem solving skills

  • Ability to document a solution from requirements gathering to completed product


Additional Experience:

  • Experience in the recruitment industry

  • Multilingual