Description

Lead the design and implementation of enterprise-class data repositories and drive data modernization efforts.

Responsibilities

• Design and implement enterprise data repositories using Oracle on-prem and cloud-hosted databases.
• Develop fully automated ETL processes from flat-file and database sources using API calls for data refreshes.
• Translate complex business requirements into scalable, performant technical solutions and architectural diagrams.
• Mentor senior and junior IT staff on technical standards and system documentation.

Required Skills

• 14+ years of experience in data architecture and database administration.
• Senior DBA-level experience with Oracle on-prem and cloud-hosted platforms.
• Mastery of SQL and PL/SQL for developing complex procedures, functions, views, and scripts.
• Expertise in dimensional modeling and tabular data models.
• Practical experience with Oracle Analytics Cloud (OAC).
• Proven ability to build automated ETL pipelines and utilize API calls for data integration.
• Strong discipline in process/error logging, coding comments, and metadata creation.
• Ability to work independently with limited oversight to meet project goals.

Preferred Skills

• Experience researching technical options independently to solve evolving architectural needs.

Key Skills

Education

Any Graduate