Data Analyst

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 :

Ideal education / experience :

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

Salary : $95