Senior Data Engineer

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

HOW YOU'LL BE CONTRIBUTING :

• 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

WHAT YOU'LL BRING TO THE TABLE :

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

Familiar with various design and architectural patterns

Knack for writing clean, readable, and easily maintainable code

Experience implementing automated testing platforms and unit tests

OUR VALUES :

Trust

Simplicity

Bravery

Inclusivity or Belonging

Growth

Balance

WHAT WE HAVE TO OFFER :

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

Salary Range Disclaimer

The base salary range below represents the low and high end of the Ampersand salary range for this position in New York. Please note that the salary range provided is a good faith estimate on the applicable range. Actual salaries will vary depending on factors including, but not limited to, experience and performance

The range listed is just one component of Ampersand's total rewards package for employees. Other rewards may include discretionary annual bonuses and / or overtime, commission, etc., as well as competitive benefits including PTO, medical & dental & vision benefits, 401K with employer match, short & long-term disability, basic life insurance, tuition reimbursement, pre-tax commuter benefits & flexible spending accounts.

Salary Range Transparency

This role has a base salary of $140,000 - $180,000 and a discretionary annual bonus.

Ampersand welcomes all qualified applicants to apply without regard to race, color, nationality, gender, gender identity or expression, sexual orientation, religion, disability, or age. We are an equal opportunity employer committed to belonging, equity and diversity. If you need reasonable accommodation to assist during the interview process, please contact a member of the Ampersand Recruiting team. In your message, please include a description of the specific accommodation you are requesting and the requisition number of the position for which you are applying.

PHISHING SCAM WARNING : Ampersand is aware of a phishing scam involving con artists posing as hiring managers recruiting via email, text and social media. The imposters are creating misleading email accounts, conducting remote "interviews," and making fake job offers in order to collect personal and financial information from unsuspecting individuals. Please note that Ampersand only uses company email addresses, which contain "@ampersand.tv," to communicate with candidates via email. The company also uses secure tools on our website to receive data from applicants and would never ask them to submit their personal banking information to apply for an open job. If you are contacted by someone about an open job at Ampersand, please verify the domain of the sender's email address and that they are asking you to apply on this website. If you believe you've been a victim of a phishing scam, please visit the Department of Homeland Security's Cyber Smart website to learn how to report it. Learn more about our Careers Privacy Policy.

Ampersand welcomes all qualified applicants to apply without regard to race, color, nationality, gender, gender identity or expression, sexual orientation, religion, disability or age. We are an equal opportunity employer committed to belonging, equity and diversity.