Skip to content
View benjaminblackswan's full-sized avatar

Block or report benjaminblackswan

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
benjaminblackswan/README.md
image

imageimageimage image image image image image

👋 Benjamin Blackswan

  • 🛢 Data Engineering Manager at IHACPA.
  • 🏛 Experienced in both Federal and State Government departments.
  • 🕵🏻 AGSVA NV1 Security Clearance Holder

Experiences

Data Engineering Manager | EL1

IHACPA 📅Nov 2025 - Present 📍Sydney

  • Managing IHACPA data collections, ensuring data quality, security, and compliance across acquisition, validation, and reporting.
  • Overseeing automated data submissions and realignments within IHACPA’s secure data management system.
  • Designing and implementing scalable, cloud-based data pipelines and ML workflows meeting performance and governance standards.
  • Leading modernisation of legacy analytics by migrating to cloud-native and Gen AI–enabled platforms.
  • Providing technical guidance and facilitating workshops to support smooth transition and change management.
  • Obtained AWS Certified Data Engineer Associate

Database and ETL Administrator | ASO6

ACT Health 📅Sep 2024 - Nov 2025 📍Canberra

  • Maintained Cogito ETL and DBA processes for EPIC Systems
  • Maintained and monitored Epic Systems Cogito Platform ETL processes from operational databases to DWH.
  • Maintained the health of SQL Server databases.
  • Created and troubleshot stored procedures.
  • Maintained SQL Server ad-hoc database backups and restores.
  • Installed SQL Server instances on remote servers through virtual machines.
  • Automated routine maintenance tasks using SQL Agent jobs.
  • Assisted the ACT Health’s Data Capability team with their migration to Microsoft Fabric, including hands-on experience using data factory, Lakehouse and data warehouse.
  • Liasing, building and maintaining strong relationships with various internal and external stakeholders.
  • Used Jira and created Jira dashboards to monitor tickets and monitor team workloads.
  • Used SharePoint, OneNote and Confluence to create documentations.
  • Obtained Microsoft Fabric Data Engineer Associate and Epic Systems Cogito Systems Administration certifications.

Senior Data Analyst | ASO5

ACT Community Services Directorate 📅Apr 2023 – Sep 2024 📍Canberra

  • Built pipeline to extract data from Datalake into Power BI for visualization using Dataflows and Power Query.
  • Maintained dataflows, semantic models and workspaces in Power BI Service.
  • Automated weekly BAU tasks using Excel and Python.
  • Produced data used for annual reports for various stakeholders, both internal and external.
  • Wrote complex SQL queries in Oracle Databases and Apache Drill Datalake.
  • Used technologies and languages include Oracle SQL, T-SQL, DAX, Power Query and M, Python, SAP BusinessObjects.
  • Liaised with various stakeholders both internal and external.
  • Led Azure DevOps board for sprint planning.
  • Obtained Microsoft Power BI Data Analyst Associate, Oracle Database SQL Certified Associate and CAPM certifications.

Data Analyst | APS4

Australian Bureau of Statistics 📅Aug 2022 – Apr 2023 📍Canberra

  • Contributed to the production of Weekly Payroll Jobs and Wages statistical outputs.
  • Queried Single Touch Payroll data using AWS Athena and AWS QuickSight.
  • Wrote and tested SAS codes and data pipelines as part of the ABS’s Big Data Timely Insights (BDTI) Phase 1 project.
  • Obtained SAS Certified Specialist Base Programming and AWS Certified Cloud Practitioner certifications.

Data Entry Clerk | APS3

Australian Competition and Consumer Commission 📅Apr 2022 – Jun 2022 📍Canberra

  • Remediated datasets in Microsoft Dynamics for consumer product recalls.

Education

Current Active Certifications

AWS

Issuing Organisation Credential Name and Link Exam Code Date Awarded Date of Expiration
AWS AWS Certified Data Engineer Associate DEA-C01 2026-02-23 2029-02-23
AWS AWS Certified Cloud Practitioner CLF-C02 2023-01-02 2029-02-23

Microsoft

Issuing Organisation Credential Name and Link Exam Code Date Awarded Date of Expiration
Microsoft Fabric Data Engineer Associate DP-700 2025-06-22 2027-06-23
Microsoft Power BI Data Analyst Associate PL-300 2024-06-09 2027-06-10
Microsoft Power Platform Fundamentals PL-900 2024-03-30 Does not expire
Microsoft Azure AI Fundamentals AI-900 2024-06-19 Does not expire
Microsoft Azure Data Fundamentals DP-900 2023-07-15 Does not expire
Microsoft Azure Fundamentals AZ-900 2024-01-21 Does not expire

Other

Issuing Organisation Credential Name and Link Exam Code Date Awarded Date of Expiration
Oracle Oracle Database SQL Certified Associate 1Z0-071 2023-12-29 Does Not Expire
SAS Institute SAS Certified Specialist Base Programming A00-231 2022-12-06 Does Not Expire
Databricks Databricks Fundamentals 2025-03-22 Does not expire
Databricks Databricks AI Agents Fundamentals 2025-10-29 Does not expire
Epic Systems Cogito Systems Administrator COG380 2024-12-12 Does not expire
PMI Certified Associate in Project Management (CAPM) 2023-07-02 2026-07-02
CFI Financial Modeling & Valuation Analyst (FMVA) 2020-08-31 Does not expire

Finance

  • CFA Passed Level 2 in 2019
  • Chartered Alternative Investment Analyst Passed CAIA level I

Skills

Programming Language: T-SQL | Oracle SQL | Python | SAS | DAX | M |
Human Languages: Chinese (汉语水平考试六级)| Japanese (日本語能力試験N3)

Pinned Loading

  1. 1058_ben-gan_t-qsl_fundamentals_3e 1058_ben-gan_t-qsl_fundamentals_3e Public

    TSQL

  2. Leetcode Leetcode Public

  3. Power-BI-Icons Power-BI-Icons Public

    Forked from marclelijveld/Power-BI-Icons

    Icons (PNG and SVG) for Power BI

  4. qmk_development qmk_development Public