Edtech.com's Summary

Macmillan Publishers is hiring an Associate Director, Data Analytics. This role involves leading the Data Analytics department, translating raw data into structured reporting capabilities, and overseeing the strategic implementation of analytics frameworks. The Associate Director will manage and evolve data architecture within Snowflake, using dbt for data transformation and will be responsible for data product lifecycle, data validation, and ensuring the quality and usability of data.

Highlights

Lead the Data Analytics department and manage data architecture.
Use Snowflake as the data warehouse and dbt for data transformation and modeling.
Oversee the creation of well-defined, subject-area-focused Data Products.
Ensure data quality and consistency using dbt testing, SQL, and Python.
Engage in hands-on technical oversight for data infrastructure development.
Provide training to enhance data literacy and oversee team hiring and development.
Require proficiency in dbt, SQL, Python, and Snowflake.
Offer an annual salary ranging from $168,000 to $195,000.
Require 10+ years of experience in data architecture, management, or analytics leadership.

Associate Director, Data Analytics Full Description

Associate Director, Data Analytics

Job Category: Technology

Requisition Number: ASSOC003060

Full-Time

120 Broadway

New York, NY 10271, USA

Description

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.

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.

Original Job Description

Associate Director, Data Analytics

Job Category: Technology

Requisition Number: ASSOC003060

Full-Time

120 Broadway

New York, NY 10271, USA

Description

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.

Let me find your next job.

Thanks - you're signed up.

Associate Director, Data Analytics

Edtech.com's Summary

Associate Director, Data Analytics Full Description

Associate Director, Data Analytics

Temporary Data Scientist

Application Developer 2 - Data Engineer

Sr. Data Analyst (Product)

Data Scientist II - Research Analytics and Intelligence (rAI)

Product Analyst