Haymarket Media Inc | Senior Data Engineer | new york ...

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 @ 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: California Applicants may view Haymarket Media, Inc.'s Privacy Statement for California Residents here.

Created: 2024-12-03