Technical Lead / Lead Developer -(Snowflake platform).

Technical Lead / Lead Developer -(Snowflake platform)

In a constantly changing world, we work together with our people, clients and communities to enable them to fulfill their potential to do great things. We believe that by bringing everyone together, we can solve problems using innovative technology that can create a world that is sustainable and secure. At NTT, we encourage you to remain continuously curious, as that is what keeps you fast, flexible and relevant. No two days will be the same but that is what will help you grow and realize your full potential.

The power is in your hands to do great things. It’s time to lead the change, be the authentic you, to solve difficult challenges, to set the pace of change and to unleash your potential.  

Want to be a part of our team? 

We are looking for a Technical Lead / Lead Developer -(Snowflake platform) Sydney CBD for an initial 6 months engagement. This person 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. 

Working at NTT 

  • Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view.
  • Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management
  • Proficiency in RDBMS, complex SQL, T-SQL, performance tuning and troubleshoot
  • 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

What will make you a good fit for the role? 

  • Extensive experience working as a snowflake Data Architect / Strong experience in Data warehouse, ETL, BI projects.
  • Highly important experience in at least one end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise preferably on MS SQL server.
  • Expertise in Snowflake data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
  • 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)
  • Hands-on data modelling capability for BI reporting
  • Experience with Azure data storage and management technologies such as S3 and ADLS
  • Proficiency in RDBMS, complex SQL, T-SQL, performance tuning and troubleshoot
  • Must have expertise in Azure Platform as a Service (PAAS)

Good to have:

  • Certified Snowflake cloud data warehouse Architect (Desirable).
  • Experience and understanding with BI tools like Tableau/PowerBI
  • Ability to lead and provide training to developers and analysts on Snowflake
  • Should be able to troubleshoot problems across infrastructure, platform and application domains.
  • Experience of Agile development methodologies