Job Description

The RoleAs an Analytics Engineer, you'll have the chance to write great SQL, design complex data models, collaborate with a talented team, and deliver robust data products alongside Data Architects, Data Scientists, Product Managers, and Data Engineers. You will bridge the gap between data engineering, data architecture and data analysis. Your focus will be on building robust and scalable data workflows to help business functions use internal data assets in an accessible and repeatable manner. This role offers a unique opportunity to combine expertise in architecture, data engineering, and data insights to drive innovation and value creation within our organisation.Your responsibilities:xc2xb7 Bridge Between Tech and Stakeholders: Act as intermediaries between engineering teams and stakeholders, ensuring clean, transformed datasets. Understand business requirements and translate them into technical specificationsxc2xb7 Data Transformation and Management: Manipulate raw data, making it more organised and easier to analyse. Involves creating and maintaining data pipelines and transforming data into structured formats suitable for analysis.xc2xb7 Data Quality Assurance: Develop data validation processes to ensure data integrity and accuracy.xc2xb7 Collaboration with Data Teams: Work closely with data engineers, and data architects to ensure seamless data integration across various platforms. This involves coordinating with different teams to implement data solutions that meet business needs.Developing and Maintaining Data Models: Create and maintain data models that represent complex business processes and entities, which are crucial for generating insights and supporting decision-making.Automation of Data Processes: Automate repetitive data tasks to improve the efficiency and scalability of data operations. May use scripting languages to streamline data workflows.xc2xb7 Create designs for complex projects (data products), iterating existing components or designing new components as needed.xc2xb7 Influence teams within your area of responsibility to design and build components aligned with the overall roadmap and engineering principles.xc2xb7 Collaborate within teams to contribute to the execution of the organisation's technical strategy, focusing on the development and deployment of data solutions.xc2xb7 Lead outcomes, develop stakeholder relationships, and deliver high-quality insights through data storytelling.xc2xb7 Write code following coding standards and best practices, adhering to a test-driven and behaviour-driven development approach.xc2xb7 Assist in architecting systems, designing efficient data solutions, and facilitating technical decision-making.xc2xb7 Insightful domain knowledge to business problems, recommending and implementing data-led approaches.xc2xb7 Ensure high-quality, accurate, and professional outputs that drive real business decisions.Your ProfileEssential skills/knowledge/experience:xc2xb7 Proficiency in SQL for data transformation, analysis and problem-solving.xc2xb7 Snowflake, DBT, Data Modelling, Data Vault, Data warehousing and GitHubxc2xb7 Understanding of version control systems, continuous integration pipelines, and service-oriented architecture.xc2xb7 Understanding the need for different and appropriate design techniques, such as data vault and data warehousingxc2xb7 Knowledge of Cloud technologies (AWS or Azure) and scripting languages like Pythonxc2xb7 Working knowledge of modern data architecture frameworks, understanding of Architecture & Engineeringxc2xb7 Highly numerate background with the ability to drive business change through data.xc2xb7 Excellent communication skills, capable of explaining complex information in simple terms using available documentation tools.xc2xb7 Strong problem-solving skills and attention to detail, with a curiosity to explore opportunities and solve problems logically.xc2xb7 Delivery of solutions with longevity and maintainability following the latest Agile practices.xc2xb7 Understanding of Relational (and non-relational) databases and when to use them.xc2xb7 Standards/ Principles and knowing when and how to implement frameworks and when to make suggestions for new Standards.xc2xb7 Collaboration & Communication: Strong interpersonal skills with the ability to work cross-functionally with stakeholders, engineers, and analysts.Desirable skills/knowledge/experience:Knowledge of Data Visualization Tools: Experience with tools such as MicroStrategy / Power BITerraform: Experience with Terraform and Terragrunt for infrastructure as codeGenAI: Experience with Generative AI technologies

Avance Consulting