Description

Design and implement enterprise data warehouse solutions and dimensional database models.

This role is remote.

Responsibilities

• Translate business requirements into technical data documentation and mapping specifications.
• Design logical and physical data models for analytics and reporting in alignment with enterprise standards.
• Develop source, target, and output mapping documents to ensure complete data lineage and integration.
• Collaborate with developers and DBAs to identify and resolve performance bottlenecks in queries and data models.
• Architect, build, and deploy end-to-end business intelligence solutions.

Required Skills

• 10+ years of experience with Oracle database technologies, SQL, PL/SQL, Stored Procedures, and Triggers.
• 8+ years of experience in database design, architecture, data modeling, and performance tuning.
• 8+ years of experience developing enterprise Data Warehouse solutions.
• Proven ability to design and implement dimensional database models.
• Strong SQL development expertise.
• Experience with Oracle RAC, Oracle Exadata, and Oracle Golden Gate.
• Bachelor's degree in Computer Science or equivalent technical experience.

Preferred Skills

• Extensive experience on the Oracle platform.
• Experience with ERWIN data modeller.
• Experience with banking and financial industry reporting.

Key Skills

Education

Bachelor's degree in Computer Science