Alliant is seeking a Senior ETL Data Analyst 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. This 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.

Principal Responsibilities:

  • Provide leadership in the development of data integration standards to support Data Science and Product teams
  • Perform client data audits to analyze and understand relationships of customers and their behaviors
  • Analyze client CRM data feeds and develop ETL processes to manage Coop data feeds
  • Analyze and 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
  • Mentor team members and maintain accurate and complete documentation

Qualifications & Skills:

  • Bachelor’s Degree or higher required
  • Experience in Data Analyst roles within an analytics environment, predictive modeling for sales, marketing, fraud prevention, or related business needs
  • Experience in the development and implementation of data warehouses and data marts
  • 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

June 2022


Brewster, NY


Company Wide


Permanent, Full-Time

Alliant is a leading data company trusted by thousands of marketers. We deliver highly predictive custom and on-demand audience solutions across TV, programmatic, social, direct mail and more. The Alliant DataHub — built on billions of consumer transactions, advanced data science and high-performance technology — is the foundation for profit-driven audience solutions. For more information, visit: alliantdata.com

This position is an in-person role at Alliant’s office in northern Westchester County, New York. For consideration, please forward your resume and salary requirements to recruiting@alliantdata.com, Subject Line: Senior ETL Data Analyst. Alliant is an equal opportunity employer.

Privacy Notice — Alliant will collect and use any information you submit to us, including information regarding your identity, education, employment history, professional or personal qualifications, and any other submissions, solely to evaluate your suitability for a position. Your information will not be sold or used for any other commercial purpose, however it will be retained by Alliant for the period required by law, and cannot be deleted upon your request before the end of the retention period.