Fast Facts

Join Macmillan Publishers as an Associate Director of Data Analytics where you will lead the data analytics department in creating self-serve reporting capabilities and manage the data architecture for effective business intelligence.

Responsibilities: You will oversee data architecture and governance, manage Data Products, drive team development, and ensure data quality while fostering a data-driven culture within the organization.

Skills: The role requires expertise in dbt, SQL, Python, and Snowflake, as well as strong leadership skills and the ability to mentor a high-performing analytics team.

Qualifications: Candidates should have a Bachelor’s degree in a related field, 10+ years of experience in data architecture leadership roles, and a strong understanding of data governance and data modeling concepts. A Master's degree is preferred.

Location: The job is located in New York, New York, United States, with no additional travel required.

Compensation: $168000 - $195000 / Annually

Lead the Data Analytics department as the Associate Director, overseeing the critical function of translating raw data into structured, self-serve reporting capabilities here at Macmillan Publishers! Your leadership will focus on the strategic implementation and management of our analytics

framework within the Snowflake data warehouse, leveraging dbt as the core engine for data transformation and modeling. You will be directly responsible for shaping and governing our Data Architecture, strategically evolving it into well-defined, subject-area-focused Data Products.

Your role involves establishing processes to manage these Data Products effectively – ensuring their quality, consistency, and usability as independent yet related assets designed explicitly for self-serve reporting. This includes enforcing clear naming standards and maintaining a robust Data Glossary to facilitate user understanding and self-sufficiency. Data integrity and quality are paramount; you will guide the team in employing dbt testing, SQL, and Python for rigorous data validation, proactive issue resolution, and the creation of dependable database models and views that underpin these Data Products.

This role blends strategic oversight with hands-on technical understanding, requiring you to establish processes for sustainable and scalable data infrastructure development, treating data as a product. You will also manage all team hiring and development activities. Our ideal candidate combines strategic vision for data architecture (including experience organizing data into product-oriented domains) and governance, with strong technical proficiency in dbt, SQL, Python, and Snowflake, aiming to maximize data accessibility and reliability for business intelligence through well-managed data products.

What you'll do:

• Leadership:
• Build, lead, and mentor a high-performing data architecture and analytics team focused on delivering structured, self-serve reporting capabilities.
• Foster a culture of collaboration, innovation, and continuous improvement.
• Provide training and development opportunities to enhance data literacy across the organization.
• Drive all recruiting and hiring processes for the department.
• Oversee professional development initiatives, ensuring team members enhance their expertise in dbt, Snowflake, data modeling for self-serve consumption, Python, SQL, and data architecture best practices for all of our Data Products.
• Data Architecture, Management & Governance:
• Develop, implement, and govern a scalable and efficient data architecture within Snowflake, strategically evolving it towards distinct, well-defined, subject-area-focused Data Products designed for self-serve reporting.
• Establish and manage processes for the lifecycle of these Data Products, ensuring their quality, reliability, discoverability, and fitness for self-serve reporting needs.
• Collaborate closely with the Data Engineering team to define requirements for raw data ingestion, ensuring data landed in Snowflake is timely, reliable, and structured appropriately for effective downstream transformation.
• Establish best practices for data modeling, data warehousing, and data governance with a focus on creating and managing Data Products.
• Manage data cataloging and lineage, ensuring up-to-date documentation and data models.
• Develop and implement a robust process for enforcing Data Glossary Management with clear naming standards to facilitate user understanding and self-sufficiency.
• Establish and enforce data quality standards and processes to ensure accuracy, completeness, and consistency.
• Ensure data compliance and integrity, adhering to security policies and legal requirements.
• Identify opportunities to integrate automated checks and tests within dbt to enhance data quality and consistency of the database models and views.
• Enhance team knowledge across all aspects of the new architecture, including documentation best practices, dbt modeling techniques, style guides, and automated QA test cases.
• Data Analysis and Reporting:
• Spearhead the transformation of raw data into well-structured Snowflake tables and views that serve as the foundation for self-serve reporting.
• Conduct in-depth data analysis to drive decision-making and strategic planning across all parts of Macmillan.
• Support the adoption of data visualization tools and self-service analytics platforms across the organization, empowering users to interact with Data Products independently
• Define and standardize data transformation and curation processes using dbt (data build tool) to optimize data quality and usability.
• Develop and optimize data marts to provide domain-specific data views, supporting reporting and analysis across business functions in a self-serve manner.
• Strategic Collaboration and Communication:
• Partner with IT and business leaders to align data architecture and analytics initiatives with organizational goals and prioritize high-impact initiatives.
• Support all data needs end-to-end, collaborating with other departments as needed.
• Establish workflow best practices for handling data requests efficiently and transparently.
• Advocate for data-driven decision-making and promote a data-centric culture within the organization.
• Oversee both day-to-day execution and long-term data strategy, ensuring alignment with overall business objectives.

What you'll bring:

• Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
• Master’s degree in Data Analytics or related fields is preferred.
• 10+ years of experience in data architecture, data management, or analytics leadership roles.
• Hands-on experience and expertise in DBT.
• Proven track record of designing and implementing enterprise-level data architecture solutions.
• Strong understanding of data governance frameworks, data modeling, and data warehousing concepts.
• Experience with any of the data governance tools would be desired.
• Proficiency in data analytics tools and platforms (e.g., SQL, Python, Power BI).
• Experience with Snowflake or similar cloud-based data platforms.
• Excellent communication, problem-solving, and analytical skills.
• Ability to translate business requirements into technical solutions.
• Knowledge of data compliance and security policies.

Key Competencies:

• Strategic thinking with a strong understanding of business and technology alignment.
• Ability to drive innovation and adapt to evolving technologies.
• An interest and ability to dive into the details of problems to resolve communication, ownership, data modeling, and other challenges.
• A strong bias for action
• Champion a data-driven culture by promoting best practices in data literacy, analytics, and business intelligence.

This role will have an annual salary of $168,000 - $195,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.