Overview
Principal Consultant - Data and Analytics
This range is provided by Datacom. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range: A$140,000.00/yr - A$180,000.00/yr
What You'll Do
* Working with clients (business users) to gather, clarify requirements and business rules by running workshops with stakeholders.
* Lead the technical architecture, design and delivery for a new Data platform.
* Provide overall thought leadership to our clients regarding data profiling and integration recommendations.
* Data modelling (relational and dimensional like star schema and Snowflake schema).
* 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.
* Mentor developers, acting as an SME in data warehouse architecture and data modelling.
What You'll Bring
* Advanced data modelling skills (Star schema, Snowflake schema, data vault).
* Proven track-record of building EDWs.
* Advanced ETL / ELT processes design and implementation.
* Advanced skills in performance tuning, query plan analysis, indexing, and table partitioning.
* Strong skills in cloud platforms such as Azure, AWS & GCP.
* Strong skills in Azure Data Factory and data Flows and Azure SQL data platform.
* Extensive knowledge of Databricks architecture and features.
* Proven track-record in the design, development and implementation of data solutions using Databricks.
* Extensive knowledge of Snowflake's architecture and features.
* Proven track-record in the design, development and implementation of data solutions using Snowflake.
* Experience in data ingestion tools such as Apache Kafka, Informatica, AWS Glue, Azure Event Hubs, Fivetran, Matillion, DBT and Coalesce.
* Experience in Apache Airflow.
* Strong consultation and client management skills.
* Strong understanding of Agile delivery methodology.
* Excellent verbal and written communications.
Required Skills And Qualifications
* Bachelor's degree in Computer Science or related discipline.
* Minimum 8+ years' experience in EDW design and implementation.
* Minimum 8+ years' experience in ETL architecting and design.
* Minimum 8+ years' experience in data modelling (Star schema & Snowflake schema).
* Minimum 5+ years' experience in semantic layer development.
* Minimum 5+ years' experience in reporting and visualization tools.
* Advanced skills in Microsoft BI stack.
* Minimum 8+ years' experience in various Microsoft SQL Server technologies including SSIS, SSRS, SSAS.
* Minimum 4+ years' experience in design, development and implementation of data solutions using Snowflake.
* Minimum 4+ years' experience in design, development and implementation of data solutions using Databricks.
* Wherescape RED, 3D experience is preferred.
* Minimum 3+ years' experience in Power BI.
* Advanced skills in Azure, Fabric, and Snowflake pipelines, with experience in tools such as Azure Data Factory, Coalesce, Matillion, dbt, and Fivetran.
* Strong skills in data platform implementation, configuration, performance and cost management tuning (i.e. Azure, Fabric, Snowflake).
Why join us
Datacom is one of Australia and New Zealand's largest suppliers of Information Technology professional services. We maintain a dynamic, agile, small business feel and value our people for creating Datacom's unique culture and energy.
We care about our people and provide perks such as social events, remote working, flexi-hours and professional development courses. You will be recognised and valued for your contributions in a collegial, flat-structured environment.
#J-18808-Ljbffr