Database Engineer Lead - Mountlake Terrace, WA at Mindful Support Services

Mountlake Terrace, Washington, United States -

Full Time

Start Date

Immediate

Expiry Date

07 Aug, 26

Salary

135000.0

Posted On

09 May, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

PySpark, T-SQL, Microsoft Fabric, Azure DevOps, Data Modeling, ETL/ELT, CI/CD, Azure SQL, PowerBI, Python, Medallion Architecture, Dimensional Modeling, Performance Tuning, Data Governance, HIPAA Compliance, Leadership

Industry

Mental Health Care

Description

About Mindful Support Services We are a 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. About the Role 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 PowerBI 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 in this work. You will be responsible for building resilient data pipelines, maintaining CI/CD processes in Azure DevOps, 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. Responsibilities Data Platform & Warehouse Engineering 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. Pipeline Development & Operations 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. CI/CD & DevOps for Data 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. Database Engineering (T-SQL Focused) 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. Data Governance, Security & Reliability 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. Cross-Functional Collaboration 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. Work Environment This is an in-person position based at our Mountlake Terrace Headquarters. The role requires occasional travel to other Mindful Support Services locations, including out-of-state travel when necessary. Additional off-site travel may be required to support system implementations or coordination with partners and vendors. The responsibilities listed above are not exhaustive and may evolve over time with or without formal notice. Qualifications Education Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field, or equivalent practical experience. Required Experience 5+ years of experience in a Database Engineer, Data Engineer, or similar role owning database and pipeline development in production environments. 3+ years of hands-on experience working with PySpark in distributed data processing environments. 3+ years of experience building and maintaining data platforms in Microsoft Fabric or comparable modern data platforms (e.g., Synapse, Databricks). 5+ years of advanced T-SQL experience, including performance tuning, indexing, and complex query development. 3+ years of experience managing CI/CD pipelines in Azure DevOps (ADO) for database and data pipeline deployments. 3+ years of experience managing or developing enterprise data warehouses, including dimensional modeling and large-scale data transformations. 2+ years of experience operating and supporting high-impact production data pipelines with limited oversight or support. Technical Skills Strong proficiency in: PySpark & Python (required) T-SQL (required) Microsoft Fabric (required) Azure DevOps (CI/CD pipelines) Experience with: Azure data services (Azure SQL, Fabric, Data Factory, Logic Apps, Functions) ETL/ELT pipeline design patterns Data modeling methodologies (Kimball, Medallion) Microsoft PowerBI dashboard builder Familiarity with: DAX for analytical modeling Scripting languages (Python, PowerShell) Core Competencies Ability to independently manage and prioritize work in a high-impact, low-support environment. Ability to oversee a small team in following best practices in database management. Strong troubleshooting and root-cause analysis skills across complex data systems. High attention to detail in data integrity, performance, and system reliability. Clear communication skills for both technical and non-technical stakeholders. Compensation and Benefits: 75% employer covered Health, Dental & Vision benefits plan 401(k) savings plan with employer matching upon eligibility 8 paid holidays 15 PTO days accrued annually Professional and career development opportunities Compensation evaluated with opportunities for advancement We are an equal opportunity employer with a progressive workplace based on teamwork, integrity, and customer service. We are committed to cultivating the long-term professional potential of our team. Applicants from all fields are encouraged to apply. Background check required. Come join a strong team making an impact in the service world of mental health! It is a conflict of interest for an employee of Mindful Support Services to be a current client of Mindful Therapy Group. We request that individuals who are receiving clinical services at Mindful Therapy Group wait until their care is discontinued before beginning employment. Job Type: Full-time Pay: $120,000 - $135,000 per year

Responsibilities

Lead the design, development, and operational ownership of the data platform, including warehouses and Azure-based pipelines. Manage a small team of database and PowerBI developers to ensure reliable data movement and transformation across Microsoft Fabric.