We are seeking a Database Engineer Lead to design, develop pipelines, and operational ownership of Mindful Support Services' data platform. The role requires hands-on engineering and leadership skills, with a focus on data movement and transformation across Microsoft Fabric and Azure environments.
Requirements
- 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.
- 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.
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
