Available to hire
I’m Arun Bajaj, a data engineering and BI specialist with 20+ years of experience driving end-to-end ETL and analytics solutions. I thrive on turning messy data into clear insights, working across the SDLC in Agile environments, and delivering scalable data platforms on both on-prem and cloud (Azure and AWS).
My career spans finance, travel, and government sectors, taking on roles from BI Developer and Data Modeler to Lead Developer and Module Lead. I’m proficient in data migration, profiling, warehousing (Kimball and Data Vault 2.0), and building dashboards and reports that empower decision-makers.
Skills
Language
English
Fluent
Work Experience
Senior Data Engineer & PowerBI Developer at Department of Justice & Attorney General, Brisbane
June 1, 2024 - PresentLed migration of the 'Compliance' subject area data to Dynamics 365 using Azure Synapse pipelines. Built a metadata-driven automated testing framework for migration validation. Developed scalable data ingestion and transformation pipelines in Azure Data Factory for Dynamics 365 data. Implemented API-based data integrations leveraging Microsoft Graph API for governed data access across Microsoft 365 services. Designed performance-optimized pipelines to load dimensional data into the enterprise Data Warehouse. Worked with Parquet and diverse data sources (structured, semi-structured, unstructured) within Azure Synapse and Databricks. Delivering interactive Power BI dashboards and reports based on dimensional models to support business insights.
Senior Data Engineer at Brisbane City Council
June 1, 2024 - October 16, 2025Implemented data integration processes for diverse Source Systems (D365, SAP) using predefined load patterns to optimize ETL into the Data Warehouse. Tailored pipelines to onboard new source systems, ensuring data quality and efficient processing. Engineered presentation views to support reporting demands and developed Power BI reporting suites for multiple business personas. Actively contributed to System testing and User Acceptance Testing, ensuring reliability and accuracy of implemented data solutions and supporting production releases.
Senior BI Developer at Laing O’Rourke
March 1, 2023 - October 16, 2025Collaborated with global architects to frame the initial design of the Global Data Platform. Documented entities in scope for financial reporting, produced source-to-target mappings, and captured technical business rules. Ingested data from source systems into the Data Lake, created interface data agreement documents, and supported on-prem BAU ETL work with root-cause analysis of failures. Contributed to data lake/Delta Lake architecture and delivered documentation to aid deployments.
Senior BI/DW Developer at QSuper
June 1, 2022 - October 16, 2025Led greenfield initiatives like Insurance Transformation and Data & Platform Management. Designed and developed Insurance/Super Data Warehouse, expanded data acquisition framework to ingest multiple source systems (Fineos, Acurity, customer interactions/audit logs). Implemented orchestration pipelines in Azure Data Factory, used Spark SQL/Python and T-SQL for ETL to load dimensional models, and performed end-to-end reconciliation from source to Data Warehouse. Active in agile ceremonies, releases, and UAT.
BI Analyst / Developer at Bank of Queensland
November 1, 2018 - October 16, 2025Gathered requirements and drafted documents (Technical Requirement/Design, Data Mapping, Data Flow). Designed and developed Data Marts, wrote T-SQL procedures/functions for ETL and Data Vault loading, and built SSIS packages for orchestration. Developed SSRS reports and supported SIT/UAT and production deployments.
Data Warehouse Analyst at Flight Centre
January 1, 2018 - October 16, 2025Analyzed Travel data structures and developed data models for Data Warehouse (Topdeck and Backroads). Built ETL for staging and transformation, created automated data reconciliation tests, and delivered reporting solutions using SSRS and Power BI. Led database/migration activities to AWS and ensured stability for 500+ users while standardizing development processes and training developers.
Data Migration Developer at RACQ
December 1, 2015 - October 16, 2025Analyzed and extracted COGEN legacy data for historical ETL. Profiled data and defined business rules for ETL/Data Migration. Designed and developed migration/transformation logic with PL/SQL, created data mapping worksheets, and built reconciliation reports. Implemented automated utPLSQL unit tests and End-to-End reconciliation suites. Drove CI/CD for the migration project and supported agile development cycles.
AVP/ Analyst Market Risk IT at Barclays Capital – Singapore
June 1, 2012 - October 16, 2025Elicited requirements from Market Risk professionals; enhanced the data model to support various asset classes. Staged data using SQL Loader, implemented business logic with PL/SQL, and maintained system performance. Led POCs, performed data modeling revisions, and collaborated with frontend teams to expose APIs. Contributed to releases and provided architecture-level testing and support.
AVP/ Analyst Market Risk IT at Barclays Technology Centre India (BTCI)
January 1, 2015 - October 16, 2025Continued responsibilities from the Singapore chapter with focus on data modeling, ETL development, performance tuning, archiving strategies, and leadership in releases. Mentored junior developers and coordinated cross-location collaboration to ensure robust Market Risk IT solutions.
Application Developer at JP Morgan Chase Services India Pvt Limited
June 1, 2010 - October 16, 2025Collaborated with Business Analysts to understand requirements, planned tests, and developed interfaces and views for applications. Managed batch job scheduling, provided backend support, and contributed to deployment activities. Mentored peers and assisted QA during integration testing.
Software Engineer at Fidelity Investments, India
December 1, 2009 - October 16, 2025Developed data models and PLSQL procedures; built Unix scripts, ETL workflows, and autosys scheduling. Coordinated across offshore/onsite teams, analyzed data issues, created test plans, and supported deployments while ensuring data quality and reliability.
Technical Associate at Tech Mahindra
October 1, 2006 - October 16, 2025Led a team of 8 in analysis, design, development, and maintenance for telecom billing. Conducted impact analysis, developed PL/SQL changes, created test scenarios, and coordinated data flows with Geneva teams. Managed resources and mentored team members, contributing to releases and customer interactions.
Education
Post Graduate Diploma in Business Management (PGDBM) at ICFAI
September 1, 2008 - October 16, 2025Bachelor of Engineering (BE) - Computer Science at Nagpur University
April 1, 2000 - October 16, 2025Qualifications
Databricks Platform Administrator
December 1, 2022 - October 16, 2025Microsoft Certified Azure AI Fundamentals
September 1, 2022 - October 16, 2025Certified Data Vault 2.0 Practitioner
January 1, 2017 - October 16, 2025PowerBI Training from Wardy IT
January 1, 2017 - October 16, 2025Delivering Agile Projects using Scrum
January 1, 2014 - October 16, 2025Big Data / Hadoop (Cloudera Distribution)
January 1, 2014 - October 16, 2025MongoDB Certification (M101P)
January 1, 2014 - October 16, 2025Oracle Database 10g: SQL Tuning
January 1, 2006 - October 16, 2025Sun Certified Core JAVA Developer
January 1, 2006 - October 16, 2025Mutual Fund / Fund Management training
January 1, 2007 - October 16, 2025Industry Experience
Financial Services, Travel & Hospitality, Professional Services, Government, Telecommunications
Skills
Hire a Data Analyst
We have the best data analyst experts on Twine. Hire a data analyst in Brisbane today.