Senior Database Engineer - Mountlake Terrace, WA

Responsibilities

• Design, build, and maintain enterprise-grade data warehouses within Microsoft Fabric (Warehouse, Lakehouse) using PySpark.
• Implement and manage data models including fact and dimension tables supporting operational and analytical workloads.
• Apply Medallion architecture (Bronze, Silver, Gold) to structure scalable, maintainable data pipelines.
• Optimize storage, query performance, and cost efficiency across Fabric and Azure environments.
• Develop, deploy, and maintain data pipelines using PySpark, SQL, and Azure-native services to facilitate development across the DevOps team.
• Engineer scalable ETL/ELT processes that ingest, transform, and load data across multiple systems.
• Own pipeline reliability, monitoring, alerting, and failure recovery in production environments.
• Troubleshoot and resolve issues across ingestion, transformation, and storage layers with minimal escalation support.
• Design and manage CI/CD pipelines in Azure DevOps for database changes, data pipelines, and data models.
• Implement version control, automated deployments, and testing strategies for all data assets.
• Maintain release processes for schema changes, stored procedures, and pipeline updates across environments.
• Write, optimize, and maintain advanced T-SQL code (stored procedures, views, functions, indexing strategies).
• Perform query tuning and performance optimization across high-volume transactional and analytical workloads.
• Design and enforce database standards, naming conventions, and documentation practices.
• Lead the Database Administrator in best practices around Data governance, reliability and security.
• Implement role-based access controls and data security aligned with HIPAA and internal policies.
• Own backup, restore, and disaster recovery strategies for databases and pipelines.
• Conduct regular validation of data integrity and pipeline outputs.
• Partner with analysts, operations, and engineering teams to translate business requirements into scalable data solutions.
• Provide technical guidance on data modeling, pipeline design, and platform best practices.
• Document systems, pipelines, and processes to ensure maintainability despite lean operational support.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Minimum 7 years of experience in database engineering, data warehousing, and data pipeline development.
• Experience with PySpark, T-SQL, and modern data engineering practices.
• Strong understanding of Azure data services and Azure DevOps.
• Proven ability to design, implement, and maintain scalable data pipelines.
• Experience with data modeling, including fact and dimension tables, and knowledge of Medallion architecture.
• Excellent problem-solving skills and ability to troubleshoot and resolve issues in production environments.
• Experience with CI/CD pipelines and version control systems.
• Advanced T-SQL skills, including stored procedures, views, functions, and indexing strategies.
• Experience with data governance, security, and reliability best practices.
• Ability to work independently and manage a team of database engineers.