Snowflake Data Engineer / Architect
This job does not exist anymore.
Try running a new search or browse our vacancies.
Or fill in the form below to receive job alerts.
| Job Type | Contract |
| Area | Anywhere, UK Remote or Hybrid working |
| Sector | IT/Technology |
| Start Date | ASAP |
| Advertiser | EllisKnight International |
| Job Ref | 3823 |
| Job Views | 110 |
- Description
Job Duties:
- Develop data models to ensure that the data objects provided are completely and accurately represented.
- Maintain functional roles, users, security groups, warehouses, and databases.
- Document application source system databases, data requirements, development of database objects and partnering with IT to promote objects and ETL processes to the production environment.
- Design and migrate existing relational databases into Snowflake environment.
- Write and modify complex SnowSQL queries, stored procedures, views, and triggers in addition to the development of other Snowflake database objects.
- Design, develop, test, implement and manage complex ETL/ELT processes from multiple sources
- Create and maintain documentation related to applications, data sources, and ETL movement within the Pubs data environment.
- Create and promote the use of data assets, including the management of data catalog for reference.
- Develop and execute test plans
- Setup of Snowflake and/or Google BigQuery environment from scratch
Job Requirements:
- B.S. in Information Systems or similar IT or Business field
- Expertise in multiple databases, data warehousing, database design and modeling with in-depth knowledge of Snowflake databases, Schema and Table structures
- Significant hands-on experience building and working with data warehouses, lakes, marts, pipelines, and providing reporting or analytical services.
- Experience in SnowSQL and Snowpipe.
- Exposure to Time travel, Snow Tasks, and data movement between Snowflake and other RDMS
- Experience with cloud infrastructure (e.g., AWS EC2, S3, Lambda or equivalent services from Azure or Google).
- Experience with or strong understanding of ETL/ELT and workflow tools like Pentaho, Talend etc.
- Experience with Python, Spark
- Experience with Agile and other software development methodologies.
- Knowledge of JIRA, Confluence and familiarity with Sprint and Kanban
- Excellent verbal and written communication skills
- Excellent organizational skills and customer service skills
Preferred but not required:
- Familiarity with dashboarding and visualization tools such as Qlik Sense, Tableau or Power BI
- Experience in machine learning/data science platforms and services like Snowpark, Sagemaker, Domino, TensorFlow, etc.
