Close
Login

Snowflake Data Engineer

Longfinch
  • San FranciscoCalifornia

  • Post Date: Jun 21, 2020


Key Skills: ETL, SSIS, Ssas, Snowflake, SnowSQL

  • Domain: Information And Communication Technology
  • Job Type: Contract - Corp-to-Corp

Job Description

 

  • Develop reports and dashboards using reporting services (SSRS), Tableau, OLAP cubes (SSAS) and relational databases
  • Multidisciplinary work supporting data pipelines, data warehouses and reporting services
  • Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures
  • Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
  • Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable, code migrations to production.
  • Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests
  • Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements
  • Use business user requirements to improve functionality (speed, performance / usability).
  • Use Big Data technologies such as Kafka, Snowflake and related technologies to store, curate, process and publish datasets for consumption by downstream business users and applications
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability etc.
  • Create solutions utilizing industry-standard dimensional models and data architecture to support business users that include data scientists, analysts and non-technical functional users
  • Respond quickly to bug fixes and enhancement requests and be able to take directions and complete tasks on-time with minimal supervision
  • Follow coding best practices-Unit testing, design/code reviews, documentation etc..

Required Skills:

  • Requires 10+years of progressive experience in developing and supporting data and reporting projects
  • Requires 7+ years of in-depth experience using ETL tools like SSIS, SnowSQL, Informatica and BI tools including SSRS, Power BI, Tableau etc
  • Requires 2+ years of using Snowflake capabilities - Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures
  • Advance knowledge of performance tuning related to ETL Development
  • Proficiency in one of the scripting languages such as Java or Python is preferred
  • Expertise in operational data stores and real-time data integration is preferred
  • Experience with Reporting and Dashboards including BI data modeling and architecture in the financial services industry is preferred
  • Must possess excellent written and oral communication skills and the ability to clearly define projects, objectives, goals, schedules and assignments.

Share this vacancy

Related Jobs

Data Engineer (spark)

Techvilla solutions, McLean, Virginia

Key Skills Cram Intelligent Evidence Gathering (IEG2), Cram Express Rules, Cram Enterprise Framework, IBM Websphere, CSS, Cram Solution Modules, Java, J2...

Senior Data Engineer - Spark, Scala, Kafka

Techvilla solutions, New York, New York

Key Skills Cram Intelligent Evidence Gathering (IEG2), Cram Express Rules, Cram Enterprise Framework, IBM Websphere, CSS, Cram Solution Modules, Java, J2...

Data Analysis using Tableau

Techvilla solutions, Reston, Virginia

Key Skills Cram Intelligent Evidence Gathering (IEG2), Cram Express Rules, Cram Enterprise Framework, IBM Websphere, CSS, Cram Solution Modules, Java, J2...

Contact Longfinch

San FranciscoCalifornia 94101