Datacom

Data & Analytics Principal Consultant – Microsoft Fabric

Datacom

full-time

Posted on:

Location Type: Hybrid

Location: Auckland • 🇳🇿 New Zealand

Visit company website
✨ AI Apply
Apply

Job Level

Lead

Tech Stack

AWSAzureCloudETLGoogle Cloud PlatformInformaticaMatillionMS SQL ServerSQLSSISVault

About the role

  • Collaborate with sales and account teams to shape proposals and solution designs during pre-sales engagements.
  • Lead client presentations and solution walkthroughs to articulate value and differentiation.
  • Identify opportunities for upselling and expanding service offerings within existing accounts.
  • Facilitate stakeholder workshops to gather and clarify business requirements
  • Lead the technical architecture, design and delivery for new Modern Data Platform solutions.
  • Provide overall thought leadership to our clients regarding data profiling and integration recommendations.
  • Provide thought leadership around the effective us of AI in the data platform landscape.
  • Data modelling (relational and dimensional and Snowflake schema)
  • Perform performance tuning/optimisation, and feature auditson data platform solutions.
  • Provide detailed documentation, end user training and knowledge-transfer services to clients, and internal teams.
  • Mentor developers, acting as an SME in data platform/warehouse architectures and data modelling

Requirements

  • Proven ability to engage with senior stakeholders and influence buying decisions.
  • Experience in pre-sales solutioning, proposal development, and client presentations.
  • Commercial acumen and ability to align technical solutions with business value.
  • Strong consultation and client management skills.
  • Advanced skills and a proven track-record of building data solutions in cloud platforms such as Azure, AWS & GCP
  • Advanced skills in one or more data platforms such Azure, Fabric, Snowflake and Databricks
  • Advanced ETL/ELT process design and implementation with tools such as Synapse Analytics, Azure/Fabric Data Factory, Snowflake, Coalesce, Fivetran, Matillion, dbt and AWS Glue
  • Advanced data modelling skills (Star schema, Snowflake schema, data vault)
  • Advanced skills in performance tuning, query plan, query plan analysis, indexing, table partitioning.
  • Experience using Informatica IDMC or on-prem solutions
  • 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 8+ years’ experience in various Microsoft SQL server technologies including SSIS, SSRS, SQL Server Analysis Services
  • Minimum 5+ years’ experience in semantic layer development.
  • Minimum 3+ years’ experience in Power BI

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data modellingETLELTperformance tuningquery plan analysisindexingtable partitioningcloud platformsdata profilingdata integration
Soft skills
stakeholder engagementinfluenceconsultationclient managementthought leadershipmentoringcommunicationcollaborationpresentation skillscommercial acumen
Certifications
Bachelor's degree in Computer Science