Database Engineer - onsite
On-siteDetroit, Michigan, United States
Job Summary
Design, implement, and maintain enterprise-grade data warehouse architectures, including dimensional models and scalable schemas. Optimize complex SQL queries, views, and stored procedures to ensure high performance across large-scale analytical workloads. Manage ELT/ETL pipelines, validate data integrity, and enforce security policies and governance standards. Monitor warehouse usage efficiency, support disaster recovery, and mentor junior engineers while collaborating with analytics and business stakeholders. Requires 5+ years of experience with Snowflake, Redshift, or Teradata. Onsite location in the Bay Area.
Required Qualifications
- Bachelor's degree in Computer Science, Engineering, Information Systems, or related field (or equivalent experience)
- 5+ years of experience as a Database Engineer, Data Engineer, or Data Warehouse Engineer
- Expert-level SQL skills with experience handling large datasets
- Strong experience designing and operating data warehouses for analytics and BI
- Cloud Data Warehouses: Snowflake, Amazon Redshift, Google BigQuery, Azure Synapse
- On-Prem / MPP Databases: Teradata, Oracle, SQL Server, Vertica, Greenplum
- OLAP / Analytics Concepts: Columnar storage, MPP architectures, query optimization
- Strong knowledge of data modeling methodologies (Kimball, Inmon)
- Experience with ELT/ETL tools and orchestration frameworks
- Understanding of data partitioning, compression, and workload management
- Familiarity with BI tools (Tableau, Power BI, Looker, etc.)
- Experience with cloud infrastructure, cost optimization, and scaling strategies
- Exposure to metadata management, data catalogs, and governance tools
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.