Lead Database Engineer

Work Schedule Other

Environmental Conditions Office

Summarized Purpose:

We are seeking a Lead Database Engineer to design, build, optimize, and support AWS-based data lake, data warehouse, and database platforms. This role will lead database architecture, performance tuning, data quality, lineage, source-to-target mapping, production support, and technical delivery across PostgreSQL, Redshift, Athena, DynamoDB, SQL Server, and related AWS services.

Education/Experience:

• Bachelor's degree or equivalent experience and relevant formal academic/vocational qualification.

• Previous roles showcasing 7+ years of database engineering, data architecture, AWS data platform, SQL development, performance tuning, and production support experience, or an equivalent blend of education, training, and experience.

Major Job Responsibilities:

• Design, build, and maintain AWS-based data lake and warehouse architecture using S3, Redshift, DynamoDB, RDS, Athena, and related cloud data services.

• Optimize PostgreSQL, Redshift, Athena, DynamoDB, SQL Server, and SQL-based workloads for performance, reliability, scalability, and cost.

• Lead data integrations, ETL processes, database operations, and source-to-target mapping based on stakeholder and collaborator requirements.

• Maintain and improve existing integrations while adding new EMR, clinical, operational, and enterprise data integrations.

• Implement data quality frameworks, automated validation, reconciliation, monitoring, and alerting to ensure accurate warehouse and lakehouse loads.

• Normalize EMR, claims, clinical, operational, and flat-file data into data warehouse, analytical, and downstream reporting structures.