Staff Data Engineer

Dexcom Corporation is a pioneer and global leader in continuous glucose monitoring (CGM). The Staff Data Engineer will design and maintain database systems, optimize performance, and collaborate with cross-functional teams to enhance data integration and reporting for manufacturing operations.

Responsibilities:

• You will design, develop and maintain SQL database systems to support manufacturing operations
• You will optimize and monitor MS SQL Server databases, ETL/ELT integrations, CDC, replication, GCP BigQuery DBT Data Models, and GCP Iceberg archival to ensure high performance and data availability
• You will drive database best practices and support data modernization initiatives by adopting cutting-edge technologies including Ai and MCP
• You will develop and maintain monitoring tools and processes to proactively identify and address database related issues
• You will implement and maintain ETL/ELT processes, data warehousing and replication solutions to provide near real-time data solutions across the globe for efficient data storage and retrieval
• You will collaborate with cross-functional teams to gather requirements, design systems and implement database solutions. Ex: Stored procedures, table design, schema design, data contract for API, data dictionary to support manufacturing software systems
• You will work with Microsoft SQL Server stack and GCP stack including SSIS, SSRS, PowerBI, PolyBase data virtualization, BigQuery, Datastream, Cloud Storage, BigLake tables for Apache Iceberg, Cloud SQL, and DBT
• You will work with cross-functional teams including R&D, Operations, Process Engineering, Quality Assurance, Contract Manufacturers, and other stakeholders to facilitate data access in terms of reporting and data integration
• You are able to collaborate with the IT security team in maintaining Public Key Infrastructure (PKI) Hardware Security Modules (HSM) used for key management and cryptographic operations with assisting in the configuration, installation and ongoing maintenance of PKI HSMs to ensure secure and reliable operation
• You will document and train DBA teams on solutions to common issues encountered and best practices

Requirements:

• You will design, develop and maintain SQL database systems to support manufacturing operations
• You will optimize and monitor MS SQL Server databases, ETL/ELT integrations, CDC, replication, GCP BigQuery DBT Data Models, and GCP Iceberg archival to ensure high performance and data availability
• You will drive database best practices and support data modernization initiatives by adopting cutting-edge technologies including Ai and MCP
• You will develop and maintain monitoring tools and processes to proactively identify and address database related issues
• You will implement and maintain ETL/ELT processes, data warehousing and replication solutions to provide near real-time data solutions across the globe for efficient data storage and retrieval
• You will collaborate with cross-functional teams to gather requirements, design systems and implement database solutions. Ex: Stored procedures, table design, schema design, data contract for API, data dictionary to support manufacturing software systems
• You will work with Microsoft SQL Server stack and GCP stack including SSIS, SSRS, PowerBI, PolyBase data virtualization, BigQuery, Datastream, Cloud Storage, BigLake tables for Apache Iceberg, Cloud SQL, and DBT
• You will work with cross-functional teams including R&D, Operations, Process Engineering, Quality Assurance, Contract Manufacturers, and other stakeholders to facilitate data access in terms of reporting and data integration
• You are able to collaborate with the IT security team in maintaining Public Key Infrastructure (PKI) Hardware Security Modules (HSM) used for key management and cryptographic operations with assisting in the configuration, installation and ongoing maintenance of PKI HSMs to ensure secure and reliable operation
• You will document and train DBA teams on solutions to common issues encountered and best practices
• You are able to prioritize and execute tasks in a high-pressure environment
• You are detail oriented and able to maintain updated documentation
• You have working knowledge with data management and other tools, such as Jira, Jama and Confluence
• Strong English written and oral communication skills
• Creative problem solver with attention to detail
• Must have 5+ years experience with Microsoft SQL Server and fluent in SQL Server 2012+
• Must have some DBA experience or knowledgeable in DBA best practices and an understanding of replication
• Typically requires a Bachelor's degree in a technical discipline, and a minimum of 8-12 years related experience or Master's degree and 5-7 years equivalent industry experience or a PhD and 2-4 years of experience
• Nice to have experience with BigQuery, Iceberg, DBT, and open table formats or similar technology and knowledgeable in VMware and SQL Server 2022
• Nice to have experience with Siemens Camstar