Database Engineer

Remote / Hybrid in NYC, Fairfield, NJ or Dallas, TX

Summary:

Our award-winning client is seeking a Database Engineer to join their team. 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. The candidate will work with data to populate our Client's audience platform, allowing our Client's 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.

Required Qualifications:

• 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.

• 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.