Data Engineer

Ampersand • New York, NY

18d • $110,000 - $150,000

About The Position

Ampersand is Moving TV Forward ®. As the industry’s largest source of combined multiscreen TV inventory and viewership insights, we are changing the way TV is bought and measured. Powered by industry leading aggregated data insights, and with a commitment to protecting personal information, Ampersand gives advertisers true audience first planning, scale in execution, and advanced measurement of their TV investments. Ampersand represents 118M multiscreen households and over 75% of addressable households in the U.S. (63M households). Whether a local or national advertiser, we help clients reach their unique target audience and deliver their stories – anytime, anywhere and on whatever device. Ampersand is owned by Comcast Corporation, Charter Communications, Inc. and Cox Communications. For more information, please visit Ampersand at www.ampersand.tv
WHAT YOU’LL BE DOING:
The Senior Data Engineer will be responsible for Ampersand data analytics and data pipeline applications using Spark, Athena, EKS, ClickHouse, Scala and Python. The Senior Data Engineer with Ampersand will be responsible for building the company’s big data pipeline, data reporting, and wrangling data to optimize data systems.

Requirements

• Experience building and optimizing 'big data' data pipelines, architectures, data sets and tools (Hadoop, Spark, Presto, etc.)
• Experience using columnar data-stores (Parquet, Athena, Presto, Snowflake)
• Strong knowledge and experience working with AWS eco-system and AWS technologies (S3, Athena, EMR, EKS, EC2, IAM, etc.)
• Advanced SQL knowledge and experience working with relational databases
• Skill for writing reusable code

Responsibilities

• Design and build our data pipeline using Amazon Web Services technologies (AWS EMR, EKS, Data Pipeline, Athena, ClickHouse, Spark, Scala, and Python)
• Assemble, combine and transform large multiple complex data sets
• Build analytics tools using the data pipeline to provide actionable insights to end users
• Design, build, and maintain efficient, reusable, and reliable code
• Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues
• Help maintain code quality, organization, and automatization

Benefits

• Competitive salary
• Open company culture where you have the headroom to grow and legroom to run
• Opportunity to join a company revolutionizing the Advertising Technology industry
• Trustworthy, hardworking colleagues
• Opportunities to learn and grow
• Management, Sales, Executive Presence, Operations trainings; just to name a few!
• Comprehensive Medical, Dental, and Vision coverage
• Generous Time Off
• Work/Life balance
• 401k and Company matching
• Commuting benefits
• Other perks

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 501-1,000 employees