Job Information
Blue Cross Blue Shield of Massachusetts Senior Snowflake Database Engineer in Boston, Massachusetts
Ready to help us transform healthcare? Bring your true colors to blue.
The Senior Snowflake Database Engineer is a staff member of Data, Analytics and BI Transformation team. This role will be responsible for supporting the DAI applications and business users from all aspects of Snowflake database. Candidate must have strong experience with Snowflake platform and expertise in implementing the snowflake features and maintaining them. The primary focus is snowflake database user and objects management, usage cost analysis and recommendation, performance tuning of queries, monitoring and alert configuration, implementing data governance, exploring new capabilities, and resolving user reported issues quickly. Being able to interact with many different teams and adapting to workflow is essential for this role.
*This role is eligible for our Flex persona.
Responsibilities
Partner with IT teams & business users to provide Snowflake database technical support in developing reliable, efficient, and scalable solutions for various projects on Snowflake.
Create, monitor, and maintain role-based access controls, Virtual warehouses, Tasks, Snowpipe, Streams on Snowflake databases to support different use cases.
Monitoring Snowflake database usage includes identifying the problematic queries and working with respective team in resolving them.
Performance tuning of Snowflake queries and procedures. Recommending and documenting the best practices of Snowflake.
Explore the new capabilities of Snowflake, perform POC and implement them based on business needs.
Implementing and educate the team on the time travel and cloning features in Snowflake. Recover the lost data or objects in case of issue.
Implement data sharing /replication – cross cloud/cross region for internal/external clients.
Responsible for creating and maintaining the Snowflake technical documentation, ensuring compliance with data governance and security policies.
Lead the root cause analysis, remediation, and document efforts to effectively minimize incidents.
Implement Snowflake user /query log analysis, History capture and user email alerts configuration.
Enable data governance in Snowflake, including row/column-level data security using secure views and dynamic data masking feature.
Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.).
Required Technical Skills
Minimum 6 years of hands-on experience with Cloud databases.
Minimum 3 years of hands-on experience with Snowflake platform.
Strong experience with Snow SQL, PL/SQL and expertise in writing snowflake procedures using SQL/python/Java.
Experience with optimizing Snowflake database performance and real-time monitoring.
Experience utilizing modern methods, such as Agile, Automation and DevSecOps.
Strong database architecture, critical thinking, and problem-solving abilities.
Experience with the AWS platform Services.
Snowflake Certification is Highly desirable.
Education
Bachelor’s degree or higher in Computer Science or related field.
#LI-Hybrid
Minimum Education Requirements:
High school degree or equivalent required unless otherwise noted above
LocationBostonTime TypeFull time
Salary Range: $127,620.00 - $155,980.00
The job posting range is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee’s pay position within the salary range will be based on several factors including, but limited to, relevant education, qualifications, certifications, experience, skills, performance, shift, travel requirements, sales or revenue-based metrics, and business or organizational needs and affordability.
This job is also eligible for variable pay.
We offer comprehensive package of benefits including paid time off, medical/dental/vision insurance, 401(k), and a suite of well-being benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.
WHY Blue Cross Blue Shield of MA?
We understand that the confidence gap (https://www.theatlantic.com/magazine/archive/2014/05/the-confidence-gap/359815/) and imposter syndrome (https://www.braintreepayments.com/blog/overcoming-imposter-syndrome/) can prevent amazing candidates coming our way, so please don’t hesitate to apply. We’d love to hear from you. You might be just what we need for this role or possibly another one at Blue Cross Blue Shield of MA. The more voices we have represented and amplified in our business, the more we will all thrive, contribute, and be brilliant. We encourage you to bring us your true colors, , your perspectives, and your experiences. It’s in our differences that we will remain relentless in our pursuit to transform healthcare for ALL.
As an employer, we are committed to investing in your development and providing the necessary resources to enable your success. Learn how we are dedicated to creating an inclusive and rewarding workplace that promotes excellence and provides opportunities for employees to forge their unique career path by visiting our Company Culture (https://careers.bluecrossma.org/us/en/culturepage) page. If this sounds like something you’d like to be a part of, we’d love to hear from you. You can also join our Talent Community (https://careers.bluecrossma.org/us/en/jointalentcommunity?applyType=JTC) to stay “in the know” on all things Blue.
At Blue Cross Blue Shield of Massachusetts, we believe in wellness and that work/life balance is a key part of associate wellbeing. For more information on how we work and support that work/life balance visit our "How We Work (https://careers.bluecrossma.org/us/en/how-we-work) " Page.
Voted as the highest in member satisfaction among Massachusetts commercial health plans by JD Power , Blue Cross Blue Shield of Massachusetts is a community-focused, tax-paying, not-for-profit health plan headquartered in Boston. We have been a market leader for over 75 years, and are consistently ranked among the nation's best health plans. Our daily efforts are dedicated to effectively serving our 2.8 million members, and consistently offering security, stability, and peace of mind to both our members and associates.
Our Commitment to You
We are committed to investing in your development and providing the necessary resources to enable your success. We are dedicated to creating a refreshing and rewarding workplace that promotes excellence and provides opportunities for employees to forge their unique career path. We take pride in our diverse, community-centric, wellness-focused culture and believe every member of our team deserves to enjoy a positive work-life balance.
Blue Cross Blue Shield of Massachusetts is an Equal Employment / Affirmative Action Employer. Applicants are considered for all positions without regard to race, color, religion, sex, national origin, age, veteran status, disability, sexual orientation, gender identity or expression, or any other characteristics protected by law.
Blue Cross Blue Shield of Massachusetts will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with Blue Cross Blue Shield of Massachusetts's legal duty to furnish information.