Database Engineer Lead - Mountlake Terrace, WA

About Mindful Support Services

We are an business-to-business support service for independent mental healthcare businesses, which helps providers service a growing client base. We provide administrative and organizational services to simplify the processes of lead‑generation, marketing, billing, and collecting payments from patients and insurers. Our teams currently support over 2,000 independent mental health providers, who serve over 25,000 clients per week across 20+ locations throughout 5 states, as well as virtually via Telehealth.

We have built the Mindful Therapy Group brand from the ground up with years of dedication to solving the complex processes of the mental healthcare landscape in innovative ways, creating a platform geared toward growth, and working to meet our mission of creating improved access to high quality mental healthcare.

The Database Engineer Team Lead is responsible for the design, development pipelines, and operational ownership of Mindful Support Services’ data platform, including databases, data warehouses, and Azure-based data pipelines. This role operates with a high degree of autonomy yet will manage the Database Administrator as well as the Power BI Developer to lead the architecture, implementation, and ongoing management of data systems that support both operational workflows and analytics.

In this role, you will own end-to-end data movement and transformation across Microsoft Fabric and Azure environments, leveraging PySpark, T‑SQL, and modern data engineering practices. You will manage two team members supporting this work. You will be responsible for building resilient data pipelines, maintaining CI/CD processes in Azure Dev Ops, and ensuring that high‑impact data workflows continue to operate reliably with minimal direct support.

This is a hands‑on engineering and leadership role suited for someone comfortable operating independently in a production‑critical environment, where pipelines and databases are core to daily business operations.

This is a full‑time, in‑person role based out of our Mountlake Terrace Headquarters, with occasional travel to other MSS locations as needed and Hybrid work schedule available with tenure.

• 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 Dev Ops 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 Dev Ops 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…