TITLE: DATABASE ENGINEER

LOCATION: HYBRID-REMOTE EASTERN TIME HOURS (OFFICE LOCATIONS: NYC, FAIRFIELD, NJ, DALLAS, TX)

COMP: 125K - 145K

DESCRIPTION

The Data Engineer is part of the Platform and Data team and is responsible for enhancing and maintaining the infrastructure to answer questions with data, using software engineering best practices, data management fundamentals, and data storage principles. You will work with data to populate our audience platform, allowing our client facing organizations to better serve their clients.

RESPONSIBILITIES:

• Receiving, validating, and loading data to be used within our audience and other platforms
• Evaluating new data sources for structure and continuity of application
• Ensuring data computations are as efficient as possible
• Data analysis on large and small scales to meet company and client needs
• The ideal person 
• 1+ years of experience as a Data Engineer or in a similar role
• Experience with data warehousing, and building ETL pipelines
• Experience in SQL
• Bachelor's degree in an engineering or technical field such as Computer Science, Physics, Mathematics, Statistics, Engineering or similar
• 1+ years of experience with data warehouse technical architectures, ETL/ ELT, reporting/analytic tools and, scripting
• 2-3 years hands-on experience in ANSI SQL with working knowledge of Redshift, HiveSQL, Spark SQL, or Scala
• Familiar with data warehouse schema architectures

QUALIFICATIONS:

• Hands on experience with AWS Redshift Database
• Exposure to AWS ecosystem with products such as EMR, Athena, Glue etc.
• Experience in scripting languages such as Python/Pyspark for parsing and data analysis.
• Experience with AWS API Gateway
• Experience building APIs and automation with Python
• Proven ability to solve complex quantitative business challenges
• Sound business judgment, strong attention to detail, excellent organization skills, and ability to manage multiple projects and responsibilities are critical to success in this position
• Proven track record of identifying metric variances and delivering solutions to address the changes
• Reporting
• The position reports to the Platform and Data team within the Product organization