$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Junior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Engineer
Awais Khan
,
London, United Kingdom
Experience
Other titles
Skills
I'm offering
Experienced in building automated data pipelines and dashboards.
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2020 - 2020
job
Analytics Engineer
Tasman Analytics.
• Building the backend data infrastructure for clients.
• Regular communication with clients and internal team (agile framework) to discuss deliverables, blockers, and fixes.
• Data collection using Snowplow, APIs, and Python-built web-scrapers.
• Building ETL processes using Python scripts and automating through bash scripts and cron jobs.
• Delivering clean, structured, documented, and performant production level SQL data models using dbt.
• Use of Git issues and rebase on focused branches for a clean commit history with small but regular PRs.
• Developing modular, reusable LookML dashboards and models.
Tech Stack: BigQuery, Compute Engine, Linux, Bash, Python (Pandas, Numpy, Requests), dbt, Looker, Snowplow, Git/GitHub
• Regular communication with clients and internal team (agile framework) to discuss deliverables, blockers, and fixes.
• Data collection using Snowplow, APIs, and Python-built web-scrapers.
• Building ETL processes using Python scripts and automating through bash scripts and cron jobs.
• Delivering clean, structured, documented, and performant production level SQL data models using dbt.
• Use of Git issues and rebase on focused branches for a clean commit history with small but regular PRs.
• Developing modular, reusable LookML dashboards and models.
Tech Stack: BigQuery, Compute Engine, Linux, Bash, Python (Pandas, Numpy, Requests), dbt, Looker, Snowplow, Git/GitHub
Analytics, SnowPlow, Backend, Processes, Framework, Production, Web, Data collection, Infrastructure, Sql, Github, Bash, ETL, Agile, Linux, Backend, Git, Python
2019 - 2020
freelance
Business Reporting Analyst
Sony Interactive Entertainment.
(Contractor)
• Big data analysis using Snowflake and Python to understand the Digital @ Retail market (i.e. Playstation vouchers).
• Machine learning modelling such as k-means clustering (Sci-kit Learn) and regression analysis.
• Preparing and presenting analytical reports through PowerPoint decks for senior stakeholders and global summits -
catering to the audience to provide the most suitable data visualisations.
• Investigating discrepancies between data sources and identifying lost revenue.
• Developed Python scripts using Pandas, Numpy & Dask to collate big data sources and manipulate data frames.
• Implementing ETL processes and automating periodic data pulls using Apache Airflow and GitHub.
• Updating senior stakeholders with progress made on deliverables and providing updated timescales along with any
blockers (also keeping line manager updated multiple times a week).
• Documenting new processes and writing up requirements for other teams necessary for development.
• Identified and retrieved $ millions of lost revenues with processes in place to retrieve $ millions more.
Tech Stack: Python (Pandas, Numpy, Dask, Sci-kit Learn), Snowflake, PowerQuery, GitHub, Excel, Tableau, Airflow,
MicroStrategy, Qlikview, Shell
• Big data analysis using Snowflake and Python to understand the Digital @ Retail market (i.e. Playstation vouchers).
• Machine learning modelling such as k-means clustering (Sci-kit Learn) and regression analysis.
• Preparing and presenting analytical reports through PowerPoint decks for senior stakeholders and global summits -
catering to the audience to provide the most suitable data visualisations.
• Investigating discrepancies between data sources and identifying lost revenue.
• Developed Python scripts using Pandas, Numpy & Dask to collate big data sources and manipulate data frames.
• Implementing ETL processes and automating periodic data pulls using Apache Airflow and GitHub.
• Updating senior stakeholders with progress made on deliverables and providing updated timescales along with any
blockers (also keeping line manager updated multiple times a week).
• Documenting new processes and writing up requirements for other teams necessary for development.
• Identified and retrieved $ millions of lost revenues with processes in place to retrieve $ millions more.
Tech Stack: Python (Pandas, Numpy, Dask, Sci-kit Learn), Snowflake, PowerQuery, GitHub, Excel, Tableau, Airflow,
MicroStrategy, Qlikview, Shell
Tableau, Manager, UP, Big Data Analysis, Processes, Development, Analyst, Presenting, Github, Apache, Excel, ETL, Big Data, Retail, Powerpoint, Machine learning, Writing, Data Analysis, Python
2018 - 2019
job
Reconciliations Analyst
Pockit Limited.
• Collecting, cleaning, and manipulating large amounts of data using Excel (VBA included) and Python.
• Automating reconciliation processes using Numpy and Pandas (80% of job) - reduced processing times by factor of five.
• Analysis on customer spend pattern and identifying groups of spenders and their primary merchants.
• Writing and maintaining Python scripts to production level - clean, reproducible, and well-tested.
• Working with third-party companies to ensure delivery of data is consistent and accurate.
• Keeping CFO and line manager updated with progress and blockers of monthly reconciliations.
• Compiled detailed documentation for complete reconciliations process.
• Process is much more streamlined with Finance department month-end processes and documentation & automation
means lower barriers to entry to complete the reconciliations.
Tech Stack: Python (Pandas, Numpy, Selenium), Java, Excel (core functions and VBA scripts), T-SQL, Power BI
• Automating reconciliation processes using Numpy and Pandas (80% of job) - reduced processing times by factor of five.
• Analysis on customer spend pattern and identifying groups of spenders and their primary merchants.
• Writing and maintaining Python scripts to production level - clean, reproducible, and well-tested.
• Working with third-party companies to ensure delivery of data is consistent and accurate.
• Keeping CFO and line manager updated with progress and blockers of monthly reconciliations.
• Compiled detailed documentation for complete reconciliations process.
• Process is much more streamlined with Finance department month-end processes and documentation & automation
means lower barriers to entry to complete the reconciliations.
Tech Stack: Python (Pandas, Numpy, Selenium), Java, Excel (core functions and VBA scripts), T-SQL, Power BI
T-SQL, Customer, Manager, Processes, Processing, Production, BEE, Power, Analyst, CFO, Excel, Finance, VBA, Automation, Selenium, Power BI, Writing, Java, Python, Sql
My education
2015
-
2017
Imperial College London
MSc, Quantum Fields and Fundamental Forces
MSc, Quantum Fields and Fundamental Forces
Awais' reviews
Awais has not received any reviews on Worksome.
Contact Awais Khan
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Awais directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark