Data & Analytics Senior Consultant (Snowflake)

Our Purpose

Here at Datacom we connect people and technology in order to solve challenges, create opportunities and discover new possibilities for the communities we live in.

Our Team

The Data and Analytics team are a progressive group of diverse and creative individuals with a deep love for all things data related. They build platforms and solutions that are leading edge and at the forefront of the technology curve. A close knit and fun team embedded within our rapidly growing Professional Services division, and part of the wider Datacom ecosystem.

About the Role

As a Senior Consultant, you will lead the technical delivery of large-scale data platform and BI solutions. You will be asked to design, implement and own the delivery of robust Data Platform solutions and end-to-end components. The Senior Consultant works closely with principal consultants, practice leads, project managers, and client stakeholders and teams. This is a client facing role, so you'll need to be an excellent communicator and good with people.

What You'll Do

• Working with clients (businesses users) to gather, clarify requirements and business rules by running workshops with stakeholders.
• Contribute to the technical architecture, design and delivery for a new data platforms.
• Provide overall thought leadership to our clients regarding data profiling and integration recommendations.
• Data modelling (relational and dimensional modelling)
• Managing development life cycle using various source code management tools.
• Ability to perform performance tuning and optimisation on new and/or existing data warehouse solutions.
• Provide detailed documentation, end user training and knowledge-transfer services to customers, and internal teams.

Skills and requirements

• Excellent consultation and stakeholder management skills.
• Excellent verbal and written communication skills.
• Proven track-record of designing and building modern data platforms
• Advanced skills in Azure, Fabric, and Snowflake pipelines, with experience in tools such as Azure Data Factory, Coalesce, Matillion, dbt, Fivetran, and Airflow (preferred)
• Advanced ETL/ELT process design and implementation.
• Advanced skills in SQL performance tuning, query plan, query plan analysis, indexing, table partitioning.
• Must have strong skills and experience in Python development in the data space and commonly used data analysis and processing related python packages.
• Strong skills in cloud platforms such as Azure and AWS.
• Strong skills in data platform implementation, configuration, performance and cost management tuning (i.e. Azure, Fabric, Snowflake)
• Strong skills in Power BI and semantic data modelling.

Required Skills and Qualifications

• Bachelor's degree in Computer Science or related discipline
• Snowpro and Coalesce certified or Microsoft Azure/Fabric certified data engineer
• Experience in EDW design and implementation.
• Experience in ETL architecting and design.
• Experience in data modelling (Star schema & Snowflake schema)
• Experience in reporting and visualization tools.
• Experience in Power BI

Our office is at BGC Taguig and we have hybrid work setup(Once to Twice a week) and a Morning work schedule and we promote Work-Life balance, and an APAC focus means no graveyard shifts

We also provide exciting perks such as spotter fees, HMO with Free 4 Dependents, Leave credits, Performance bonuses, and a work-life balance environment

Why Join Us Here at Datacom? 

Datacom is one of Australia and New Zealand's largest suppliers of Information Technology professional services. We have managed to maintain a dynamic, agile, small business feel that is often diluted in larger organisations of our size. It's our people that give Datacom its unique culture and energy that you can feel from the moment you meet with us. 

We care about our people and provide a range of perks such as social events, chill-out spaces, and professional development courses to name a few. You'll have the opportunity to learn, develop your career, connect and bring your true self to work. You will be recognised and valued for your contributions and be able to do your work in a collegial, flat-structured environment. 

We operate at the forefront of technology to help Australia and New Zealand's largest enterprise organisations explore possibilities and solve their greatest challenges, so you will never run out of interesting new challenges and opportunities. 

We want Datacom to be an inclusive and welcoming workplace for everyone and take pride in the steps we have taken and continue to take to make our environment fun and friendly, and our people feel supported.