Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

I am Ella (Yifan) Yang, a results-driven Data Analyst with a strong finance background and two years’ experience in the Financial Services industry. I specialize in Python, SQL, and Scala, and I am adept at data processing, data modelling, and financial business analysis. I work proficiently in Agile environments, with strong problem-solving abilities, analytical skills, and effective communication. I can work independently while maintaining keen attention to detail, and I enjoy driving data solutions that inform strategic decisions and streamline business processes for stakeholders.…I am Ella (Yifan) Yang, a results-driven Data Analyst with a strong finance background and two years’ experience in the Financial Services industry. I specialize in Python, SQL, and Scala, and I am adept at data processing, data modelling, and financial business analysis. I work proficiently in Agile environments, with strong problem-solving abilities, analytical skills, and effective communication. I can work independently while maintaining keen attention to detail, and I enjoy driving data solutions that inform strategic decisions and streamline business processes for stakeholders.

Ella (Yifan) Yang

Data Analyst, Data Scientist, Web Developer, +2





I am Ella (Yifan) Yang, a results-driven Data Analyst with a strong finance background and two years’ experience in the Financial Services industry. I specialize in Python, SQL, and Scala, and I am adept at data processing, data modelling, and financial business analysis. I work proficiently in Agile environments, with strong problem-solving abilities, analytical skills, and effective communication. I can work independently while maintaining keen attention to detail, and I enjoy driving data solutions that inform strategic decisions and streamline business processes for stakeholders.…I am Ella (Yifan) Yang, a results-driven Data Analyst with a strong finance background and two years’ experience in the Financial Services industry. I specialize in Python, SQL, and Scala, and I am adept at data processing, data modelling, and financial business analysis. I work proficiently in Agile environments, with strong problem-solving abilities, analytical skills, and effective communication. I can work independently while maintaining keen attention to detail, and I enjoy driving data solutions that inform strategic decisions and streamline business processes for stakeholders.

Available to hire

I am Ella (Yifan) Yang, a results-driven Data Analyst with a strong finance background and two years’ experience in the Financial Services industry. I specialize in Python, SQL, and Scala, and I am adept at data processing, data modelling, and financial business analysis.

I work proficiently in Agile environments, with strong problem-solving abilities, analytical skills, and effective communication. I can work independently while maintaining keen attention to detail, and I enjoy driving data solutions that inform strategic decisions and streamline business processes for stakeholders.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Language

English

Fluent

Work Experience

Data Analyst at MUFG Pension & Market Services

October 1, 2025 - October 1, 2025

Developed and executed ad-hoc SQL queries to detect fraudulent activities in superannuation funds, collaborating with Suspicious Matters Reporting on threat hunting and transaction monitoring. Implemented stop-payment controls to block suspicious transactions, protecting assets of 100,000+ members during major Australian Super cybersecurity incidents. Automated Excel Power Query workflows, reducing multi-fund data processing time by 80%. Delivered daily Anti-Money Laundering de-risk decisions by building rule-based member extracts from Empirics, ensuring compliance with internal and regulatory standards. Designed Power BI dashboards mapping members' geographies to support risk assessment for Senior Business Analyst.

Associate Data Engineer at Quantexa

April 1, 2025 - April 1, 2025

Built end-to-end ETL data pipeline in Azure Databricks and AWS EMR, extracting data from ICIJ, BvD, and transactional logs in Azure Blob Storage, transforming via cleansing, standardisation, deduplication, and entity resolution, and loading into Elasticsearch via REST API to enhance fraud detection. Designed and tested investigation UI features (Explorer, Viewer, Search, Timeline, Graph Analysis) using AWS clusters. Detected 11,000 fraudulent activities for Prudential Singapore using Databricks MLflow to improve detection. Reduced fraud investigation time by 5% for Commonwealth Bank of Australia by optimizing Spark jobs in Databricks.

Data and Reporting Analyst at University of Sydney

March 1, 2023 - March 1, 2023

Retrieved and analysed university-wide staff and payroll data in Oracle SQL by querying Workday and Ascender Pay. Summarised metrics with Excel (VLOOKUP, Pivot Tables) and presented findings in PowerPoint to senior management. Built interactive Power BI dashboards to visualise recruitment and employment lifecycle trends, integrating real-time data from SQL queries. Delivered actionable insights enabling data-driven staffing decisions across faculties, maintaining 95%+ SLA compliance; partnered with three data analysts to achieve key deliverables.

Financial Analyst and CEO Assistant at Wippli

May 1, 2022 - May 1, 2022

Supported fundraising by compiling a database of global venture capital funds for targeted investor outreach. Automated investor data collection by crawling data with Python, reducing manual effort by 30%; sourced data from 300 global venture capital funds using Pitchbook, Crunchbase, and CVS. Forecasted market share growth for the design industry using Excel Solver, providing the CEO with a five-year strategic roadmap.

Consultant at Markamind

May 1, 2022 - May 1, 2022

Identified key revenue trends by visualising inter-company transactions with Python, enabling cost optimisation. Provided recommendations on economic recovery strategies based on ASX 200 index analysis, supporting clients post-pandemic. Led cross-functional team presentations, bridging concept gaps between non-technical clients and teammates to ensure alignment on project design and key objectives.

Investment Analyst at Viva Ventures Biotech POC Fund

October 1, 2021 - October 1, 2021

Orchestrated client-centered financial reports by analysing global pharmaceutical stock performance. Identified high-growth potential companies by conducting thorough assessments of operational and financial metrics, supporting $2M+ in investment decisions. Enhanced reporting accuracy by incorporating real-time market trends into financial analyses, improving the relevance of investment recommendations to CFO.