Muhammad Syafiq Farhan
Hello, I'm

Muhammad Syafiq Farhan

Analytics Engineer

Building production-grade data pipelines, ETL systems, and regulatory reporting infrastructure. Turning raw data into reliable, scalable foundations.

Contact Me Resume
Scroll Down

About Me

Analytics Engineer with 1+ year of experience building production-grade data pipelines, ETL systems, and regulatory reporting infrastructure in the Malaysian financial services sector. Proficient in Python, PySpark, Databricks, Delta Lake, dbt, and Airflow. Experienced working in BNM-regulated environments with exposure to CCRIS reporting, enterprise Alteryx infrastructure, and data migration projects across financial institutions.

Open to Work
Kuala Lumpur, Malaysia
GMT+8

Experience

September 2025 – Present

Analytics Engineer

OR Technologies (ORTECH) • Kuala Lumpur, Malaysia

  • Migrated enterprise Alteryx Server infrastructure with zero workflow loss across 40+ production workflows, maintaining continuity of critical regulatory reporting pipelines.
  • Designed and optimised ETL pipelines supporting enterprise regulatory reporting for a BNM-regulated financial institution, improving processing reliability and auditability.
  • Resolved 20+ production data issues by root-cause analysis of pipeline logic, reducing recurring failures impacting downstream reporting cycles.
  • Rebuilt inefficient Alteryx workflows in collaboration with client stakeholders, reducing data processing time and improving system stability across reporting runs.
  • Built and maintained automated tax reporting pipelines, reducing manual workload by ~70% and enabling consistent, scheduled execution.
  • Improved pipeline documentation and logic consistency to support data governance and audit readiness under BNM compliance requirements.
October 2024 – April 2025

Artificial Intelligence Researcher

TM Research & Development (TMRND) • Selangor, Malaysia

  • Built end-to-end Python data pipelines ingesting from CSV and PostgreSQL sources, implementing structured schema validation to ensure data quality across pipeline stages.
  • Developed REST APIs using FastAPI to expose processed health metrics to downstream frontend and analytics applications.
  • Integrated AI-generated recommendations using LangChain and OpenAI API, delivering contextual, prompt-engineered outputs for staff health reporting.
  • Collaborated across frontend, backend, and database teams to deliver an integrated health analytics platform from ingestion to API-based consumption.

Education

Bachelor of Computer Science (Honours)

Data Science and Computational Intelligence

International Islamic University Malaysia (IIUM)

Graduated August 2025
🥇 1st Place - InnovaTex 2024

Final Year Project: "Deep Learning-based Evaluation of the Relationship between Mandibular Third Molar and Mandibular Canal on CBCT"

Projects

Featured Project

National Cost of Living & Salary Reality

Designed and implemented an end-to-end Medallion Architecture pipeline (Bronze / Silver / Gold) on Databricks, ingesting and unifying 7 DOSM datasets into Delta Lake to evaluate income vs inflation trends across Malaysian income percentiles.

PySpark Delta Lake Databricks Plotly Lakeview Dashboards
Impact: Reproducible, cloud-based lakehouse pipeline enabling cost-of-living analysis across 7 public datasets — live on Databricks Free Edition.
View on GitHub

National Economic Data Pipeline

Production-style Medallion Architecture pipeline ingesting from 5 Malaysian government APIs, with modular dbt transformations, Pydantic-enforced validation, Airflow orchestration, and Docker containerisation.

Python PostgreSQL dbt Airflow Docker Pydantic

Staff Health Analytics System

End-to-end health data pipeline with CSV & PostgreSQL ingestion, modular metric computation, FastAPI endpoints, and AI-generated recommendations via LangChain and OpenAI API.

Python FastAPI PostgreSQL LangChain OpenAI API

NFL Big Data Bowl 2026

Analysed 560K+ player-tracking records to explore behavioural patterns and game dynamics using large-scale sports analytics.

Python Pandas Plotly

Skills

Languages

Python SQL

Data Engineering

PySpark dbt Apache Airflow ETL Development Medallion Architecture

Platforms & Storage

Databricks PostgreSQL Delta Lake Docker BigQuery

ML & Analytics

scikit-learn SHAP Plotly

APIs & Backend

FastAPI REST APIs LangChain OpenAI API

Visualisation

Databricks AI/BI (Lakeview) Streamlit Tableau

Tools

Git GitHub Alteryx BigQuery

Certifications

CompTIA Data+ (DA0-002) CompTIA Issued: March 2026 • Expires: March 2029
Databricks Fundamentals Databricks Issued: December 2025 • Expires: December 2026
Google Advanced Data Analytics Google Issued: April 2025
Google Business Intelligence Google Issued: August 2025

Let's Connect

Got a project in mind or just want to chat? Hit me up! 🚀

Send an Email