About the Company Our client is a global organisation operating within the insurance sector, with a strong presence across Australia and international markets. Their business focuses on delivering tailored solutions to a diverse client base, supported by a collaborative and data-driven culture. About the Role This is a Data Analyst role responsible for data quality, ingestion, transformation, and analytics enablement within a complex business environment. The role focuses on building robust data pipelines, ensuring high data quality, and delivering insightful visualisations to support strategic decision-making. You will work closely with cross-functional stakeholders to design scalable data solutions, automate processes, and provide actionable insights. Key Responsibilities Design, develop, and maintain data pipelines using Python to transform raw data into clean, structured, analytics-ready datasets. Write and optimise SQL queries to extract, transform, and load data from multiple source systems using DBT. Build and maintain Power BI dashboards using live connections for business-critical reporting and insights. Develop and enhance data models in Power BI, including combining datasets and creating calculated columns and measures using DAX. Implement data quality frameworks, including automated validation checks and error logging at the data table layer. Use Excel and Power Query to connect to source systems, and link workbooks effectively (hands-on experience required). Support integration of new data sources (e.g., CRM and actuarial systems) into the data ecosystem. Contribute to automation of reporting processes, including regulatory and financial reporting. Skills & Requirements Core Technical Skills (Essential) Strong hands-on development experience with: Python (data processing, scripting, pipeline development) SQL (data extraction, transformation, optimisation) VBA (building modules and automation tools) Advanced Excel, including Power Query (data connections, transformations, workbook linking) Power BI expertise (essential): Data modelling and dataset design Combining datasets in the Power BI modeller Writing DAX for calculated columns and measures Building effective, business-focused visualisations Data & Platform Experience Experience with data modelling concepts such as star schema, fact/dimension tables, and medallion architecture. Familiarity with modern data transformation tools (e.g., DBT) is advantageous. Exposure to Snowflake (or similar cloud data platforms) is desirable; experience preferred as the platform will be implemented in the near future. Engineering & Development Practices Working knowledge of Git for version control, including: Managing source code Creating and reviewing pull requests Collaborating in a team-based development environment Understanding of CI/CD and DevOps principles, with the ability to work within structured deployment pipelines. Experience & Qualifications Minimum 3 years' experience in a similar data-focused role. Proven experience working with Python, SQL, VBA, and Power Query in a professional environment. Experience delivering end-to-end data solutions, from ingestion through to visualisation. Industry experience in insurance or financial services is advantageous. Key Competencies Strong problem-solving and analytical thinking skills. Ability to communicate technical concepts to non-technical stakeholders. Proactive and self-sufficient, with the ability to work both independently and collaboratively. Strong attention to detail, particularly around data quality and validation. If this sounds like you, please apply below. Note: Only Australian citizens and permanent residents are eligible for this role.