Edtech.com's Summary

Macmillan Publishers is hiring a Data Analyst. In this role, the analyst will use Data Build Tool (dbt) to develop data transformations within the Data Warehouse and design data models for business intelligence reporting. The analyst will work with raw data, implement testing frameworks, and collaborate with various teams to address data needs and improve data workflow and quality standards.

Highlights

Main responsibilities include developing and managing data transformations using dbt, designing data models, and diagnosing data issues.
Required skills include proficiency in SQL, experience with dbt, and familiarity with cloud-native Data Warehouse platforms such as Snowflake or BigQuery.
The position offers an hourly rate up to $95/hour.
Essential qualifications include a Bachelor's degree in a relevant field or comparable work experience, with 8+ years experience as a Data Analyst.
Strong communication skills and the ability to work with both technical and non-technical teams are necessary.
Experience with data visualization tools like Power BI or Tableau is expected.

Data Analyst Full Description

Full-Time

120 Broadway

New York, NY 10271, USA

Description

We are looking for an experienced Data Analyst with expertise in Data Build Tool (dbt) to join our team. In this role, you will be responsible for transforming raw data into data models and documentation conducive to self-serve reporting (and chatbots). The ideal candidate will have a strong understanding of data modeling, Data Warehouse architectures, SQL, and a proven track record of leveraging dbt to streamline the data transformation process.

What you'll do:

Use dbt to develop, manage, and optimize data transformations in the Data Warehouse. Design data models that support business intelligence (BI) canned and self-serve reporting needs.
Work with raw data from multiple sources, clean and structure it using transformations with dbt models, and make the transformed data accessible in the Self-Serve layer.
Analyze datasets to diagnose data issues, integrate new data, uncover trends, patterns, and actionable insights. Collaborate with business stakeholders to identify data needs and deliver valuable self-serve data models and supporting documentation (e.g., Data Glossary).
Implement testing frameworks in dbt to ensure data accuracy and integrity across all transformations. Use dbt's built-in testing and documentation features to maintain high data quality standards.
Work closely with data analysts, business analysts, business intelligence developers, and data scientists to create clear and actionable visualizations using tools such as Tableau or Power BI.
Partner with cross-functional teams (such as data engineering, software engineering, AI Engineering, product, marketing, and DevOps) to understand the business' data requirements and deliver efficient and effective solutions with high data quality.
Maintain clear and up-to-date documentation of dbt models, data flows, transformation logic, and a Data Glossary that maps back to source systems (where applicable). Advocate for best practices in data modeling and transformation processes.
Stay current with new features in dbt, and continuously look for ways to improve the data pipeline and transformation processes for better performance and scalability.

What you'll bring:

Proficiency in SQL for analyses, troubleshooting, and data transformation.
Hands-on experience with dbt for building and managing data models, transformations, and tests.
Familiarity with cloud-native Data Warehouse platforms such as Snowflake, Databricks, BigQuery, or Redshift.
Solid understanding of data modeling techniques, data normalization, and structuring data in a way that facilitates analysis.
Ability to design and implement dbt models that support efficient and reliable data workflows.
Experience with data reporting or data visualization tools like Power BI, Tableau, or Cognos to analyze reports and dashboards for stakeholders.
Strong analytical skills with the ability to extract insights from complex datasets and present them to non-technical stakeholders.
Excellent communication skills, with the ability to work cross-functionally with technical and non-technical teams.
Ability to document processes and create clear explanations of complex data workflows.

Ideal education/experience:

Bachelor's degree in Computer Science, Statistics, Economics, Data Science, or a related field or comparable work experience.
8+ years of experience as a Data Analyst with 3+ years of experience working with dbt and data transformation processes.
Experience with Data Warehouses such as Snowflake, BigQuery, or Oracle.

This position will have an hourly rate up to $95/ hour. The successful candidate will be employed through Headway Workforce Solutions.

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.

Original Job Description

Full-Time

120 Broadway

New York, NY 10271, USA

Description

What you'll do:

Use dbt to develop, manage, and optimize data transformations in the Data Warehouse. Design data models that support business intelligence (BI) canned and self-serve reporting needs.
Work with raw data from multiple sources, clean and structure it using transformations with dbt models, and make the transformed data accessible in the Self-Serve layer.
Analyze datasets to diagnose data issues, integrate new data, uncover trends, patterns, and actionable insights. Collaborate with business stakeholders to identify data needs and deliver valuable self-serve data models and supporting documentation (e.g., Data Glossary).
Implement testing frameworks in dbt to ensure data accuracy and integrity across all transformations. Use dbt's built-in testing and documentation features to maintain high data quality standards.
Work closely with data analysts, business analysts, business intelligence developers, and data scientists to create clear and actionable visualizations using tools such as Tableau or Power BI.
Partner with cross-functional teams (such as data engineering, software engineering, AI Engineering, product, marketing, and DevOps) to understand the business' data requirements and deliver efficient and effective solutions with high data quality.
Maintain clear and up-to-date documentation of dbt models, data flows, transformation logic, and a Data Glossary that maps back to source systems (where applicable). Advocate for best practices in data modeling and transformation processes.
Stay current with new features in dbt, and continuously look for ways to improve the data pipeline and transformation processes for better performance and scalability.

What you'll bring:

Proficiency in SQL for analyses, troubleshooting, and data transformation.
Hands-on experience with dbt for building and managing data models, transformations, and tests.
Familiarity with cloud-native Data Warehouse platforms such as Snowflake, Databricks, BigQuery, or Redshift.
Solid understanding of data modeling techniques, data normalization, and structuring data in a way that facilitates analysis.
Ability to design and implement dbt models that support efficient and reliable data workflows.
Experience with data reporting or data visualization tools like Power BI, Tableau, or Cognos to analyze reports and dashboards for stakeholders.
Strong analytical skills with the ability to extract insights from complex datasets and present them to non-technical stakeholders.
Excellent communication skills, with the ability to work cross-functionally with technical and non-technical teams.
Ability to document processes and create clear explanations of complex data workflows.

Ideal education/experience:

Bachelor's degree in Computer Science, Statistics, Economics, Data Science, or a related field or comparable work experience.
8+ years of experience as a Data Analyst with 3+ years of experience working with dbt and data transformation processes.
Experience with Data Warehouses such as Snowflake, BigQuery, or Oracle.

This position will have an hourly rate up to $95/ hour. The successful candidate will be employed through Headway Workforce Solutions.

Let me find your next job.

Thanks - you're signed up.

Data Analyst

Edtech.com's Summary

Data Analyst Full Description

Senior User Experience Researcher

Lead Academic Program Manager - IT Management

IT Governance and Compliance Analyst

Senior Business Analyst

Sr Manager- Growth and Insights