Senior Architect, Data Warehouse & Database Administrator

OVERALL RESPONSIBILITIES

Provide specialized technical expertise in data warehouse architecture, schema management, and data warehouse ETL processes to support reporting and business intelligence, with secondary responsibilities for Oracle database administration. This role focuses on designing and maintaining data structures, schemas, workflows, and data warehouse ETL processes that enable reliable reporting, analytics, and operational decision-making across critical enterprise systems, while ensuring data integrity and performance. The position holder will support secure, efficient data access and help optimize data platforms, with hands-on database configuration, backup, and tuning as needed.

CHARACTERISTIC DUTIES

• Data Warehouse Architecture & Schema Management:
• Lead design and maintenance of data warehouse architecture, including schema understanding and data structures for reporting and business intelligence.
• Collaborate with stakeholders to analyze reporting requirements, design schemas, and optimize data models for efficient analysis and decision-making.
• Assist with data workflows, ETL processes, and troubleshooting issues affecting reporting or downstream systems.
• Monitor and recommend improvements to data warehouse performance and availability.
• Reporting & Analytics Support:
• Support reporting strategies and ensure data structures align with business intelligence needs.
• Maintain deep knowledge of database schemas and data relationships to enable accurate reporting.
• Oracle Database Administration:
• Coordinate and oversee Oracle database administration activities — including configuration, monitoring, backup, recovery, and tuning — to support data warehouse operations.
• Enterprise System Integration & Data Governance:
• Lead the strategic integration of data across critical enterprise systems (e.g., Workday, Cayuse, Lawson), ensuring data accuracy, consistency, and efficient workflows.
• Establish and enforce data integrati...