Data Architect

Location: United States

Department: Technology

Work Mode: Remote

About the Role

At McGraw Hill, we are dedicated to delivering digital learning experiences that transform education for learners and educators. Our focus is on creating seamless, impactful products that truly benefit our users while supporting growth and collaboration across teams. We foster a culture that values innovation, teamwork, and a balance between career growth and personal well-being. We are seeking a highly motivated and talented Data Architect to support enterprise data initiatives by designing, documenting, and enhancing our modern data architecture. This role is responsible for maintaining data models, applying governance best practices, and enabling analytics through structured, scalable, and trusted data solutions using platforms such as Databricks, Oracle, and Power BI. The ideal candidate brings strong analytical and technical skills, including expert SQL proficiency, and can clearly communicate complex concepts to both technical and non-technical audiences. This individual will thrive in cross-functional environments, collaborating with teams across the organization and contributing to a wide range of initiatives in the dynamic EdTech landscape. They will dive deep into complex data assets, applying advanced analytical techniques to uncover meaningful insights that guide strategic, data-driven decision-making about what to build and why, all while continuously expanding their knowledge in an evolving data landscape. Key responsibilities include conducting end-to-end data analysis, designing Medallion Architecture, developing SQL queries and pipelines, building dashboards in Tableau and Power BI, and mentoring junior analysts on data quality best practices. This is a remote position open to applicants authorized to work for any employer within the United States. The pay range is $93,950 - $150,050 annually, with potential for an annual bonus and full benefits. Join McGraw Hill to play your part in designing content that builds the future of education and experience a sense of fulfillment that inspires greater heights.

Key Responsibilities

• Conduct end-to-end data analysis to identify quality issues, uncover insights, and inform architectural and pipeline improvements
• Design and implement Medallion Architecture (Bronze/Silver/Gold), ensuring clean data flow, proper modeling, and alignment with governance standards
• Collaborate with cross-functional teams to translate business needs into scalable, actionable data solutions
• Develop and maintain SQL queries, data pipelines, dimensional/Kimball models, semantic models, and architectural diagrams
• Support ingestion and transformation using Databricks, Python, Informatica IICS, and Oracle databases
• Build and maintain dashboards, reports, and visualizations in Tableau and Power BI to enable self-service analytics
• Maintain metadata, lineage, and data catalogs
• Mentor junior analysts and promote data quality and performance best practices
• Apply advanced analytical techniques to uncover insights that guide strategic, data-driven decision-making
• Dive deep into complex data assets to support enterprise data initiatives

Required Qualifications

• 5+ years of experience in analytics, reporting, SQL, and ELT/ETL tools (Informatica, Alteryx)
• 5+ years of expertise with BI tools such as Tableau and Power BI (including modeling, DAX, visuals)
• Extensive experience in data modeling, designing database structures, ERDs, and applying Kimball-style dimensional modeling
• 3+ years of cloud experience (AWS, OCI) and hands-on work with Databricks, Lakehouse architecture, and big data formats like Parquet/Delta
• Strong knowledge of Oracle databases, relational modeling, and Oracle SaaS applications
• Strong organizational and communication skills with ability to explain complex concepts to technical and non-technical audiences
• Experience in cross-functional collaboration and mentoring junior analysts

Preferred Qualifications

• Experience in EdTech or SaaS environments
• Familiarity with analyzing data from platforms like Pendo, Google Analytics, or Adobe
• Knowledge of Oracle SaaS applications (ERP/HCM preferred)
• Experience with data governance, cataloging, and metadata management
• Background in integrating data from tools such as Informatica, Alteryx, and Salesforce

Required Skills

• Expert SQL proficiency
• Data modeling and Kimball-style dimensional modeling
• Databricks and Lakehouse architecture
• Python for data analysis and pipelines
• Informatica IICS and ETL/ELT tools
• Oracle databases and relational modeling
• Power BI (DAX, modeling, visuals)
• Tableau for dashboards and visualizations
• Cloud platforms (AWS, OCI)
• Data governance and metadata management
• Big data formats (Parquet/Delta)
• Analytical skills for deep data dives
• Communication of complex concepts
• Cross-functional collaboration
• Mentoring and best practices promotion
• ERD design and architectural diagramming

Benefits

• Competitive base pay range of $93,950 - $150,050 annually
• Annual bonus plan as part of compensation package
• Full range of medical benefits
• Comprehensive benefits package tailored to position
• Remote work flexibility for US-authorized applicants
• Culture of innovation, teamwork, and work-life balance
• Opportunities for career growth and professional development
• Sense of fulfillment from impactful work in education technology

McGraw Hill is an Equal Opportunity Employer.