Lead Data Modeler

Lead Data Modeler

Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is the one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work® Institute and recognized as a ‘Cool Vendor’ and a ‘Vendor to Watch’ by Gartner.

Please visit Fractal | Intelligence for Imagination for more information about Fractal.

Note: This position is not eligible for Immigration Sponsorship at this time.

Position Overview:

We are seeking a Lead Data Modeler with deep expertise in SAP ECC/BW data models to act as a Solution Architect for our client program on an enterprise scale. In this role, you will own end-to-end solution architecture across Discovery, Design, Development, Validation, and Deployment, defining scalable frameworks across Bronze, Silver, Gold, Semantic, and Product data layers. You will leverage your SAP domain knowledge to design and optimize ETL/ELT pipelines, translate complex CPG, Sales, and Finance business requirements into robust data solutions, and drive technical alignment across workstreams. This is a high-impact leadership role that blends deep technical expertise with direct client engagement and stakeholder management.

Key Responsibilities:

Solution Architecture & Design

• Own and govern the overall solution architecture for large-scale data engineering programs.
• Define scalable, reusable, and enterprise-grade architectural frameworks across data ingestion, processing, transformation, semantic, and product layers.
• Establish architecture standards, design principles, reference architectures, and implementation guidelines.
• Define and promote reusable design patterns, frameworks, and accelerators to improve delivery efficiency.
• Review and approve technical designs, data models, and implementation approaches before development.

SAP Data Modeling & ETL Engineering

• Apply deep expertise in SAP ECC and BW source tables to design and optimize data models for ETL/ELT pipelines.
• Lead enterprise data modeling initiatives across conceptual, logical, and physical layers, with a strong understanding of CPG, Sales, and Finance business processes.
• Ensure alignment between business KPIs, reporting requirements, and data architecture across workstreams.
• Collaborate with Data Governance teams to implement metadata management, data quality controls, lineage tracking, and compliance standards.

Data Engineering & Platform Leadership

• Design and deliver modern cloud-native data platforms using Azure and Databricks, ensuring optimal performance across all data layers.
• Drive data integration, transformation, data quality, and performance optimization strategies at scale.
• Provide architectural guidance on scalability, reliability, security, and maintainability of enterprise data solutions.
• Support deployment readiness, production stabilization, and architecture reviews.

Technical Leadership & Mentoring

• Guide workstream architects, data engineers, and development teams on architecture and implementation best practices.
• Perform hands-on technical reviews of code, pipelines, notebooks, and solution implementations, and engage directly to analyze, review, and optimize where needed.
• Identify opportunities for performance optimization and provide recommendations to improve maintainability across teams.
• Mentor junior architects and engineers, fostering technical excellence and architectural consistency across teams.

Stakeholder & Client Engagement

• Partner directly with business stakeholders and SMEs to translate CPG, Sales, and Finance requirements into scalable technical solutions.
• Drive architecture governance forums and technical design discussions with client-side teams.
• Manage and resolve cross-workstream dependencies, risks, and technical blockers to maintain program momentum.

Required Qualifications:

• 8+ years of experience in data modeling, data architecture, and data engineering, with at least 3 years in a technical lead or architect capacity.
• Deep hands-on expertise with SAP ECC and SAP BW source tables and data structures used in ETL/ELT pipelines and data engineering workflows.
• Strong proficiency in enterprise data modeling: conceptual, logical, and physical models across multi-layer data platforms (Bronze, Silver, Gold, Semantic, Product).
• Solid understanding of CPG and/or Retail Domain, to include Sales, and Finance business processes and their corresponding data flows and reporting requirements.
• Experience designing and delivering cloud-native data platforms on Azure, including data integration, transformation, and governance at enterprise scale.
• Proven ability to engage directly with business stakeholders to gather requirements, drive alignment, and present technical solutions clearly.
• Strong leadership and mentoring skills, with experience guiding cross-functional engineering teams and resolving complex technical challenges.
• Experience with Data Governance frameworks, metadata management, data quality controls, and lineage tracking.

Preferred Qualifications:

• Hands-on experience with Databricks for large-scale data engineering and analytics workloads.
• Familiarity with modern data lakehouse architectures.
• Prior consulting or client-facing experience in a Fortune 500 environment, particularly within CPG or retail sectors.

Pay:

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is: $125,000 - $185,000. In addition, you may be eligible for a discretionary bonus for the current performance period.

Benefits:

As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time. You will be eligible for benefits on the first day of employment with the Company. In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms. The Company provides for 11 paid holidays and 12 weeks of Parental Leave. We also follow a "free time" PTO policy, allowing you the flexibility to take the time needed for either sick time or vacation.

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.