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.
  • 3 hours ago
Related jobs
Promoted
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
VTRAC Consulting Corporation (WBE)
Canada

DevOps Engineer (Kafka, Rancher), Attention: samz@vtrac. DevOps Engineer (Kafka, Rancher). DevOps pipelines, Terraform, and data pipelines. ...

Promoted
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...

Promoted
LNine Consulting
Canada

We're looking for a talented and passionate Machine Learning Engineer to join our dynamic team and help shape the future of government services. As a Machine Learning Engineer at our company, you will play a crucial role in developing and implementing advanced ML solutions for our federal government...

Promoted
FinTop Consulting
Canada

The Lead Engineer is looking to hire their first DevOps Engineer, who can take charge and help improve their infrastructure. They currently use a lot of managed services on a cloud platform provider so there's not much they have to do in terms of DevOps and that’s where the lead manages that himself...

Promoted
HCLTech
Canada

To act as a liaison between the business and technical teams, analyze and document business requirements, suggest design solutions to the assigned project team as per the business requirement. To understand the business requirements and map it to functional specifications. To participate and facilit...

Promoted
Morgan McKinley
Canada

Experience with large datasets and the ability to translate data into actionable insights. This role will focus on providing data-driven insights related to salary structures, market trends, pay equity, and compensation program effectiveness. Analyze compensation data, including salary structures, j...

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...

Xerox
Canada

Cloud Services: In-depth knowledge of cloud infrastructure and services, including AWS, Azure, or Google Cloud Platform. Today, Xerox scientists and engineers are continuing our legacy of innovation with disruptive technologies in digital transformation, augmented reality, robotic process automation...

Snaphunt
Canada

You have at least 3 years experience, ideally within a Data Analyst or Data Engineer role. Demonstrated experience working with large and complex data sets as well as experience analyzing volumes of data. Developing scripts to process structured and unstructured data. Recommending, developing and im...