About the role
**Job Title: Data Architect With SAP, Data Lake Experience Mandatory** **Location: New Jersey (Onsite)-Day 1 Onsite** **Duration: Long Term** **Job Description:** **Must-Have Requirements (The below requirements have been shared by the client.** - **Architect-level experience** is required; BI or Data Analyst profiles will **not** be considered. - Candidate should have **started their career with a reputed/renowned company** . - **SAP experience is mandatory.** - **PeopleSoft experience is preferred. (It is generally not mentioned in resume, hence, you need to check with candidate if he/she has experience in Peoplesoft)** - Strong experience with **Delta Lake or Data Lake migration projects** , particularly **PeopleSoft-to-SAP migrations** . - Minimum **2 relevant projects** or **4+ years of hands-on experience** in Data Lake/Delta Lake. - **Canonical Model Design experience is mandatory.** This is often not explicitly mentioned on resumes, so please **validate this experience directly with the candidate** . - Excellent **communication skills** are required. - 15–20 years of experience in data engineering and data architecture, including 4+ years owning enterprise-scale data architecture. - Expert-level enterprise data modelling: conceptual, logical and physical modelling. - Strong knowledge of 3NF, dimensional modelling, conformed dimensions, slowly changing dimensions, grain and key design. - Experience designing canonical / enterprise data models across multiple source systems. - Strong experience in data harmonisation, source-of-record decisions and reusable enterprise datasets. - Experience with data products, data mesh and contract-based data delivery. - Strong hands-on experience with Google Cloud Platform data services: - BigQuery - Cloud Storage - Dataflow / Dataproc - Cloud Composer / Airflow - Pub/Sub - Dataplex / enterprise data catalogues - Advanced SQL, including large-scale query optimisation, partitioning, clustering and cost optimisation. - Strong Python skills for data engineering and production pipeline development/review. - Experience with dbt and modern data transformation frameworks. - Experience with CI/CD for data platforms, including branching, automated testing, environment promotion and release management. - Strong understanding of enterprise BI consumption, particularly Tableau. - Experience reconciling BI outputs with data lake / warehouse data. - Strong experience working with ERP data; SAP strongly preferred. - Experience with SAP data across sales, billing, delivery, general ledger and inventory. - Experience with HR, finance and warehouse-management data sources, including PeopleSoft. - Strong understanding of business processes including Order-to-Cash, Record-to-Report and Inventory Management. - Experience designing data quality frameworks covering freshness, completeness, reconciliation, null rates and schema drift **Best Regards,** **Ravi M** | Senior Recruiter **Cyberobotix Technology** 6500 River Place Blvd, Building 7, Suites 250, Austin, Texas 78730 **E:** ravi@cyberobotix.com **W: www.cyberobotix.com** Technology Consulting & Talent Solutions | United States & India This email and any attachments are confidential and intended only for the recipient.