Questions? Feedback? powered by Olark live chat software Senior ETL Developer | Alliant

Senior ETL Developer

Posted

August 17, 2018

Location

Brewster, NY

Team

Technology

Term

Permanent, Full-Time

Overview

Alliant is seeking a Senior ETL Developer to join its Data Intake team. Alliant operates on the forward edge of innovation in data-driven marketing, helping brands target consumers effectively in digital and traditional advertising channels. The Senior ETL Developer position will be responsible for designing, building, validating and maintaining databases and integrating these databases into Hadoop. The ideal candidate for this position will be detailed-oriented, familiar with data profiling, data hygiene and ETL processes and enjoy working with a highly energized and innovative team.

Principle Responsibilities:

  • Provide leadership in the development of data integration standards and work with the Data Integration Manager to implement and enforce them
  • Design and implement well-structured computer programs following best practices that will scale and be easy to maintain based upon defined requirements and specifications
  • Develop transformation logic, source-data-to-target mappings, interfaces and QA reports as needed to meet project requirements
  • Provide guidance for technical architecture, data modeling and ETL standards
  • Communicate effectively with both technical, marketing and sales professionals using appropriately focused reporting to illustrate data discussion points
  • Communicate with internal and external customers to identify critical business needs and response with innovative and effective solutions
  • Work with team members to prioritize tasks and ensure that assigned projects are completed on schedule; organize, coordinate and implement tasks with strong attention to detail
  • Work with business stakeholders to define an enterprise-wide data aggregation approach that encompasses multiple systems and various data integration points

Key Skills and Background:

  • Bachelor’s Degree or higher required
  • 5+ years’ experience in Data Analyst roles within an analytics environment, predictive modeling for sales, marketing, fraud prevention, or related business needs
  • 5+ years’ experience in the development and implementation of data warehouses and data marts
  • 5+ years’ experience using modern graphical ETL tools to manipulate and integrate incoming data from a number of sources
  • Working knowledge and experience in writing complex SQL queries
  • Ability to retrieve and manipulate data from massive databases to create data and information products
  • Demonstrated ability to identify data quality issues and recommend the best course of action to address them
  • Experience with NOSQL a plus
  • Must be a critical thinker and problem-solver capable of strict attention to detail; must have superior organization and documentation skills and the ability to work well under pressure while exhibiting a methodical approach to problem solving
  • Special consideration will be given to candidates with experience in: Hadoop, address standardization tools, analytical tools and their usage
  • Experience using at least one low-level programming language is a plus
  • Experience in data preparation for direct or digital marketing is highly desirable
  • Good interpersonal communication skills with the ability to interface effectively with stakeholders and business partners
  • Demonstrated proficiency in Microsoft Office (Excel, Word, PowerPoint)
  • Motivated self-starter, able to work independently or as part of a team

About Alliant

Relevant consumer insight drives marketing success. Alliant captures transaction-driven response information from over 500 brand offers to fuel purchase and behavior profiles on over 270 million consumers. Alliant’s data-driven solutions improve marketing profitability by targeting the most profitable prospects, increasing conversion and loyalty rates, and improving the efficiency of retention and reactivation efforts. The right data matters. In a multichannel marketing environment, Alliant takes clients to the places where consumer response lives. For more information, visit: alliantinsight.com

Alliant has a strong corporate culture of innovation and transparency and is committed to excellence in everything we do. We offer a competitive compensation and benefits package with great career optionality for professional growth.

The position is based in Alliant’s offices in northern Westchester County, New York. For consideration, please forward your resume and salary requirements to techjobs@alliantinsight.com, Subject Line: Senior ETL Developer. Alliant is an equal opportunity employer.

Posted

August 17, 2018

Location

Brewster, NY

Team

Technology

Term

Permanent, Full-Time

The first step to extraordinary service is extraordinary people. We have the industry's best and the brightest, and the entire leadership team works every day to keep it that way.

JoAnne Monfradi Dunn

President & CEO — Alliant

Not the right position for you?

We have many other career opportunities available. Take a look at our complete list of open positions.

View Openings