Sr Data Engineer

New York, NY, United States

Sr Data Engineer

Haymarket Media, Inc. is seeking a Sr Data Engineer to join the Data Engineering Team team. This position is located in our New York, NY office.

Job Overview:

We are looking for a Sr Data Engineer to contribute to our Data Warehouse infrastructure, working as part of a small and talented team focused on data integration, structure, report automation, and BI/Analytics Support, etc. As our business continues to grow in size and complexity, we are looking for a dynamic, organized, and customer-focused data centric contributor who is interested in informing and shaping our long-term roadmap. The role should understand business, systems, and data challenges and translate them into requirements and solutions.

Responsibilities:

Build integrated solutions that are in line with the architecture framework that meets business requirements

Provide guidance regarding data modeling best practices, data governance and quality practices.

Ensure data adheres to enterprise governance standards and maintain credibility and reputation of high quality data

Work with IT and business customers to capture requirements for designing the data warehouse, data analytics and business intelligence architecture.

Apply broad knowledge of technology options, technology platforms, design techniques and approaches across the data engineering ecosystem to design systems that meet business needs

Play a leading role in building systems and datasets using software engineering best practices, data management fundamentals, data storage principles, recent advances in distributed systems, and operational excellence best practices

Develop, institutionalize and drive best practices and data architectural awareness

Create the blueprint for data management systems to integrate, centralize and maintain data sources

Analyze source systems, define underlying data sources and transformation requirements, design suitable data models and document the design/specifications

Define and implement integrations between source data and data warehouse as needed to ensure data integrity and support data & reporting requirements

Develop and maintain programs on source systems, ETL applications, data cleansing functions, systems management functions including load automation, and data acquisition functions among others

Ensure a fault tolerant, self-correcting, adaptive, highly accurate ETL platform

Continuously seek opportunities to optimize data flows, improve SQL query performance, and maintain reasonable user experience for field and power users working on data

Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines

Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts

Skills and Requirements: Ability to think broadly, understand business strategy, provide consultative business analysis, and have a broad understanding of technology landscape for developing effective and scalable data warehouse and business intelligence solutions

Strong overall architecture experience with high proficiency in data architecture

5-8+ years of building large scale data-processing systems with 2+ years in big data technologies

Expertise in cloud database technologies such as Google BigQuery with proficiency in SQL

Experience in data transformation tools such as DataForm or DBT

Experience designing and coding in python

Experience in BI tools like Looker

Thorough understanding of dimensional modeling, as well as knowledge of best practices and techniques for transforming, validating, logging, auditing, error handling, and performance tuning in a data warehousing setting

Proven track record of strong verbal/written communication & data presentation skills, including an ability to effectively communicate with both business and technical teams

Has excellent problem-solving skills and experience handling multiple projects and assignment in a fast-paced environment

Can work well in a cross-team collaborative environment, with little oversight, and be able to engage stakeholders with various business and technical backgrounds

Experience with ETL and DW platforms such as Stitchdata a plus

Experience with orchestration tools such as Airflow is a plus

Experience working with Agile methodologies in a data warehouse, BI environment

Bachelor’s degree in math, computer science, engineering, statistics, or a related technical field is required. Master’s degree a plus

What We Offer: A competitive compensation package

The salary range for this position is $170,000–$190,000. Compensation will be commensurate with experience, skill level, functional and/or industry knowledge, education level, certifications, as well as other qualifications.

Paid annual vacation, holiday and sick time off

Comprehensive health plans including medical, dental and vision

Competitive 401(k) investment options and generous company matching program

Life insurance

Commuter benefits

Employee referral awards

Tuition reimbursement

Training opportunities through industry-recognized programs

A creative and passionate workplace and a fun, collaborative team environment

Three Week “Work from Anywhere” benefit, to ensure work life balance

About Haymarket:

Haymarket has its heart and soul in publishing and media. Since the company was founded half a century ago, Haymarket has always prided itself on being a highly creative business, with an unrelenting focus on the quality of the products and the people. The philosophy has always been quite simple: only by having the highest quality individuals can you produce the highest quality products, combining the best in content, design, production and customer services. Globalization is opening up the world further and provides many opportunities for growth. Haymarket has offices around the world and many of the titles are now truly global brands. Haymarket serves a broad spread of business markets, from marketing to medicine to technology along with exhibitions and live events. Predicting the shape of the business in 3, 5, or 10 years is almost impossible; and the unpredictability is part of the appeal. Haymarket aims to be the perfect company to work with or for – we have the processes and attitude that ensure quality and consistency, and an entrepreneurial spirit that makes every day rewarding.

An equal opportunity employer, Haymarket Media does not discriminate in hiring or terms and conditions of employment because of an individual's race, color, religion, gender, gender identity, national origin, citizenship, age, disability, sexual orientation, marital status, or any other protected category recognized by state, federal, or local laws.

Beware of fraudulent activity where individuals are contacting job seekers claiming to represent Haymarket Media. Please note that only emails from @haymarketmedia.com are legitimate.

When applying for roles with Haymarket Media, you will receive an email directly from a member of the Talent Acquisition team or communication through Linkedin.

You can view our open positions on our website US careers section: www.Haymarket.com

California Applicants may view Haymarket Media, Inc.'s Privacy Statement for California Residents here.