Snowflake Data Engineer.

  • Company:
    Www.chandlermacleod.com
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    1 day ago
  • Category:
    Engineering

One of our government clients is looking for a Snowflake Data Engineer to join their team to be based @ Sydney CBD for an initial contract till March 21 + possible extension. My client is looking for a Lead Snowflake Data Engineer, who will be responsible to plan, design, develop and maintain the data architecture, data models and standards for various Data Integration & Data warehouse projects in Snowflake.

Essential Skills

  • Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
  • Must have total 10+ yrs. in IT and 3+ years’ experience working as a snowflake Data Architect and 5+ years in Data warehouse, ETL, BI projects.
  • Must have experience at least two end to end implementation of Snowflake cloud data warehouse
  • Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
  • Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
  • Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
  • Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
  • Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
  • Experience with data security and data access controls and design
  • Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management
  • Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
  • Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
  • Expertise in Azure Platform as a Service (PAAS).
  • Certified Snowflake cloud data warehouse Architect (Desirable).
  • Should be able to troubleshoot problems across infrastructure, platform and application domains.
  • Must have experience of Agile development methodologies

    If you think this is right role for you , please apply to Sunil Kompiyil with your updated CV in word format .

IT & Digital

Data & Business Analyst

  • Canberra
  • N/A
  • Contract

Our client, one of the Federal Gov. department is looking for dynamic Data and Business Analyst Candidate ne… More info Apply

IT & Digital

Data and Integrations Specialist

  • New South Wales
  • super
  • Contract

One of our clients is looking for a Data and Integrations Specialist to join their team to be based in South West … More info Apply

IT & Digital

Lead Analyst

  • New South Wales
  • AU$120000 – AU$150000 per annum
  • Full Time

POSITION PURPOSE The Lead Analyst – Innovation and Technology is responsible to analyse, identify, de… More info Apply

IT & Digital

Maintenance CMMS Analyst

  • South Australia
  • N/A
  • Full Time

Chandler Macleod is partnering with candidates and clients alike to unleash their full potential. Successfully wor… More info Apply