Data Architect

Description

We are looking for a highly skilled and technical Data Architect to lead the design and implementation of our data ecosystem. In this role, you will be responsible for the end-to-end architecture of high-performing, curated datasets using Snowflake and dbt .

You will drive the data strategy by leading the design and optimization of data models to support a wide range of use cases, including operational reporting, business intelligence, and advanced analytics. This includes, but is not limited to, using AI chatbots and Machine Learning models to have conversations with our data. This position plays a crucial role in integrating diverse data sources into our Snowflake platform and developing a unified, self-serve focused analytics platform.

As a key member of the team, you'll work closely with analysts, data scientists, engineers, and business leaders to ensure our data solutions are scalable, secure, and aligned with our evolving business objectives. You'll be responsible for providing consistent, high-quality, and governed access to critical business data.

What you'll do :

• Develop and maintain data architecture roadmap, defining the strategic direction and technical vision to support self-serve enablement across Macmillan data platform.
• Build a data architecture to support self-serve reporting and analysis enablement by also ensuring the clarity and usefulness for all stakeholders.
• Closely work with the Data Analytics and Data Platform teams to support the end-to-end design of scalable, high-performing data solutions in Snowflake using dbt.
• This includes architecting and overseeing development of ELT pipelines and translating business needs into conceptual, logical, and physical data models.
• Define and implement data modeling strategies, focusing on schema and query optimization approaches within Snowflake to support high-performance workloads.
• Accountable to establish and enforce data governance framework and standards to ensure data integrity, compliance, and consistent access.
• Lead the ongoing maintenance and evolution of the self-serve data layer, including managing schema changes and monitoring data quality and performance.
• Serve as a key point of contact and strategic advisor to engineering, analytics, and business teams.
• Collaborate to align architectural decisions with business objectives, define requirements, and provide strategic recommendations.
• Provide architectural guidance and technical leadership across Snowflake, data warehousing, and BI initiatives.
• Lead architectural reviews and influence design decisions to ensure best practices are followed.
• Develop and maintain comprehensive technical documentation, architecture diagrams, data cataloging, and lineage.
• Stay current with industry trends and establish best practices in data architecture and metadata management.

What you'll bring :

This role will have an annual salary of $160,000-$170,000.

Macmillan Publishers is the U.S. trade company that is part of the Holtzbrinck Publishing Group, a large family-owned group of media companies headquartered in Stuttgart, Germany. Holtzbrinck Publishing Group's publishing companies include prominent imprints around the world that publish a broad range of award-winning books for children and adults in all categories and formats.

U.S. publishers include Celadon Books, Farrar, Straus and Giroux, Flatiron Books, Henry Holt & Company, Macmillan Audio, Macmillan Children's Publishing Group, The St. Martin's Publishing Group, and Tor Publishing Group. In the UK, Australia, India, and South Africa, companies in the Holtzbrinck Publishing Group publish under the Pan Macmillan name. The German publishing company, Holtzbrinck Deutsche Buchverlage, includes among its imprints S. Fischer, Kiepenheuer & Witsch, Rowohlt, and Droemer Knaur.

We are an Equal Opportunity Employer. We are actively seeking job applicants who reflect a broad representation of differences, including race, ethnicity, religion, sex, sexual orientation, gender identity / expression, physical ability, neurodiversity, age, family status, economic background and status, geographical background and status, and perspective. We believe that the best companies reflect the incredible diversity in viewpoints, backgrounds, and identities of the world in their staffs, and are committed to inclusive hiring across departments and levels. The successful candidate for this position will be an employee of Macmillan Publishing Group, LLC.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.