Site: Mass General Brigham Incorporated
Mass General Brigham relies on a wide range of professionals including doctors nurses business people tech experts researchers and systems analysts to advance our mission. As a not-for-profit we support patient care research teaching and community service striving to provide exceptional care. We believe that high-performing teams drive groundbreaking medical discoveries and invite all applicants to join us and experience what it means to be part of Mass General Brigham.
Job Summary
The Mass General Brigham Digital Data Platform team is seeking a SnowFlake role will employ deep technical expertise in SnowFlake to implement and support the Cloud EDW platform and related technology will require working collaboratively in an Agile operating environment alongside fellow Data Platform teams as well as other technical and non-technical teams across Mass General Brigham.
The Snowflake Adminshould excel and provide critical expertise in several key operations areas but also be willing to grow and contribute in an Agile environment to ensure consistent delivery and support to th Cloud EDW and overall Cloud Data Platform.
At Mass General Brigham Digital our mission is to maximize strategic clinical and operational value through technology for patients care teams researchers and employees. We believe digital health is crucial for enhancing healthcare equity efficiency personalization and precision.
We are committed to increasing value and continuously improving quality with an inclusive approach and invite you to join us in this important work. Digital initiatives are a strategic priority and we are collaboratively transforming Mass General Brigham through innovation.
Department Summary:
The Snowflake Platform Admin will be part of the Mass General Brigham Digital Data Platform Team. This team comprises groups focused on platform architecture and administration data architecture data engineering data governance and end-user support. We collaborate with other MGB teams to design develop validate maintain and support the MGB Digital Platform and various analytic data assets and products.
- Bachelors Degree Computer Science required or Bachelors Degree Related Field of Study required
- Experience can be considered and reviewed in lieu of a degree
- Related experience in programming data engineering and/or building cloud technologies and architecture 5-7 years required
Knowledge Skills and Abilities
- Proven experience as a Snowflake Architect or similar role with hands-on experience in architecting and implementing data solutions on the Snowflake cloud data platform.
- Experience in administering and supporting Snowflake
- Possesses strong hands-on experience with SQL and 5 years of experience with data warehouse and analytics architecture
- 3 years of hands-on Snowflake experience in development modeling and architecture.
- Experience with Python programming skill.
- Proven understanding of traditional analytics projects such as data warehouses data lakes master data management system integrations etc.
- Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing technologies(DBT).
- Experience in Platform Security Administration and OKTA Integration
- Strong communication and collaboration skills with both technical and non-technical teams
- Strong attention to detail well organized problem solver and able to set priorities
- Proficient in various cloud technologies including virtualization containerization and orchestration technologies.
- Strong analytical skills to identify patterns and insights from cloud-based infrastructure and system performance data.
- Excellent communication and collaboration skills to work effectively with other members.
- Excellent critical thinking and analytical skills.
- Certification with Snowflake
- Programming skill in Python
- Experience working in environments where Agile Scrum DevOps and Production support practices are used
- Ability to learn new technology and build repeatable solutions/processes
- Ability to anticipate project roadblocks and have mitigation plans in-hand
- Knowledge and experience working with relational databases for data querying.
Additional Job Details (if applicable)
Working Conditions
- This position is Hybrid Onsite Flexible weekly and/or monthly onsite required to equal 4 or more days per month onsite
- Must be open for department and business meetings needs onsite
- M-F Eastern Business Hours required
- When present on-site in Sommerville standard office environment
- Remote working days require stable secure quiet compliant work area
- The noise level on-site in the work environment is quiet to moderate
- This position may require occasional local travel to Mass General Brigham sites vendors and/or conferences
- While performing the duties of this job the employee is frequently required to sit; talk; or hear; use hands to finger; handle; or feel; reach with hands and arms. The employee is occasionally required to stand; walk; and stoop; kneel; or crouch. The employee must frequently lift and/or move up to 5 pounds and occasionally lift and/or move up to 20 pounds.
- Specific vision abilities required by this job include close vision distance vision and depth perception.
- The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
Hybrid
399 Revolution Drive
40
Regular
Day (United States of America)
Pay Range
$92102.40 - $134056.00/Annual
Grade
7
At Mass General Brigham we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive and any offer extended will take into account your skills relevant experience if applicable education certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however it does not encompass all elements contributing to your total compensation package. In addition to competitive base pay we offer comprehensive benefits career advancement opportunities differentials premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.
Mass General Brigham Incorporated is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religious creed national origin sex age gender identity disability sexual orientation military service genetic information and/or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process to perform essential job functions and to receive other benefits and privileges of employment. To ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973 the Vietnam Veterans Readjustment Act of 1974 and Title I of the Americans with Disabilities Act of 1990 applicants who require accommodation in the job application process may contact Human Resources at .
Mass General Brigham Competency Framework
At Mass General Brigham our competency framework defines what effective leadership looks like by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance make hiring decisions identify development needs mobilize employees across our system and establish a strong talent pipeline.
Required Experience:
Unclear Seniority