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 1 day ago
Similar jobs that could be interesting for youBased on the Senior Architect, Data Warehouse & Database Administrator (Relocation Assistance Available!) in Cambridge, MA vacancy
$136.41k - $171.9k
ThermoFisher Scientific is seeking a Sr. Database Administrator who will provide extensive Oracle database support, ensuring high availability and performance. The role involves collaborating with cross-functional teams to implement database solutions and perform tuning...SeniorRemote job- 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
$77.1k - $123.3k
Cengage Group is seeking a skilled data architect in Boston, MA, to build and implement world-class analytics solutions for complex business challenges. This role requires a minimum of 10 years of experience in data architecture and engineering, particularly with Informatica...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
- Snyk Ltd. is looking for a Staff Analytics Engineer in Boston, MA. This strategic role will lead business intelligence and data culture initiatives, advocating for data fluency across the organization. The ideal candidate has 5-7 years of experience in analytics or data...Senior
- Conch Technologies Inc. in Boston is seeking a Senior Snowflake Developer to build, optimize, and secure Snowflake platforms across environments. You will design data models, pipelines, and governance controls, collaborating with cross-functional teams. The role emphasizes...Senior
$126.2k - $264.1k
...Job Description The Senior Data Center Commissioning Manager is responsible for planning, leading, and governing the... ...Cruces, NM area and requires one to live in the area. Relocation assistance available. Only apply if you currently live in this area or are able...Relocation packageSeniorTemporary workFor contractorsLive inLocal areaRelocationFlexible hoursOracle
Boston, MA6 days ago$142.7k - $264.9k
...engine and connective tissue for Design, Data and Data Science innovation strategy... .... The Opportunity: The IA Senior Data Scientist plays a pivotal role... ...This position is based in Boston, MA Relocation Assistance is not available The expected salary range for this position...Relocation packageSeniorFull timeTemporary workLocal area- Netpreme is looking for a Senior Formal Verification Engineer in Boston, MA. In this role, you will develop formal verification... ...offers competitive salary, health benefits, and options for relocation assistance, with a collaborative environment focusing on continuous learning...Relocation packageSenior
$94.1k - $144.8k
...The Database Administrator, Senior leads the design, implementation, and lifecycle management... ...capacity planning, and high‑availability strategies to ensure resilient, scalable data services across complex... .... Key Responsibilities Architect and maintain enterprise‑class...SeniorContract workWork experience placementWork at officeASM Research, An Accenture Federal Services Company
Boston, MA2 days ago- ...Senior Discovery Database Administrator (DBA) Employment Type: Full-Time,... ...hard-working team to assist with any legal accounts... ...of various data models and their components... ...data lakes, data warehouse and data mart... ...redundancy and high Availability, and full backup and...SeniorFull timeFor contractorsFlexible hours
Contact Government Services LLC
Boston, MA4 days ago $82.7k - $137.9k
...pipelines to deliver reliable data products for our Pfizer R&... ..., working closely with senior scientists and engineers... ...environment. Interest in using AI‑assisted coding tools to improve... ...and vision coverage. Relocation assistance may be available based on business needs and...Relocation packageSeniorPermanent employmentH1bLocal areaVisa sponsorshipWork visa2 days per week- A leading online travel agency is seeking a skilled data engineering expert to lead the development of AI-driven data querying... ...teams to define and drive technical initiatives. The position is based in Bangkok with relocation support available. #J-18808-Ljbffr AgodaRelocation packageSenior
$214.9k - $358.1k
...ROLE SUMMARY You will be responsible for setting the data oversight, integrity, analysis, quality, and consistent... ...Tampa, FL or any location outside of the United States. Relocation assistance may be available based on business needs and/or eligibility. Candidates...Relocation packageSeniorPermanent employmentFull timeH1bLocal areaVisa sponsorshipWork visa2 days per weekPfizer
Cambridge, MA22 hours ago- ...Government Services, LLC is looking for a dedicated Discovery Database Administrator to support its legal portfolio in Boston, MA. This role... ...candidate will have experience with performance optimization and data modeling. The position offers benefits like health insurance...Senior
- Senior Discovery Database Administrator (DBA) Employment Type: Full‑Time, Executive... ...optimization. Assist in managing... ...expert knowledge of data model design, development... ...of data lakes, data warehouses, data marts,... ...redundancy and high availability, and provide full backup...SeniorFull timeFlexible hours
- ## Senior Database AdministratorApplyremote type: Fully Remotelocations... ...our next **Senior Database Administrator.** In this role, you will... ...base, while ensuring 24/7 availability. The position will require... ...of database administration, data backup & recovery, security...SeniorCasual workRemote work
- Dormont Manufacturing Co in Boston, Massachusetts, is looking for a Senior Database Administrator II to manage Microsoft SQL Server and support various database activities. The ideal candidate will have a minimum of 5 years experience in SQL Server Database Administration...Senior
- Dormont Manufacturing Co in Boston, MA is seeking a Senior Discovery Database Administrator (DBA) to provide database administration support and develop... ...practices for optimization. The ideal candidate will assist in managing Microsoft SQL Server 2019 and 2022, create...SeniorFull time
$138.6k - $257.4k
...Please do not contact the recruiter directly. Summary Job Title: Senior Expert Data Science, Scientific Innovation #LI-Hybrid Location: Cambridge, USA No of positions available: 2 Relocation Support: This role is based in Cambridge, USA. Novartis is unable...Relocation packageSeniorFull timeNovartis
Cambridge, MA22 hours ago$132.9k - $182.7k
...for good. This job opportunity is available at ANY location in the United States... .... The Code Specialist is a senior-level Registered Architect with deep expertise in building codes... ...requirements, and regulatory standards for Data Center projects. The Code Specialist...Full timeWork at officeLocal areaRemote workJacobs Solutions
Boston, MA5 days ago- A technology startup in Boston is seeking a Senior ASIC Verification Engineer to lead verification efforts for silicon, IP, and... ...compensation, a beneficial work environment, and opportunities for relocation assistance and visa sponsorship. Join us in improving AI capabilities...Relocation packageSeniorVisa sponsorship
- ...Senior Database Administrator Employment Type: Full-Time, Mid Level Department: Information Technology... ...a Senior Database Administrator to assist with administering all aspects of Microsoft... ...implementing and maintaining data warehouses. Experience with AWS RDS for PostgreSQL...SeniorFull timeFlexible hours
Dormont Manufacturing Company
Boston, MA2 days ago $136.41k - $171.9k
...02451 TITLE: Sr. Database Administrator HOURS: Monday to... ...-performance, highly available environment. Collaborate... .../passive clustering, Data Guard, and Golden... ...transactional and data warehouse systems. Managing... ...programs Employee assistance and family support programs...SeniorTemporary workWork at officeRemote workMonday to FridayThermo Fisher Scientific
Watertown, MA1 day ago$80k - $131k
The Senior Digital Marketing Data Analyst will play a critical role in advancing measurement strategy... ...guide for more information on potential relocation. We will not consider candidates who... ...virtually based on scheduling and availability. Offer to selected candidate will be...Relocation packageSeniorFull timeWork at officeLocal areaRelocationFlexible hours- ...Job Title: Senior SQL Server DBA Location: Boston, MA 02135 Duration: Long-... ...seeking an experienced Senior SQL Server Database Administrator (DBA) to support a critical Database... ...performance, and implementing high-availability solutions in enterprise production environments...SeniorLong term contract
Inficare
Brighton, MA1 day ago - Zoox is seeking a Senior Data Scientist for their Perception Data and Labeling team in Boston, Massachusetts. This full-time position involves improving ML model performance through high-quality data, collaborating with engineering and data teams. Ideal candidates will...Relocation packageSeniorFull time
$150k - $250k
...Senior AI Architect Charlestown, Massachusetts Hybrid Full Time $150k - $250k A rapidly growing robotics and warehouse automation company in the Greater Boston area is hiring a full-time... ...basis now and in the future. Specialization: Data and AI Security...SeniorFull timeMotion Recruitment
Charlestown, MA3 days ago- ...Senior Connectivity Architect CEdge has an opportunity for a Senior Connectivity Architect Role, located in Boston, MA. If you are ready to work... ..., responsible for designing, configuring, and validating data integrations between shop floor equipment and enterprise systems...Senior
CEdge Inc.
Boston, MA3 days ago - Whitehead Institute is seeking a Data Warehouse Architect to design and maintain data warehouse architectures, schemas, and ETL processes... .... The role also involves coordinating Oracle database administration, backups, tunings, and supporting secure data access while...
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