Data Engineer - Snowflake (USD $ Pay)

InvestM Technology LLC
Canada
$75K-$146K a year (estimated)
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.
  • 4 days ago
Related jobs
Promoted
InvestM Technology LLC
Canada

Data warehousing concepts, data modeling, metadata management. Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake. Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus. Experience in Azure...

Promoted
Shivansh Outsourcing
Canada

We are seeking a skilled Data Analyst to join our team and contribute to data-driven decision-making. The ideal candidate will have a strong analytical mindset, proficiency in data manipulation and analysis tools, and the ability to translate complex data into actionable insights. Collect, clean, an...

Promoted
Financial Resilience Institute
Canada

You will be responsible for leading advanced insight work by applying expertise in data modeling (including data cleansing, standardization, and definition to ensure study variables are suitable for analysis), data visualization, and quantitative analysis, to see beyond the numbers and help inform, ...

Promoted
Understanding Recruitment
Canada
Remote

Machine learning fundamentals and experience in industry previously. ML Engineer for Ethical AI Revolution!. ...

Promoted
Options for Employment.
Canada

Job Title: Machine Learning Engineer. Reporting to the Senior Machine Learning & AI Engineer, you will:. Take part in the development and training of advanced machine learning models, emphasizing cutting-edge algorithms such as RCNN, LSTM, and Transformers across different data modalities. Assist in...

Promoted
Hanalytica GmbH
Canada

As a Data Security Architect, you will be instrumental in safeguarding sensitive healthcare data for a leading client in the healthcare insurance sector. Collaborate with internal IT and security teams to design secure data protection architectures. Your primary focus will be on implementing encrypt...

Promoted
Quarry Consulting
Greater Ottawa Metropolitan Area, Canada

Experience of architecting the data solutions considering multiple aspects of architecture such as networking, infrastructure, and security. Role: AWS - Data Solutions Architect - Hybrid. Solution Architect on data solutioning in AWS. Data Analytics, model management, and AI using. ...

Promoted
Cella
Canada

Combine data from various sources to create comprehensive and actionable insights, transforming raw data into forms compatible with downstream sources, databases, and visualizations. Ensure data quality, completeness, accuracy, and reliability across multiple pipeline components by using queries, da...

Promoted
Binoloop
Canada

Job Title: Quality Assurance (QA) Engineer . Collaborate with cross-functional teams, including developers, product managers, and DevOps, to ensure seamless integration and delivery of high-quality software. Excellent attention to detail, with the ability to think critically and analytically about t...

Promoted
Desert Oasis staffing services
Canada

We are seeking a detail-oriented and highly organized Data Entry Executive to join our team. The ideal candidate will be responsible for updating and maintaining accurate information in our customer database. This role involves meticulous data handling to ensure the integrity and confidentiality of ...