Senior Architect, Data Warehouse & Database Administrator (Relocation Assistance Available!)

Job Summary 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. Responsibilities 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 troubleshoot issues affecting reporting or downstream systems. Monitor and recommend improvements to data warehouse performance and availability. Support reporting strategies and ensure data structures align with business intelligence needs, maintaining deep knowledge of database schemas and data relationships to enable accurate reporting. Coordinate and oversee Oracle database administration activities — including configuration, monitoring, backup, recovery, and tuning — to support data warehouse operations. 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 integration standards and best practices. Collaborate with relevant stakeholders to inform and support the definition and implementation of data governance policies, providing technical expertise and recommendations. Ensure the security and integrity of data warehouse systems and stored data: support access controls, coordinate with IT teams on data protection, and maintain robust security monitoring systems for all developed applications and data solutions. Oversee the implementation of security best practices throughout the development lifecycle and drive initiatives to optimize application performance and scalability. Work closely with other IT teams and stakeholders to deliver enterprise data solutions: maintain technical documentation for data warehouse processes, schemas, and support procedures; create and maintain comprehensive technical documentation, architectural diagrams, and knowledge base articles; foster a culture of knowledge sharing and collaboration within the team and across IT. Follow established IT service management processes and procedures; perform other related duties as assigned. Qualifications Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent experience. 5 – 7 years of experience with data warehouse architecture, RDBMS, schema design, SQL, Oracle PL/SQL, reporting structures, and business intelligence support preferred. Experience with Oracle database administration preferred. Knowledge of Workday WQL and a deep understanding of Workday Business Objects is highly valued. Experience with report writing (Cognos Reports preferred). Familiarity with database configuration, backup, recovery, and performance tuning preferred. Strong analytical and troubleshooting skills. Ability to collaborate effectively with technical and non‑technical stakeholders at all levels. Demonstrated ability to translate complex data requirements for both technical and non‑technical stakeholders. Commitment to inclusive practices and diverse teams valued. Pay Range Pay Range Minimum: $130,000 Pay Range Maximum: $150,000 Legal Notice Whitehead Institute is an E-Verify employer: #J-18808-Ljbffr SwiftCruit