200+ applicants

Company

Delta Dental of Massachusetts · 3 days ago

Senior Snowflake Database Engineer

United States

Full-time

Remote

Senior Level, Lead/Staff

10+ years exp

Maximize your interview chances

Health Care

Insider Connection @Delta Dental of Massachusetts

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Strong understanding of Snowflake architecture and operation.

Proficient in Snowflake SQL and understanding of its unique features.

Solid understanding of Snowflake features: Cloning, Data Sharing, Secure Views, caching, Warehouse sizes, and scaling.

Experience with Snowflake data loading and unloading processes.

Familiarity with Snowflake's security features and role-based access control.

Knowledge of integrating Snowflake with various data sources and BI tools.

Strong relational database and SQL skills.

Optimize databases' performance, security, and reliability within the Snowflake Data Cloud platform.

Extensive experience in Query Tuning.

Stay up to date on the latest Snowflake features and best practices.

Integrate Snowflake with various data sources and third-party tools.

Troubleshoot issues related to Snowflake implementations.

Experience in supporting/developing ETL workload.

Recommend the Snowflake best practices for management, monitoring, and optimization.

Thorough working knowledge of all tools and techniques required for area(s) of responsibility.

Address business partner issues professionally and promptly.

Propose solutions that optimize project value.

Communicate effectively with diverse audiences.

Demonstrate strong analytical and diagnostic skills.

Follow through on decisions to achieve intended results.

Execute tasks to completion and optimize resource use.

Translate business processes to technical requirements.

Ability to pivot as business needs change.

Follow through on decisions to achieve intended results.

Execute tasks to completion and optimize resource use.

Prioritize key project tasks and maintain a clear sense of priorities.

Anticipate and respond effectively to workload and resource changes.

Collaborate with management in the planning process.

Require minimal daily supervision.

Receive detailed instruction on new assignments and determines next steps with guidance.

Regularly review goals and objectives with supervisor.

Demonstrate competence in relevant job responsibilities which allows for increasing level of independence.

Ability to manage and prioritize multiple tasks.

Ability to work under pressure and meet deadlines.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Snowflake SQLSnowflake architectureQuery TuningETL workload supportData visualization toolsData governanceData qualityCloud data technologiesRelational database skillsSigmaPowerBITableauMDMLarge-scale infrastructureMultiple lines of businessDistributed systemsOperating systems conceptsDiagnostic skills

Required

BS in Computer Science or related majors.

10+ years experience designing, building and supporting large scale infrastructure in production.

Minimum of 5 years building analytics, metrics, scorecards, and data visualization tools using modern visualization tools like Sigma, PowerBI, Tableau, etc.

Expert level understanding of MDM, data housing, and integration concepts.

Experience working on major data management programs for a large-scale organization with multiple lines of business.

Experience with modern cloud data technologies like Snowflake on Azure, AWS, etc.

Experience in operationalizing data governance and data quality.

Experience designing, building, and operating large-scale distributed systems supporting stateful services.

Excellent understanding of operating systems concepts including scheduling, IO subsystem, multi-threading, memory management, networking and storage, performance and scale.

Strong hands-on skills. Can drill deep into the complex system design and implementation when needed.