Senior Architect, Data Warehouse & Database Administrator (Relocation Assistance Available!)
$130kMIT
- # Senior Architect, Data Warehouse & Database Administrator (Relocation Assistance Available!)Applylocations: Cambridge, MAtime type: Full timeposted on: Posted 5 Days Agojob requisition id: JR100620**Classification:**Exempt**Job Family:**Operations**Reports to:**Manager, Enterprise Systems**Job Description Summary:**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 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.* Security & Performance Oversight: + 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.* Collaboration, Documentation & Knowledge Sharing: + 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.* General IT Responsibilities: + 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.Whitehead provides pay ranges representing its good faith estimate of what the Institute reasonably expects to pay for a position at the time of posting. The pay offered to a selected candidate during hiring will be based on factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience and education/training, and internal peer equity. This pay range represents base pay only and does not include any other benefits or compensation.* Pay Range Minimum: $130,000* Pay Range Maximum: $150,000**Whitehead Institute is an E-Verify employer****
- J-18808-Ljbffr MIT
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Senior Architect, Data Warehouse & Database Administrator (Relocation Assistance Available!) in Cambridge, MA vacancy
- CGS is seeking a Senior Discovery Database Administrator to join a fast-paced, hard-working team supporting various aspects of the... ...SQL Server 2019 and 2022, designing data models, ensuring backups and high availability, migrating systems to cloud infrastructure,...Senior
- ...Government Services company, is seeking a Senior Database Administrator (DBA) to support DoD cloud and hybrid... .... The role focuses on high-availability databases using Oracle, MS SQL Server... ...databases, implementing backups, and guiding data migration to Azure Government Cloud....Senior
- A leading industrial software company in Boston seeks a Principal Presales Consultant to lead AI/data ecosystems assessments and advise executives on AI strategy. The role requires presales or consulting experience, knowledge of modern data platforms, and the ability to...Senior
- Whitehead Institute seeks a Senior Architect for Data Warehouse & Database Administration to lead data warehouse design, schema management, and ETL processes, with Oracle DBA duties. You will ensure data integrity, performance, and secure access across enterprise systems...Senior
$126.2k - $264.1k
...onsite in Santa Teresa, New Mexico. Relocation assistance may be available in accordance with Oracle's... ...site-support team responsible for administrative coordination, workflow support, records... ...operational support processes for the data center campus. Provide direct leadership...Relocation packageSeniorTemporary workWork at officeRelocationFlexible hoursOracle
Boston, MA17 hours ago$139.1k - $231.9k
...developed, and delivered to patients. We are seeking AI & Data Engineers to focus on generalist, use case driven AI... ...local pay information with you during the first interview. Relocation assistance may be available based on business needs and/or eligibility....Relocation packageSeniorPermanent employmentFull timeWork experience placementH1bLocal areaVisa sponsorshipWork visaPfizer
Cambridge, MA1 day ago$126.2k - $264.1k
...citizenship and is located onsite in Saline, Michigan. Relocation assistance may be available in accordance with Oracle's relocation policies Key Responsibilities... ...effectiveness, and service execution metrics, using data to improve uptime and reduce repeat failures. Own...Relocation packageSeniorTemporary workFor contractorsRelocationFlexible hoursOracle
Boston, MA17 hours ago$149.2k - $248.6k
...insights Provide mentorship & coaching to Data Scientists & Data Engineering... ...remote; Montreal, Canada Eligible for Relocation Package: No LI-PFE The annual base... ...outside of the United States. Relocation assistance may be available based on business needs and/or...Relocation packageSeniorWork experience placementRemote workFlexible hours$110.7k - $218.3k
...31/2026. Work you'll do As an Oracle EPM Senior Consultant, FCCS on the Controllership and... ...to develop an efficient, high-quality, data-driven, and tech-enabled controllership and... ....Limited immigration sponsorship may be available. Preferred: Experience with extract, transform...SeniorLocal areaVisa sponsorship$176k - $240k
...understand autonomous vehicle behavior. We are looking for a Data Scientist to join our Autonomy Integration Metrics team... ...verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment....Relocation packageSeniorFull timeTemporary work$100k - $200k
...Application architecture, systems and data integrations or migration,... ...and multi-channel CRM.As a Senior Architect in the Veeva Commercial... ...or ordinances. If you need assistance or accommodation due to a... ...where employees are generally available for meetings and collaboration...SeniorPermanent employmentFull timeWork experience placementWork at officeLocal areaRemote workWork from home3 days per week$256k - $307k
...for cities. We are seeking a Staff Data Scientist to join a verification and... ...: Design Evaluation Frameworks: Architect statistical methodologies for safety... ...in application materials based on available information. These tools assist our recruitment team but do not replace...Relocation packageSeniorFull timeTemporary work- Senior Discovery Database Administrator (DBA) CGS is seeking a dedicated Senior... ...‑working team to assist with any legal accounts... ...and maintenance of data models and... ...of data lakes, data warehouses and data mart architectures... ...and high availability, and maintain full...SeniorFlexible hours
- Senior Discovery Database Administrator (DBA) Employment Type: Full‑Time, Executive... ...‑working team to assist with any legal... ...maintenance of various data models and their... ...of data lakes, data warehouse and data mart architectures... ...and high Availability, and full backup and...SeniorFull timeFor contractorsFlexible hours
$105.4k - $207.8k
Position Summary Oracle Identity Senior Consultant / Senior Engineering Management... ...clients to protect users, secure access to data and systems, and improve confidence in... ...serve.Limited immigration sponsorship may be available. Preferred: Experience leading Oracle...SeniorLocal areaVisa sponsorship$169.1k - $314k
...the innovation engine and connective tissue for Design, Data and Data Science innovation strategy within Product Development... ...in scientific communities. Location Boston, MA. Relocation assistance is not available. Compensation The expected salary range for this...Relocation packageLocal areaF. Hoffmann-La Roche AG
Boston, MA17 hours ago- ..., MA100% RemoteDirect Hire$180k - $225kWe are seeking a Senior Database Administrator for a full-time, remote opportunity based in Montreal. This... ...position offers the chance to work on high-scale, high-availability systems supporting global applications. You’ll play a...SeniorFull timeRemote work
$181.8k - $350k
...Chicago, Charlotte Job Opportunity The Senior Commercialization Architect leads the execution and... ...from ambiguity, working with minimal data and available information, uncover leverage point... ...have a disability and either need assistance applying online or need to request...SeniorSummer holidayFlexible hoursEY
Boston, MA1 day ago$132.9k - $182.7k
...world for good.This job opportunity is available at ANY location in the United States... ...candidates.The Code Specialist is a senior-level Registered Architect with deep expertise in building... ...requirements, and regulatory standards for Data Center projects. The Code Specialist...Full timeWork at officeLocal areaRemote workJacobs Solutions
Boston, MA2 days ago$110.7k - $218.3k
...operational efficiency. As an Oracle Senior Consultant at Deloitte, you... ...consolidation, and database consolidation initiatives using... ...immigration sponsorship may be available.Preferred:Experience implementing... ...of experience supporting data center migration or cloud migration...SeniorVisa sponsorship- Sr. Analyst, Database Administrator, 125k to 165kBoston, MA, HybridSummary· Our... ...administration support.· Assist investment groups with new... ...database creation and initial data loads.· Support,... ...VMware virtual machines.· Availability to monitor, respond to and...SeniorLocal area
$107.5k - $204.5k
...are a seasoned data storage engineer... ...infrastructure problems.As a Senior Principal... ...System Administrator, this role will... ...work requirements. Relocation support is available if the applicant... ...Work with storage architects, program leads,... ...implementation guides).Assist in developing...Relocation packageSeniorTemporary workWork experience placementInterim roleCasual workWork at officeLocal areaRemote workRelocationFlexible hours- Senior Project Architect - Mission CriticalJob DescriptionThis position can be worked from any geographical... ..., sustainable, and well executed data center buildings to a diverse group... ...from schematics through construction administration phasesAbility to engage during...SeniorWork at officeLocal areaRemote workFlexible hours
$107.6k - $198.4k
...and efficiency. As an Oracle Senior Consultant at Deloitte, you... ...post-go-live support planning.Assist with current-state and... ...immigration sponsorship may be available.A Bachelor's degree in Supply... ...Chain Management, Business Administration, Logistics, Information Systems...SeniorVisa sponsorship$126k - $234k
...Description SummaryWhat if your data science expertise could help... ...of patients worldwide? As a Senior Expert I or Senior Expert II... ...Massachusetts, United States Relocation Support: This role is based in... .... Experience working with databases and modern data processing technologies...Relocation packageSeniorFull timeWorldwide$191k - $253k
...December. Caregiver & Wellness Leave is available to care for family members, bond with... ...benefits based on your region. Relocation Assistance: Available depending on role eligibility... ...process. To view Anduril's candidate data privacy policy, please visit ....Relocation packageSeniorFull timeWork experience placementAnduril Industries
Boston, MA17 hours ago- ...team, and in turn the firms' data strategy. The ideal candidate... ...for a financial database systems environment with 60+... ...supporting documentation for a high-availability SQL Server database environment... ...workshops etc. Design and assist with database backup and recovery...Senior
CERES Group
Boston, MA4 days ago $142.7k - $264.9k
...connective tissue for Design, Data and Data Science innovation... ...organization.The Opportunity:The IA Senior Data Scientist plays a... ...based in Boston, MARelocation Assistance is not availableThe expected... ...discretionary annual bonus may be available based on individual and...SeniorFull timeTemporary workLocal area$146k - $194k
...We are looking for a Senior Recruiter to join our rapidly... ...sourcing, stakeholder management, data, and candidate experience... ...on recruiter compensation, availability by specialization (... ...based on your region. Relocation Assistance: Available depending on role...Relocation packageSeniorFull timeWork experience placementImmediate startAnduril Industries
Boston, MA17 hours ago$138k - $252k
...use of the specific sensors & payloads available. Core to our autonomy software is... ...benefits available based on your region. ~ Relocation assistance (depending on role eligibility). ~40... ...from you! To view Anduril's candidate data privacy policy, please visit ....Relocation packageSeniorFull timeWork experience placementLocal areaFlexible hoursAnduril Industries
Boston, MA17 hours ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Architect, Data Warehouse & Database Administrator (Relocation Assistance Available!). Be the first to apply!
Related searches
- inventory technician Cambridge, MA
- stock administrator Cambridge, MA
- stock assistant Cambridge, MA
- stocking associate Cambridge, MA
- warehouse technician Cambridge, MA
- stock clerk Cambridge, MA
- store operative Cambridge, MA
- receiving clerk Cambridge, MA
- receiver Cambridge, MA
- stock worker and receiver Cambridge, MA