RESPONSIBILITIES

• Working closely with data engineers and BI specialists to transform data in Snowflake to meet the reporting requirement, and to feed the pre-aggregated data into the visualization tool
• Provide clean/summarized data sets to end users, modelling data in the way that can be consumed by the visualization data without further heavy transformation
• Design, development, and deployment of the analytical engineering solutions
• Collaborating with stakeholders to identify business needs and opportunities for data-driven insights.
• Staying up to date with the latest analytical engineering trends and technologies.
• Creation of a semantic layer across the presentation layers of the new Data Warehouse solution for users to have a drag and drop ability for self-service reporting.
• Cleaning, massaging, and organizing data assets for Adhoc reporting.
• Prototype new data reporting solutions.
• Mentoring other team members

EXPERIENCE

• Good understanding of how Front End visualisation tool such as Tableau and Power BI integrate with Back End data solution
• Proficiency with cloud-based data solutions, structures, theories, principles, and practices.
• Extensive experience in SQL and data ETL
• Extensive experience in writing ETL pipelines to transform data, using dbt or Python
• Proficiency with coding best practices, including version control via Git.
• Ability to implement strategies through pragmatic and realistic actions plans.
• Highly organized, structured, process driven and outcome oriented.
• A results-oriented mindset with an eye for detail and a passion for data.
• Highly competent communicator, both written and spoken.