s
shahidthaika

Shahid T

@shahidthaika
5,0(1)

Senior Data Engineer and BI Specialist

Émirats Arabes Unis
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
Senior data engineer and BI specialist with 17+ years of experience building scalable data warehouses, reliable pipelines, and high-impact reporting solutions across advertising, retail, real estate, and supply chain. Brings strong business understanding across marketing and sales, finance, and logistics, with a strong track record of modernising legacy data environments and optimising large-scale workloads.... Plus d’infos

Compétences

s
shahidthaika
Shahid T
hors ligne • 
Temps de réponse moyen de 1 heure

Voir mes services

Conception & Optimisation
I will optimize one slow sql query for better performance
5,0(1)
Conception & Optimisation
I will optimise the performance of your mysql database

Expérience professionnelle

Senior Data Engineer

Not Found • Temps plein

Jun 2022 - Mar 20263 yrs 9 mos

• Built 70+ of the 110 Airflow DAGs maintained on GCP Composer for a digital advertising company. • Built Apache Beam / Dataflow pipelines for terabyte-scale workloads and streaming Pub/Sub data. • Evaluated and prototyped multiple BI platforms before driving adoption of Holistics as a cost-effective semantic-layer alternative to Looker for scalable enterprise reporting. • Designed and developed a new star-schema data model in BigQuery, replacing a legacy architecture of hundreds of report-specific tables with about 40 tables and simplifying maintenance. • Redesigned and optimised legacy ETL queries to reduce processing overhead, pipeline failures, and backfill requirements, and implemented built-in error checks and alerts to improve pipeline reliability. • Migrated 30+ legacy Looker Studio reports to Holistics, consolidating standalone reports into a centralised, drill-through reporting experience that improved navigation and usability. • Designed analytical solutions on my own initiative that enabled richer user analysis, expanded segment targeting and predictive modelling population by 6x, and supported adaptation to new PII regulations.

Boston_Consulting Group

Power BI Consultant

Boston Consulting Group

Sep 2021 - Jun 20229 mos

• Built Power BI reports that were embedded in a broader UI to compare predicted vs actual pricing strategy for a retailer with 9,000+ stores. Data sourced from Azure Data Lake and PostgreSQL. • Benchmarked and optimised a DirectQuery Power BI model and the SQL views powering it, improving load times through reduced query count, caching, and tuning of underlying queries. • Integrated and aggregated data from CSVs, Spark outputs, application data, and modelling outputs.

1 Avis
5,0

(1)
(0)
(0)
(0)
(0)
Détails de la notation
  • Niveau de communication avec le freelance
    5
  • Qualité de la livraison
    5
  • Valeur de la livraison
    5
1 à 1 avis sur 1
Trier par
Les plus pertinents
    H

    hafeel89

    AE

    Émirats Arabes Unis

    5

    The quert works fine. Thank you for the exceptional support.

    Jusqu’à 50 $US

    Prix

    1 jour

    Durée

    gig

    Conception & Optimisation

    Utile?
    Oui
    Non