Full-Time
Senior Database Engineer
Mindful Support Services
Compensation Overview
$160k - $190k/yr
Mountlake Terrace, WA, USA
Hybrid
In-person at the Mountlake Terrace headquarters; hybrid work is available with tenure. Occasional travel to other locations may be required.
Bachelor's
Category
 Software Engineering (1) |
|---|
Required Skills
PowerShell
Power BI
Microsoft Azure
Python
Apache Spark
SQL
ETL
Data Engineering
Version Control
Role-based Access Control
Data Modeling
DevOps
HIPAA
Requirements
- Seven or more years of experience in a Database Engineer, Data Engineer, or similar role owning database and pipeline development in production environments.
- Seven or more years of hands-on experience with PySpark in distributed data processing environments.
- Seven or more years of experience building and maintaining data platforms in Microsoft Fabric or comparable modern data platforms such as Synapse or Databricks.
- Seven or more years of advanced T-SQL experience, including performance tuning, indexing, and complex query development.
- Seven or more years of experience managing CI/CD pipelines in Azure DevOps for database and data pipeline deployments.
- Seven or more years of experience managing or developing enterprise data warehouses, including dimensional modeling and large-scale data transformations.
- Seven or more years of experience operating and supporting high-impact production data pipelines with limited oversight or support.
- Strong proficiency in PySpark, Python, T-SQL, Microsoft Fabric, and Azure DevOps CI/CD pipelines.
- Experience with Azure data services, including Azure SQL, Fabric, Data Factory, Logic Apps, and Functions.
- Experience with ETL/ELT pipeline design patterns and data modeling methodologies such as Kimball and Medallion.
- Experience building Microsoft Power BI dashboards.
- Familiarity with DAX for analytical modeling, Python, and PowerShell.
- 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.
- A bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.
- Ability to work in person at the Mountlake Terrace headquarters, with hybrid work available after tenure.
- Ability to travel occasionally to other company locations, including out-of-state locations, and to support implementations or coordination with partners and vendors.
Responsibilities
- Design, build, and maintain enterprise-grade data warehouses within Microsoft Fabric, including Warehouse and Lakehouse, using PySpark.
- Implement and manage data models, including fact and dimension tables, for operational and analytical workloads.
- Apply Medallion architecture across Bronze, Silver, and Gold layers to structure scalable and 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.
- 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, including stored procedures, views, functions, and 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 data governance, reliability, and security best practices.
- 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.
- Manage the Database Administrator and Power BI Developer.