- Philips (Contract)BI DEVELOPER/SQL ENGINEERJanuary 2023 - July 2023 (6 months)Provider of cutting-edge healthcare and consumer electronics solutions January – July 2023• Performed data normalisation (3NF) on legacy databases to elimi nate redundancy and improve data integrity.• Migrated from SSIS to metadata-driven Python ETL pipelines, optimis ing performance and flexibility.• Designed and deployed data pipelines on cloud platforms (Ter raform, Ansible), optimising for both performance and cost.• Led a proof of concept (PoC) for using DBT, Airflow, and Great Expec tations to establish best practices for scalable ETL.• Implemented an Azure SQL warehouse for the sales team which im
- Trust Alliance GroupDATA ENGINEERAugust 2023 - Today (1 year and 9 months)United KingdomWorking as a Data Engineer with an innovative B2B2C provider of dispute resolution-as-a-service solutions- Migrating the current Azure VM storage data estate to Microsoft Fabric to shift control of data logic and responsibility to business users and data owners, improving agility and alignment with business needs.- Used Azure data tools to design, implement, release, and maintain highly scalable ETL pipelines for efficient and accurate data collection, cleansing, validation, and auditing.- Implemented a metadata approach in the current design architecture to help with data analysis, auditing, cataloguing, governance, RLS and OLS handling.- Automated the configuration, support, and maintenance of 24x7 data pipelines using Azure Data Factory, for continuous delivery of external and internal datasets.- Developed internal APIs (e.g. Flask Python API) to support automateddata collection, thereby streamlining processes across core internal systems, regulators, and government websites.- Created a Data Lineage solution that visualised the lifecycle of data points, saving 4+ hours in project planning and reducing duplicate work.- Collaborated with the data science team to deploy a predictive ML model, improving case outcomes by 3x in similar cases.- Developed ELT pipelines using Python, Airflow, and Docker on Azure, automating over 2+ hours of daily manual reporting.- Implemented delta live tables on Databricks to improve data processing.- Experimented with GitHub Actions, Azure DevOps, Jenkins for CI/CD, to address shortcomings in the current deployment tool (Slingshot), then settled on implementing an Azure DevOps CI/CD solution.
- Unity Bank PlcANALYTICS ENGINEERJanuary 2021 - June 2023 (2 years and 5 months)Leading Nigerian bank providing customer-driven banking solutions January 2021 – June 2023customers.
Welcome to Alex's freelance profile!
Alex A.
- Suggested rate€475 / day
- Experience3-7 years
- Response rate100%
- Response time1 hour