Principal Data Modeling Engineer

This position is onsite/hybrid in our Pleasanton, CA office - remote option is not available for this role. Oracle Analytics is used by customers across the world to discover deep insights about their business, improve collaboration around a single view by securely including all relevant data, and increase agility by quickly spotting patterns and powering data-driven decisions with AI and machine learning. Oracle Fusion Data Intelligence platform (FDI) is the next generation of Oracle Fusion Analytics Warehouse built for Oracle Fusion Cloud Applications, bringing together business data, ready-to-use analytics, and prebuilt AI and machine learning (ML) models to deliver deeper insights and accelerate the decision-making process into actionable results. The backbone of FDI is the lights-out data pipeline that manages the data warehouse for all the customers. https://docs.oracle.com/en/cloud/saas/analytics/24r2/index.html For this position, we are seeking a full stack data engineer to join our growing team in the United States with following skills As a member of the FDI Pipeline team: You will learn Business/functional requirements from Product Managers/Subject Matter Experts and analyze data sufficiency You will design/implement data models and pipelines to power reporting/analytics/ML-models. We deliver easy to explain/understand data models. You will own the own quality of the deliverable, design/develop unit/integration tests and also collaborate with QA counterparts. You will debug/analyze data issues (mismatch/refresh etc). In fact you will take data debugging into consideration as part of design. You will monitor and learn from current deployment statistics/customer feedback and advances of underlying platform to identify potential improvements. You will learn about prior art, competitive offering, new technologies and will get opportunity to influence the features of underlying platform. You will create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow Career Level - IC4 BS or higher degree in Computer Science, Computer Engineering or equivalent with 10+ years of applied experience5+ years of proven experience working in data architecture/engineering/modeling Strong knowledge of Kimball and data model best practices in big data world. Experience with analytical relational databases (understanding of Execution Plan, partitions) Experience with big data systems Spark (understanding of driver, executors, partitions)Proficiency in SQL, data modeling tools, and ETL processes/patterns/best practices. Experience with data analysis, basic statistics and visualization Strong problem-solving/analytical skills and eye for details Strong programming skills in Python/PySpark/JavaExcellent communication skills, both written and verbal Experience in Data Science concepts, Machine Learning/Artificial Intelligence is a plus Experience in Software engineering is a plus Experience in development/supporting data product/solutions over multiple releases is a plus. Experience with Oracle Cloud and Oracle Analytics is a plus Career Level - IC4