Sr Data Engineer
Full Time
New York, NY, US
Haymarket Media, Inc. is seeking a Sr Data Engineer to join the Data Engineering Team. This position is located in our New York, NY office, with three days on-site (Tuesdays, Wednesdays, and a team flex day) and two days remote.
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–$185,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.