ETL Developer

ETL Developer

ETL Developer Job Overview

Sagence is actively seeking a hands-on ETL Developer. As an ETL Developer at Sagence,  you will help us build and sustain our client’s data capabilities and our competitive advantage.  Below you will find an overview of the position requirements and the characteristics of our successful ETL Developer professionals.

*Candidates must be currently authorized to work in the US on a full-time basis. Sagence does not provide sponsorship for work visas upon hire or once on board.*

Skills & Experience Required for a Sagence ETL Developer

MUST BE HANDS ON. All candidates should be technologically proficient in performing development work, have the ability to install & configure tools and platforms, the desire to rapidly build up knowledge on new tools, and possess the following skills and knowledge:

  • Deep understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs, and usage of data warehouses and data marts
  • Experience successfully working with business and technical teams to understand, document, design, develop, code, and test ETL processes
  • Demonstrated experience in the following:
    • Writing complex SQL queries
    • ETL / SQL performance tuning
    • Working with one or more ETL tools
    • Working in a cloud environment (e.g. AWS, Azure, GCP)
  • Ability to translate source to target mapping documents into ETL processes
  • Ability to prepare architecture diagrams, technical specifications, and documentation for any new or existing ETL processes
  • Experience designing and implementing ETL processes
  • Ability to quickly learn new tools and technology
  • Ability to mentor and perform knowledge transfer to support team
  • Prior professional experience in an IT management, management consulting, or client facing role is preferred
  • Demonstrated ability in engaging, communicating, and presenting to stakeholders across both business and technology functions

Tools & Technology Required for a Sagence ETL Developer

Sagence ETL Developers are proficient at leveraging tools and technology that drive value for our clients. Illustrative tools include:

  • ETL tools (e.g. Talend, Informatica, Infosphere. Ab Initio)
  • Database management systems (e.g., Postgres, MySQL, SQL Server, Oracle, Teradata)
  • Cloud-native database management systems (e.g., Aurora, Redshift)
  • Data modeling tools (e.g., ERWin, ER/Studio, IBM Data Architect)

General Skills and Requirements Required for a Sagence ETL Developer

*Candidates must be currently authorized to work in the US on a full-time basis. Sagence does not provide sponsorship for work visas upon hire or once on board.*

  • 3+ years of professional experience working in a related role
  • Must be collaborative, innovative, curious, and resourceful, and exhibit a positive attitude
  • Strong desire to work on interesting projects with smart and creative people
  • Willingness to travel to client sites as needed
  • Chicago area candidates preferred

The Sagence Culture

Passionate, diverse, creative, genuine, flexible, hands-on…these are just a few of the words that describe our culture. Our Partners are deeply involved in the client work on a daily basis. We have a high-energy workplace with a focus on producing high-quality, impactful results. We are committed to equality of opportunity, fairness, work and lifestyle balance, and mutual respect. We promote an entrepreneurial spirit by encouraging individual initiative and foster a collaborative culture and work environment, which includes open communication and on-going learning. We build teamwork through small, dedicated teams who continuously teach each other and learn from one another. We believe these characteristics enable our employees to develop to their fullest potential. To learn more, please visit us at www.sagenceconsulting.com.

About Sagence

Sagence is a management advisory firm dedicated to helping our clients optimize the value of their data assets. From thinking to doing, Sagence works with leading institutions in the acquisition, evaluation, development, and management of their critical data assets and in the application of analytics to discover new insights, shorten time-to-value, and drive competitive advantage. Visit our Leadership page to get to know some of our people.

A Week in the Life of a Sagence Consultant

Learn more about working with Sagence by visiting the Week in the Life section of our website.

Visit the Knowledge Section of our Website

Sagence has a wide collection of case studies and blogs on our website. Enjoy!

If you include a resume, completion of the fields below is completely optional.

 

Share Via