Description
You will design and manage complex logical and physical database structures for operational and analytic stores.
This role is on-site.
Responsibilities
- Design highly complex logical and physical databases using industry-standard tools.
- Execute data modeling, mapping, integration, and metadata efforts.
- Perform data analysis and data profiling to ensure data integrity.
- Lead design reviews with business and technology stakeholders.
- Troubleshoot complex data architecture issues and resolve bottlenecks.
Required Skills
- 8+ years of Oracle Database Engineering experience or equivalent.
- Expertise in data modeling for operational and analytic data stores.
- Proficiency with denormalization and star schema techniques.
- Hands-on experience with PowerDesigner.
- Experience with streaming data patterns and semi-structured formats like JSON and AVRO.
- Knowledge of REST APIs and Azure and GCP cloud technologies.
- Ability to manage business and technical metadata using industry-standard tools.
Preferred Skills
- Experience with Erwin Data Intelligence.