Harvard Management Company
Join to apply for the
Database Architect/Developer
role at
Harvard Management Company 3 days ago Be among the first 25 applicants Join to apply for the
Database Architect/Developer
role at
Harvard Management Company Formed in 1974, Harvard Management Company (“HMC”) manages Harvard University's endowment and related financial assets. Our singular mission is to help ensure Harvard University has the financial resources to maintain and expand its leadership in teaching, learning, and research for future generations. The endowment is managed by a highly experienced generalist investment team whose members each take ownership of the entire portfolio, regardless of asset class. HMC's operational structure brings a wide range of expertise to our portfolio management. These functions include legal, compliance, finance and accounting, human resources and administrative services as well as information technology to develop and implement the systems necessary to support our investment activities.
Summary
We are seeking a skilled and motivated Database Architect/Developer to join our dynamic team. The ideal candidate will be able to lead the design and implementation of robust data models, relational database schemas, and data warehouses. They should possess a strong background in data modeling, RDMS, and data warehousing, along with extensive experience in creating and optimizing database structures and stored procedures using T-SQL. Proficiency in working with Azure services, particularly Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage, is essential for this role.
Summary Of Responsibilities
Design and implement robust data models, relational database schemas, and data warehouses. Utilize Azure Data Lakes and Data Warehouses to architect modern data storage solutions that enable efficient data ingestion, processing, and retrieval for analytical purposes. Lead the end-to-end database solution development lifecycle, including data modeling, data flow design, ETL processes, and database schema design. Develop and deploy complex stored procedures, tables, views, functions, triggers, indexes, constraints, and sequences using T-SQL. Utilize Azure services for data-related tasks, including data ingestion, processing, and storage. Collaborate with developers to provide necessary database support and guidance for their projects. Work closely with data engineers, data scientists, and other teams to ensure seamless integration of data sources and enable advanced analytics and reporting capabilities. Conduct comprehensive database reviews for development projects, ensuring adherence to standards and best practices. Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014/2017/2019). Collaborate with stakeholders to understand business requirements and translate them into robust and scalable database architecture designs on the Azure Cloud platform. Evaluate and recommend appropriate data storage and database technologies within the Azure ecosystem to optimize performance and cost-efficiency. Design and implement data security and access controls to ensure data integrity and compliance with industry regulations. Work with the Data Governance team to develop strategies and best practices to maintain data quality and consistency across different databases and applications. Optimize database performance by fine-tuning queries, indexes, and configurations, and proactively monitor and address performance bottlenecks. Work with the system engineers to recommend and implement disaster recovery and backup strategies to ensure high availability and data resiliency. Stay up-to-date with the latest advancements in Azure Cloud database tools and recommend appropriate enhancements or migrations to improve the overall database architecture.
Qualifications
Bachelor’s degree in computer science, Information Technology, or a related field. Proven experience as a Database Architect/Developer with a minimum of 8 years in database design and development. Strong expertise in data modeling, relational databases, and data warehousing concepts. Ability to lead projects end to end, including collaboration with team members and directing work. Proficiency in T-SQL scripting for creating complex stored procedures and queries. Hands-on experience with Microsoft Fabric, Azure services, including Azure Data Factories, Data Lakes, DataBricks, SQL Server Managed Instance, and Azure Storage. Familiarity with Azure Cosmos is a plus. Ability to optimize database performance through code and structural improvements. Experience with ETL processes and data movement between databases. Knowledge in C# programming is a plus and may be beneficial in certain project contexts. Familiarity with Business Intelligence (BI) tools will be advantageous for integrating data analysis and visualization capabilities. Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014/2017/2019). A proactive problem-solving attitude with the ability to troubleshoot and resolve database issues efficiently. Strong communication skills and the ability to work collaboratively in a team environment. Demonstrated adherence to best practices in database design, development, and management.
Other Details
The FLSA classification for this position is exempt. HMC is operating on a hybrid work model where employees are in the office from Tuesday to Thursday and remote on other days. HMC will not sponsor applicants for work visas for this position.
Interested candidates should apply online via
https://www.hmc.harvard.edu/careers/
Required Skills
Required Experience Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Referrals increase your chances of interviewing at Harvard Management Company by 2x Get notified about new Database Architect jobs in
Boston, MA . Cambridge, MA $147,000.00-$216,000.00 3 weeks ago Cambridge, MA $147,000.00-$216,000.00 1 day ago Cambridge, MA $177,000.00-$263,000.00 4 hours ago Data Architect (15+ Yrs ExP)_Milliman Build (HEALTHCARE EXP NEEDED)_Remote_ONLY ON W2
IT Solutions Architect, Enterprise Reporting and Data Governance
Waltham, MA $135,000.00-$145,000.00 1 week ago Staff Clinical Informatics Data Architect
Boston, MA $162,000.00-$230,000.00 1 month ago Canton, MA $100,000.00-$140,000.00 1 week ago Boston, MA $188,190.00-$230,010.00 2 days ago Canton, MA $90,000.00-$110,000.00 1 week ago Boston, MA $153,000.00-$276,000.00 2 weeks ago Boston, MA $104,860.00-$194,740.00 2 weeks ago Boston, MA $102,400.00-$204,100.00 15 hours ago Data Integration Architect - Hybrid 4days a week, Boston, MA - W2 only
Sr. Technical Solutions Architect (Cloud Data, Life Science, ELN/LIMS) - US Remote
Delivery Consultant - Data Architect, AWS Professional Services, AWS Professional Services, AWS Professional Services
Boston, MA $138,200.00-$239,000.00 2 weeks ago Senior Delivery Consultant - Data Architect, AWS Professional Services, AWS Professional Services
Boston, MA $138,200.00-$239,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Database Architect/Developer
role at
Harvard Management Company 3 days ago Be among the first 25 applicants Join to apply for the
Database Architect/Developer
role at
Harvard Management Company Formed in 1974, Harvard Management Company (“HMC”) manages Harvard University's endowment and related financial assets. Our singular mission is to help ensure Harvard University has the financial resources to maintain and expand its leadership in teaching, learning, and research for future generations. The endowment is managed by a highly experienced generalist investment team whose members each take ownership of the entire portfolio, regardless of asset class. HMC's operational structure brings a wide range of expertise to our portfolio management. These functions include legal, compliance, finance and accounting, human resources and administrative services as well as information technology to develop and implement the systems necessary to support our investment activities.
Summary
We are seeking a skilled and motivated Database Architect/Developer to join our dynamic team. The ideal candidate will be able to lead the design and implementation of robust data models, relational database schemas, and data warehouses. They should possess a strong background in data modeling, RDMS, and data warehousing, along with extensive experience in creating and optimizing database structures and stored procedures using T-SQL. Proficiency in working with Azure services, particularly Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage, is essential for this role.
Summary Of Responsibilities
Design and implement robust data models, relational database schemas, and data warehouses. Utilize Azure Data Lakes and Data Warehouses to architect modern data storage solutions that enable efficient data ingestion, processing, and retrieval for analytical purposes. Lead the end-to-end database solution development lifecycle, including data modeling, data flow design, ETL processes, and database schema design. Develop and deploy complex stored procedures, tables, views, functions, triggers, indexes, constraints, and sequences using T-SQL. Utilize Azure services for data-related tasks, including data ingestion, processing, and storage. Collaborate with developers to provide necessary database support and guidance for their projects. Work closely with data engineers, data scientists, and other teams to ensure seamless integration of data sources and enable advanced analytics and reporting capabilities. Conduct comprehensive database reviews for development projects, ensuring adherence to standards and best practices. Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014/2017/2019). Collaborate with stakeholders to understand business requirements and translate them into robust and scalable database architecture designs on the Azure Cloud platform. Evaluate and recommend appropriate data storage and database technologies within the Azure ecosystem to optimize performance and cost-efficiency. Design and implement data security and access controls to ensure data integrity and compliance with industry regulations. Work with the Data Governance team to develop strategies and best practices to maintain data quality and consistency across different databases and applications. Optimize database performance by fine-tuning queries, indexes, and configurations, and proactively monitor and address performance bottlenecks. Work with the system engineers to recommend and implement disaster recovery and backup strategies to ensure high availability and data resiliency. Stay up-to-date with the latest advancements in Azure Cloud database tools and recommend appropriate enhancements or migrations to improve the overall database architecture.
Qualifications
Bachelor’s degree in computer science, Information Technology, or a related field. Proven experience as a Database Architect/Developer with a minimum of 8 years in database design and development. Strong expertise in data modeling, relational databases, and data warehousing concepts. Ability to lead projects end to end, including collaboration with team members and directing work. Proficiency in T-SQL scripting for creating complex stored procedures and queries. Hands-on experience with Microsoft Fabric, Azure services, including Azure Data Factories, Data Lakes, DataBricks, SQL Server Managed Instance, and Azure Storage. Familiarity with Azure Cosmos is a plus. Ability to optimize database performance through code and structural improvements. Experience with ETL processes and data movement between databases. Knowledge in C# programming is a plus and may be beneficial in certain project contexts. Familiarity with Business Intelligence (BI) tools will be advantageous for integrating data analysis and visualization capabilities. Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014/2017/2019). A proactive problem-solving attitude with the ability to troubleshoot and resolve database issues efficiently. Strong communication skills and the ability to work collaboratively in a team environment. Demonstrated adherence to best practices in database design, development, and management.
Other Details
The FLSA classification for this position is exempt. HMC is operating on a hybrid work model where employees are in the office from Tuesday to Thursday and remote on other days. HMC will not sponsor applicants for work visas for this position.
Interested candidates should apply online via
https://www.hmc.harvard.edu/careers/
Required Skills
Required Experience Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Referrals increase your chances of interviewing at Harvard Management Company by 2x Get notified about new Database Architect jobs in
Boston, MA . Cambridge, MA $147,000.00-$216,000.00 3 weeks ago Cambridge, MA $147,000.00-$216,000.00 1 day ago Cambridge, MA $177,000.00-$263,000.00 4 hours ago Data Architect (15+ Yrs ExP)_Milliman Build (HEALTHCARE EXP NEEDED)_Remote_ONLY ON W2
IT Solutions Architect, Enterprise Reporting and Data Governance
Waltham, MA $135,000.00-$145,000.00 1 week ago Staff Clinical Informatics Data Architect
Boston, MA $162,000.00-$230,000.00 1 month ago Canton, MA $100,000.00-$140,000.00 1 week ago Boston, MA $188,190.00-$230,010.00 2 days ago Canton, MA $90,000.00-$110,000.00 1 week ago Boston, MA $153,000.00-$276,000.00 2 weeks ago Boston, MA $104,860.00-$194,740.00 2 weeks ago Boston, MA $102,400.00-$204,100.00 15 hours ago Data Integration Architect - Hybrid 4days a week, Boston, MA - W2 only
Sr. Technical Solutions Architect (Cloud Data, Life Science, ELN/LIMS) - US Remote
Delivery Consultant - Data Architect, AWS Professional Services, AWS Professional Services, AWS Professional Services
Boston, MA $138,200.00-$239,000.00 2 weeks ago Senior Delivery Consultant - Data Architect, AWS Professional Services, AWS Professional Services
Boston, MA $138,200.00-$239,000.00 2 weeks ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr