Lead Database Engineer - Snowflake

Overview

  

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.  

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance. 
 



Pay and Benefits:

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee). 

An a Lead Database Engineering for Snowflake, you will lead with strategic vision to strengthen our data foundation, enhance performance, and drive innovation across the enterprise.  By aligning technology initiatives with business objectives you will enable scale, secure high-impact data solutions that accelerate decision making, empower teams, and advance our data strategy with Snowflake in the data cloud ecosystem. 

Qualifications:

• Minimum of 6 years of related experience
• Bachelor's degree preferred or equivalent experience
• Proven experience with Snowflake data platform administration. A current SnowPro Core certification is strongly desired. More advanced Snowflake platform certifications are ideal. 
• Experience with SQL programming and/or relational database administration on mainstream database platforms (Snowflake, Oracle, MS SQL Server, MySQL, PostgreSQL). 
• Proficiency in Python and Bash script development on Linux.
• Basic proficiency with Terraform and Ansible.
• Experience with CI/CD toolchains including GitLab, Bitbucket and Jenkins.
• Basic AWS IaaS administration skills: experience with Azure or Google Cloud Platform is acceptable.
• Basic Linux system administration skills
• Familiar with Agile/Scrum project management methodology and associated workflow tools such as JIRA
• Familiar with ITSM processes (Incident, Problem, Change, Service Request fulfillment) and supporting tools such as ServiceNow.

• Snowflake integration experience with enterprise Identity and Access Management (IAM) technologies such as  (Azure Active Directory) or Hashicorp Vault 
• Experience integrating Snowflake monitoring features with observability tools such as Splunk, Grafana, or Dynatrace.
• Experience integrating Snowflake with ITSM tools such as ServiceNow or CMDB tools like CloudAware.
• Experience with Linux batch scheduling software such as Autosys or equivalent. 
• Familiar with FinOps concepts and Snowflake cost/performance optimization strategies. 
• Experience with Business Analytics applications such as Power BI, Looker or Quicksight
• Experience with the usage and administration of Snowpark container services.
• Experience with the usage and administration of Snowpipe stream analytics. 
• Experience with the usage and administration of Snowflake Cortex AI services.  

• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Ability to identify, isolate, and assess relevant factors in the feature development process and understand their implications.
• The capacity to make sound, timely, and effective decisions, even under pressure or in uncertain situations.
• Possess the highest standards of professional conduct, ownership, and behavior.
• Initiative - The ability to take action in the absence of specific direction.
• Curiosity.
• Love for data processing, databases, data analytics and deriving insights from data 
• Package and integrate new Snowflake features into a common data platform for use by multiple application development teams.
• Integrate Snowflake features into the Snowflake security architecture.
• Validate non-functional requirements, including disaster recovery and backup for Snowflake objects.
• Automate Snowflake environment deployment and administration using SQL, Python or Bash utilities.
• Collaborate with Application Development teams to ensure seamless integration and deployment of Snowflake platform capabilities.
• Utilize CI/CD tools such as GitLab, Bitbucket, and Jenkins to manage the configuration and execution of Snowflake utilities.
• Perform Snowflake and AWS administration tasks using Terraform or Ansible automation tools.
• Provide escalated Snowflake support to DTCC’s Cloud Data Operations team.
• Develop Snowflake platform feature documentation, training materials and job aids for our operations staff.
• Support Disaster Recovery and Operational Rotation activities to validate the effectiveness of DTCC’s business continuity planning.
• Provide Snowflake implementation and integration advice and consulting to application development teams.
• Report defects and problems to Snowflake and work with DTCC’s Snowflake account team to validate and implement suggested fixes.