Datacom is hiring a
Principal Consultant - Data & Analytics

Summary

The job is for a Principal Consultant role at Datacom focusing on Snowflake Data Platform solutions. The role involves leading technical delivery, gathering requirements, designing and delivering data platform solutions, providing thought leadership, data modelling, managing development life cycle, performance tuning, documentation, training, mentoring, and client communication.

Requirements

• Advanced data modelling skills (Star schema, Snowflake schema, data vault)
• Proven track-record of building EDW’s
• Advanced ETL /ELT processes design and implementation
• Advanced skills in performance tuning, query plan, query plan analysis, indexing, table partitioning
• Strong skills in cloud platforms such as Azure, AWS & GCP
• Extensive knowledge of Snowflake’s architecture and features, including security and private networking options
• 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
• Strong consultation and clients’ management skills
• Strong understanding of Agile delivery methodology
• Excellent verbal and written communications
• 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 4+ years’ experience in design, development and implementation of data solutions using Snowflake

Responsibilities

• 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 Snowflake Data platform, including related ecosystem integration for areas such as ELT, Security & Identity, Data Governance and Catalog, Reporting and Data Visualisation
• Provide overall thought leadership to our clients regarding advanced analytics, Gen AI 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

Preferred Qualifications

• Wherescape RED, 3D experience is preferred
• Minimum 3+ years’ experience in Power BI

Benefits

• A competitive salary package with annual performance reviews with the goal of taking care of and retaining the best talent
• Amazing benefits such as free Healthcare and Life Insurance from leading providers and access to online training portals to help you gain any industry certificates that you might want and we even cover the examination costs if you pass!
• Due to our strong focus and dedication towards employee development, we have the aforementioned in-house training plus our meticulous ‘career framework’, which helps map the next steps of your career and what you need to do to get to where you want to be
• Having a large scale, globally respected IT organisation on your resume will do wonders for your prospects, and with a 7000 strong workforce, there are many long-term opportunities to progress within
• A supportive and flexible working environment in up-to-date modern workplaces with a 37.5 hour working week and scope for remote or hybrid working