Data Engineer - Snowflake (US Hybrid)

InvestM Technology LLC
Canada
Full-time

We are seeking a Senior Snowflake Developer. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.

Location :

San Francisco, CA (Hybrid)

Visa Status :

Canadian Citizens eligible for TN visa only

Responsibilities :

  • Design and implement features for identity and access management.
  • Implement novel query optimization, major security competencies with encryption.
  • Solve performance issues and scalability issues in the system.
  • Create, test, and implement enterprise-level apps with Snowflake.
  • Data warehousing concepts, data modeling, metadata management

Mandatory Qualifications :

  • 10 years of experience in database development
  • 4 years of experience in Snowflake development and administration
  • Bachelors degree or 7 yrs hands-on experience

Preferred Qualifications :

  • Knowledge of SQL language and cloud-based technologies
  • Profound knowledge and hands-on experience in Snowflake Platform Architecture.
  • Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.
  • Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake.
  • Extensive experience in T-SQL stored procedures and complex query development.
  • Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans.
  • Experience with productionized data ingestion and processing pipelines using Snow SQL
  • Strong understanding of CI / CD workflows, unit testing and integration testing, and deployment patterns.
  • Strong ability in documenting design solutions effectively.
  • Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway.
  • Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.
  • Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is a plus.
  • 5 hours ago
Related jobs
InvestM Technology LLC
Canada

Data warehousing concepts, data modeling, metadata management. Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus. Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data manag...

Promoted
freelance.ca
Canada

Participating in projects such as SAS migration to SAS Viya, Data Science Platform decommissioning, CL and PL datahub (bringing all data sources together), or supporting one of our existing AI families in data ingestion/consumption. Able to thrive in a diverse team of Business Architects, Solution A...

360insights
Canada
Remote

The Business Systems Analyst is passionate about understanding our client’s business needs and translating them into actionable solutions that create value rapidly. Strong business process and business logic mindset. Past experience with statement of work (SOW), business requirements definition (BRD...

Vidyard
Remote, Canada
Remote

Data Science at Vidyard is aimed at using data, analytics, and sciences to improve various aspects of our business. You are comfortable working with large data sets and analyzing complex data with SQL and other tools such as AWS Redshift, DBT and Cube. Research and Development team, leading experime...

Babylist
Canada

Babylist is currently seeking a dynamic and enthusiastic Staff Software Engineer to join our recently established Health team. In your capacity as a Staff Software Engineer, collaboration with our product and design teams will be integral to shaping new product initiatives and implementing flexible,...

Conspicuous
Canada

Dynamics 365 CE Business Analyst. This role demands a highly skilled analyst with a deep understanding of D365 CE, who can bridge business needs with technical solutions and ensure efficient, customer-focused system implementations. Business Analyst in Dynamics 365 CE, with proven expertise in compl...

StackAdapt
Canada

We are searching for a talented Data Scientist to join our team as we continue to expand our data science efforts. This position requires a technically strong person with a strong programming and Data Science background, who is also willing to work with internal company teams to understand the busin...

HCLTech
Canada

The Sr Cloud Engineer/Sr Site Reliability Engineer is a member of Cloud Operations Automation team and responsible for the reliability, security and efficiency of Change Healthcare’s cloud environments and products that comprise Enterprise Imaging solutions. Job Title - Senior Cloud Engineer. The en...

Quantiphi
Canada

Develop conceptual, logical and physical data models with associated metadata including data lineage and technical data definitions. Provide research, high-level design and estimates for data transformation and data integration from source applications to end-user BI solutions. Provide production su...

Okta, Inc.
Canada

Our Workforce and Customer Identity Clouds enable secure yet flexible access, authentication, and automation that transforms how people move through the digital world, putting Identity at the heart of business security and growth. Okta’s Customer Identity Cloud (CIC), powered by Auth0 technology, is...