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

Whitehead Institute•Cambridge, MA

8d•$130,000 - $150,000•Onsite

About The Position

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.

Requirements

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.
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.

Nice To Haves

Experience with Oracle database administration.
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.

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 troubleshooting 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.
Maintain 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 and coordinate with IT teams on data protection.
Ensure the establishment and ongoing maintenance of robust security monitoring systems for all developed applications and data solutions.
Oversee the implementation of security best practices throughout the development lifecycle.
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.
Ensure the creation and maintenance of 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.