Talent.com
No longer accepting applications
Data Architect

Data Architect

Macmillan LearningNew York, NY, United States
30+ days ago
Job type
  • Full-time
Job description

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 :

  • Bachelor's degree in computer science, engineering, or a related field is preferred.
  • 10+ years of experience in data environment including data architecture, systems design, and data platform development;
  • 6+ years of experience in data architecture roles
  • Strong technical proficiency in Snowflake, SQL, and other relevant data tools and technologies.
  • Proficiency in relational and dimensional modeling techniques.
  • Demonstrated experience successfully implementing data architectures in Snowflake, supporting self-serve enablement.
  • Expert-level proficiency in SQL query optimization, data modeling, and performance tuning at scale.
  • Experience with Github based development methodologies.
  • Strong understanding of data security, access control, and compliance frameworks and implementation techniques
  • Familiarity with business intelligence tools, specifically Power BI, and a strong understanding of how to optimize data models for BI consumption.
  • Proven ability to translate complex business requirements into data architecture and design strategies.
  • Demonstrated ability to lead technical initiatives, influence architecture across teams, and communicate with executive stakeholders.
  • Self-starter and team player with the ability to prioritize and manage multiple projects and deadlines with shifting priorities
  • Deep understanding of Data Governance best practices and the desire + ability to lead excellent data processes across diverse teams.
  • SnowPro Advanced Architect or equivalent certification would be a plus
  • Experience with dbt would be plus
  • 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.

    Create a job alert for this search

    Data Architect • New York, NY, United States

    Related jobs
    • Promoted
    • New!
    Data Developer / Architect

    Data Developer / Architect

    VirtualVocationsNewark, New Jersey, United States
    Full-time
    A company is looking for a Data Developer / Architect responsible for designing, building, and optimizing data systems and solutions. Key Responsibilities : Design, develop, and maintain scalable d...Show moreLast updated: 7 hours ago
    • Promoted
    Gen AI Solution Architect, Senior Consulting Manager

    Gen AI Solution Architect, Senior Consulting Manager

    CognizantTeaneck, NJ, US
    Full-time
    GenAI Solution Architect, Senior Consulting Manager About the role As a GenAI Solution Architect you will make an impact by translating early-stage innovation ideas into structured, scalable soluti...Show moreLast updated: 3 days ago
    • Promoted
    Cloud Data Warehouse Architect

    Cloud Data Warehouse Architect

    Wakefern Food Corp.Edison, NJ, US
    Full-time
    United States and supports its co-operative members' retail operations, trading under the ShopRite®, Price Rite®, The Fresh Grocer®, Dearborn Markets®, and Gourmet Garage® b...Show moreLast updated: 7 days ago
    • Promoted
    Enterprise Data Architect (Edison)

    Enterprise Data Architect (Edison)

    Wakefern Food Corp.Edison, NJ, US
    Part-time
    The ideal candidate will have a strong background in designing, developing, and implementing complex projects, with focus on automating data processes and driving efficiency within the organization...Show moreLast updated: 3 days ago
    • Promoted
    Senior Databricks Architect

    Senior Databricks Architect

    VirtualVocationsYonkers, New York, United States
    Full-time
    A company is looking for a Senior Lead Consultant (Databricks Architect).Key Responsibilities Serve as the technical lead for project teams, ensuring high-quality execution and alignment with bes...Show moreLast updated: 30+ days ago
    • Promoted
    AI Solution Architect

    AI Solution Architect

    EisnerAmperIselin, NJ, United States
    Full-time
    At EisnerAmper, we look for individuals who welcome new ideas, encourage innovation, and are eager to make an impact.Whether you're starting out in your career or taking your next step as a seasone...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Center Architect

    Senior Data Center Architect

    VirtualVocationsJamaica, New York, United States
    Full-time
    A company is looking for a Senior Architect, Data Center Modeling.Key Responsibilities Guide software design, architecture, and implementation of cost and power modeling for datacenter-scale comp...Show moreLast updated: 30+ days ago
    Data Architect

    Data Architect

    Barrow Wise ConsultingNew York, NY, USA
    Full-time
    Quick Apply
    Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you under...Show moreLast updated: 30+ days ago
    • Promoted
    Data Architect (MS Fabric)

    Data Architect (MS Fabric)

    VirtualVocationsAstoria, New York, United States
    Full-time
    A company is looking for a Data Architect (MS Fabric) - Remote.Key Responsibilities Design and implement end-to-end data architecture solutions using Microsoft Fabric Define and establish data g...Show moreLast updated: 23 hours ago
    Data Architect

    Data Architect

    Lever Demo - IS OpportunitiesNew York, New York, United States, 10001
    Full-time
    PLEASE READ : these jobs are testing jobs of Lever's testing environment - please do not apply for this job.Lever was founded ten years ago to tackle the most strategic challenge that companies face...Show moreLast updated: 30+ days ago
    • Promoted
    PKI Architect

    PKI Architect

    VirtualVocationsYonkers, New York, United States
    Full-time
    A company is looking for a Public Key Infrastructure Architect.Key Responsibilities Develop and implement a comprehensive PKI strategy and architecture Manage certificate authorities and automat...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    CyberArk Architect

    CyberArk Architect

    VirtualVocationsJamaica, New York, United States
    Full-time
    A company is looking for a CyberArk Architect to support federal agency operations in designing and implementing a Privileged Access Management solution. Key Responsibilities Lead the architecture...Show moreLast updated: 13 hours ago
    • Promoted
    Senior Business Systems Analyst / Data Architect

    Senior Business Systems Analyst / Data Architect

    Open Systems TechnologiesWoodbridge Township, NJ, US
    Full-time
    Senior Business Systems Analyst / Data Architect.Location : Charlotte, NC or Iselin, NJ.Hybrid Schedule : Onsite 2-3 days / week required. The Lead Business Systems Analyst approves that designed system...Show moreLast updated: 5 days ago
    • Promoted
    • New!
    Data Architect

    Data Architect

    Macmillan LearningNew York, New York, United States
    Full-time
    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...Show moreLast updated: 9 hours ago
    • Promoted
    Data Warehouse Architect

    Data Warehouse Architect

    VirtualVocationsJackson Heights, New York, United States
    Full-time
    A company is looking for a Data Warehouse Architect & AI Analytics Lead.Key Responsibilities Lead the design and implementation of extensions to a Data Vault 2. Architect and pilot predictive anal...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Cloud Solutions Architect (AI)

    Cloud Solutions Architect (AI)

    VirtualVocationsElizabeth, New Jersey, United States
    Full-time
    A company is looking for a Cloud Solutions Architect (AI Focus) to support the DHS ICE OSDSS program.Key Responsibilities Design and implement secure, scalable, and reliable cloud infrastructure ...Show moreLast updated: 11 hours ago
    • Promoted
    • New!
    Solution Data Architect

    Solution Data Architect

    FusemachinesNew York, NY, US
    Full-time
    Fusemachines is a leading AI strategy, talent, and education services provider.Adjunct Associate Professor at Columbia University, Fusemachines has a core mission of democratizing AI.With a presenc...Show moreLast updated: 15 hours ago
    • Promoted
    Data Architect

    Data Architect

    VirtualVocationsPaterson, New Jersey, United States
    Full-time
    A company is looking for a Data Architect to design and optimize enterprise data solutions.Key Responsibilities Define and implement data architecture strategies to enhance integration, quality, ...Show moreLast updated: 30+ days ago
    • Promoted
    Enterprise Data Architect

    Enterprise Data Architect

    Wakefern Food Corp.Edison, NJ, US
    Full-time
    The ideal candidate will have a strong background in designing, developing, and implementing complex projects, with focus on automating data processes and driving efficiency within the organization...Show moreLast updated: 7 days ago
    Senior Data Architect – Data & AI

    Senior Data Architect – Data & AI

    Blue Orange DigitalNew York, New York, US
    Full-time
    Quick Apply
    Blue Orange Digital is a data and AI consulting firm that helps companies turn complex data into real business outcomes.We partner with organizations across industries to design and deploy scalable...Show moreLast updated: 30+ days ago