Description
You will design and maintain relational, dimensional, and analytic data models while managing data ingestion protocols and ETL processes.
This role is on-site.
Responsibilities
- Design and maintain relational, dimensional, and analytic data models.
- Build and maintain infrastructure for data warehouses, data lakes, and enterprise big data platforms.
- Perform performance tuning and PL/SQL optimization to ensure efficient query execution.
- Execute QA testing and create technical diagrams for data architecture.
- Manage data ingestion protocols and ETL processes across multi-data-center contexts.
Required Skills
- 5+ years of experience in data modeling and architecture.
- Hands-on experience with RDBMS, dimensional modeling, and ETL.
- Proficiency in Python and AWS.
- Strong knowledge of Oracle and PostgreSQL.
- Expertise in PL/SQL and performance tuning.
- Experience with metadata management and data warehousing concepts.
- Proficiency with modeling tools such as Erwin or ER Studio.
Preferred Skills
- Ability to handle diagramming and infrastructure design.