Database Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Harvard Management Company · 20 hours ago

Database Engineer

Harvard Management Company (HMC) is responsible for managing Harvard University's endowment and related financial assets. They are seeking a skilled Database Engineer to implement robust data models, relational database schemas, and data warehouses, while utilizing Azure services to support data-related tasks and ensure database performance and security.

EducationFinancial ServicesNon Profit
badNo H1Bnote

Responsibilities

Design and implement robust data models, relational database schemas, and data warehouses
Utilize Azure Data Lakes and Data Warehouses to develop modern data storage solutions that enable efficient data ingestion, processing, and retrieval for analytical purposes
Implement 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 other 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)
Design and implement data security and access controls to ensure data integrity and compliance with industry regulations
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

Qualification

Database DesignT-SQLAzure ServicesData WarehousingETL ProcessesData ModelingMicrosoft SQL ServerC# ProgrammingBusiness IntelligenceProblem-SolvingCommunication Skills

Required

Bachelor's degree in computer science, Information Technology, or a related field
Proven experience as a Database Engineer with a minimum of 7 years in database design and development
Experience in data modeling, relational databases, and data warehousing concepts
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
Ability to optimize database performance through code and structural improvements
Experience with ETL processes and data movement between databases
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

Preferred

Familiarity with Azure Cosmos is a plus
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

Benefits

This role is also eligible for an annual bonus.

Company

Harvard Management Company

twittertwitter
company-logo
Harvard Management Company is an organization that manages the financial investments of the Harvard University. It is a sub-organization of Harvard University.

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Bertty Martinez
Chief Financial Officer
linkedin
leader-logo
Sanjeev Daga
Chief Operating Officer
linkedin
Company data provided by crunchbase