Questions? Feedback? powered by Olark live chat softwareETL Developer | Alliant

ETL Developer

Posted

January 9, 2017

Location

Brewster, NY

Team

Technology

Term

Permanent, Full-Time

Overview:

Alliant is seeking an 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 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:

  • 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, interfaces and QA reports as need 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.
  • Respond to the expressed needs of internal and external customers and end-users 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
  • Provide strategic guidance and technical oversight as required for client engagement team members
  • Work with business stakeholders to define an enterprise-wide data aggregation approach that encompasses multiple systems and various data integration points

Qualifications and Skills:

  • Experience in Data Analyst roles within an analytics environment, predictive modeling for sales, marketing, fraud prevention, or related business needs
  • Experience using ETL tools to manipulate and integrate incoming data from a number of sources
  • Working knowledge and experience in writing simple to moderately complex SQL queries.
  • Ability to retrieve and manipulate data from large databases and create reporting metrics
  • Demonstrated ability to identify data quality issues and recommend the best course of action to address them
  • 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
  • Must be able to devise appropriate business logic to drive continuous campaigns based on daily transactional data
  • Special consideration will be given to candidates with experience in: Hadoop, address standardization tools, analytical tools and their usage
  • Experience in data preparation for direct or digital marketing, or related coursework, a plus
  • 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 more than 485 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 an omnichannel marketing environment Alliant takes clients to the places where consumer response lives. For more information, visit: alliantinsight.com

Alliant has strong corporate culture of innovation and trust and is committed to excellence in everything we do.

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: ETL Developer. Alliant is an equal opportunity employer.

 

Posted

January 9, 2017

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