Senior Data Engineer

At Brighton/Suncrest Hospice our goal is to change the expectation of hospice care in your area by providing exceptional care and service to our patients.  This is achieved by allocating the resources to increase our staff to patient ratios, thereby increasing clinical visits while lowering clinician caseloads. We are proud to be a Community Health Accreditation Partner (CHAP) certified hospice. If you have a commitment to providing the highest quality of care to patients and their families, we would like to hear from you!

• Actual Work/Life Balance
• Competitive Pay
• Benefits Package including Medical, Dental, and Vision insurance
• Paid Time Off
• 401k plan with employer match and 100% vesting after 90 days of employment
• A culture with an emphasis on appreciating and valuing the team member
• The opportunity to be part of a rapidly growing national company, with possible position upgrades

We are looking for an innovative and technically skilled Senior Data Engineer to design and optimize modern data ecosystems. In this role, you will focus on crafting scalable data warehouse solutions, streamlining data pipelines, and driving data reliability through automation and governance. A deep understanding of Agile SDLC principles and CI/CD pipelines for validating and deploying data workflows is essential.

Key Responsibilities:

• Data Warehouse Design: Architect and implement scalable, high-performance data warehouse solutions using Snowflake, leveraging advanced techniques such as Star and Snowflake schemas.
• Modern Data Pipelines: Develop, manage, and optimize ELT workflows using tools like DBT, Python, and MS SQL Server to ensure efficient data ingestion, transformation, and orchestration.
• CI/CD Enablement: Design and deploy automated CI/CD pipelines to validate, test, and release data changes seamlessly.
• Agile SDLC Practices: Implement Agile development practices to ensure data solutions are iterative, reliable, and aligned with business goals.
• Data Curation: Build curated, analysis-ready datasets in Snowflake for advanced analytics, machine learning, and reporting purposes.
• Data Governance: Establish robust governance strategies, emphasizing data quality, security, and compliance with modern standards.
• Performance Tuning: Proactively monitor and enhance the performance of data pipelines and warehouse queries to handle large-scale datasets efficiently.
• Collaboration: Partner with cross-functional teams to understand business needs and deliver actionable, high-quality data solutions.
• Documentation: Maintain transparent, up-to-date documentation for data pipelines, workflows, governance practices, and CI/CD processes.

• Expert-level experience with Snowflake, including performance optimization, cost management, and architecture patterns.
• Proficiency in Python, with a focus on developing modular, reusable, and maintainable data workflows.
• Strong experience with DBT (Data Build Tool) for building and testing transformation logic.
• Advanced knowledge of MS SQL Server, including query performance tuning and database optimization.
• Proven expertise in modern CI/CD pipelines, including tools for automating data validation and deployment.
• Deep understanding of Agile SDLC methodologies and their application to data engineering projects.
• Familiarity with cloud-native environments and best practices for handling data securely and efficiently.
• Solid foundation in data governance frameworks, focusing on reliability, lineage, and compliance.