Data Engineer

<h3>📋 Description</h3> • Partners Health Management is establishing a new Enterprise Data Ecosystem to modernize and unify our data platform capabilities. We are seeking a highly skilled and motivated Enterprise Data Engineer with deep expertise in Snowflake development and optimization, complemented by experience in Microsoft Azure Data Services and SQL Server. • This role will lead the design, build, and optimization of complex data pipelines, transformations, and models within Snowflake, while ensuring integration with Azure-based services and traditional SQL databases. • This role will be instrumental in enabling data-driven decisions across the organization by developing scalable, secure, and well-governed data solutions. • Data Engineering & Pipeline Development: Design, build, and maintain complex, high-performance data pipelines in Snowflake. Implement advanced Snowflake features such as tasks, streams, materialized views, and secure data sharing. Perform basic ETL/ELT operations, ensuring data integrity and quality. • Support integration between internal systems, provider networks, and external platforms. • Write and optimize SQL queries for reporting and analytics. • Data Modeling & Analytics Support: Develop and maintain scalable dimensional and data vault models in Snowflake, leveraging best practices for performance and cost optimization. Create reusable data products and views in Snowflake to support enterprise analytics in Power BI and other tools. Collaborate with analysts to prepare datasets for reporting and dashboarding. • Support documentation of data models and processes. • Data Governance & Quality: Apply basic data quality checks, validation rules, and monitoring processes. Implement Snowflake RBAC, masking policies, and data classification to ensure compliance. Support security and compliance standards, including HIPAA data handling guidelines. • DevOps & Version Control: Use Azure DevOps to manage code and deployment scripts. Implement CI/CD for Snowflake objects and pipelines using Git-based workflows. Participate in code reviews and follow best practices for clean, maintainable code. • Collaboration & Learning: Work with senior engineers to understand business requirements and translate them into technical solutions. Participate in training to expand skills in cloud data engineering. <h3>🎯 Requirements</h3> • Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field; or equivalent experience • 3-5 years of experience in data engineering, database development, or similar role (internships included) • 3+ years of hands-on experience in Snowflake development and administration • Strong SQL skills with Snowflake and SQL Server • Exposure to Databricks, or similar tools • Experience with Git, DevOps practices, and data quality frameworks • Healthcare data experience • Knowledge of Azure Data Services, Snowflake, and Power BI • Understanding of ETL/ELT concepts and cloud data architectures <h3>🏖️ Benefits</h3> • Competitive Compensation & Benefits Package! • Position eligible for Annual incentive bonus plan • Medical, dental, and vision insurance with low deductible/low cost health plan • Generous vacation and sick time accrual • 12 paid holidays • State Retirement (pension plan) • 401(k) Plan with employer match • Company paid life and disability insurance • Wellness Programs • Public Service Loan Forgiveness Qualifying Employer • See attachment for additional details.