Senior Data & Analytics Engineer

About the role

Datacom is looking for a Senior Data & Analytics Consultant/Engineer to lead the technical delivery of large-scale data platform and BI solutions. You will design, implement and own the delivery of robust data platform solutions and end-to-end components, working closely with principal consultants, practice leads, project managers and client stakeholders. This is a client-facing role requiring strong communication and people skills.

Key responsibilities

• Work with clients to gather and clarify requirements and business rules through stakeholder workshops
• Provide thought leadership to clients on data profiling and integration recommendations
• Design, build and maintain scalable data pipelines and data platform solutions
• Develop and optimize data models, transformations and database objects in Snowflake
• Troubleshoot data pipeline issues and ensure timely delivery of critical business data
• Build, support and enhance workflow orchestration with Apache Airflow
• Contribute to CI/CD and DevOps practices to improve deployment reliability
• Perform performance tuning on data warehouse solutions
• Deliver documentation, end-user training and knowledge transfer to customers and internal teams
• Manage the development lifecycle using source code management tools

Required profile

• Bachelor's degree in Computer Science or a related discipline
• Excellent verbal and written communication skills with technical and non-technical stakeholders
• Proven track record of designing and building modern data platforms in a Data Engineering or Analytics Engineering capacity
• 5+ years of experience developing data engineering solutions with Python and SQL, including automation, data processing and integration with Snowflake and Apache Airflow
• 5+ years of experience using Apache Airflow to build, schedule, monitor and support data pipelines
• 5+ years of experience designing enterprise data warehouse solutions, including dimensional modelling (star and snowflake schemas) and Slowly Changing Dimensions (SCD)
• Experience with CI/CD practices and deployment pipelines

Required skills

• Hands-on experience with Snowflake database objects (tables, views, schemas, stages, stored procedures)
• Hands-on experience with Apache Airflow
• Familiarity with cloud platforms such as Azure, AWS or Google Cloud Platform
• Nice to have: dbt experience, Azure, Fabric and Snowflake pipeline skills, and certifications in SnowPro, Coalesce, Azure or Fabric
• Nice to have: hands-on experience with Power BI or other BI and visualization tools

What we offer

• Learning and development opportunities, parental leave and wellbeing support
• Hybrid work setup twice a week, flexible schedule and no graveyard shifts
• Spotter fees, HMO with free coverage for 4 dependents, leave credits, performance bonuses and a work-life balance environment