Simera Professional Key (SPK)

Troby W

Panama

Senior Data Engineer | Senior Analytics Engineer

$ 4,500/month

8 yrs exp

Senior BI & Analytics Engineer with 8+ years of SQL and 5 years delivering enterprise BI. At Estée Lauder Companies I own the path from source to dashboard: Databricks (Unity Catalog, Delta Lake) pipelines feeding star-schema Power BI semantic models, advanced DAX, and performance tuning on datasets with millions of rows. I built a Power BI scenario-simulation platform for reinvesting Net Sales into advertising, and integrated multiple external auditor datasets into a governed model. At Dell …

Skills

  • data modeling
  • ETL
  • Python
  • SQL
  • Azure DevOps
  • DataBricks
  • DAX
  • Looker
  • Power BI
  • Power Query
  • Pyspark
  • Data engineering
  • PowerBI
  • Version Control (Git, GitHub)
  • Java, SpringBoot
  • Bl and reporting tools(Power BI, Tableau, SQL
  • MSQL
  • Data Quality
  • Microsoft Power BI
  • Microsoft powerBi
  • Datawarehouse
  • Delta Lake
  • Analytics Engineering
  • Business Intelligence
  • Advanced SQL
  • Star Schema
  • Unity Catalog

Troby W

Panama

Senior Data Engineer | Senior Analytics Engineer

$ 4,500 /month

8 yrs exp

Senior BI & Analytics Engineer with 8+ years of SQL and 5 years delivering enterprise BI. At Estée Lauder Companies I own the path from source to dashboard: Databricks (Unity Catalog, Delta Lake) pipelines feeding star-schema Power BI semantic models, advanced DAX, and performance tuning on datasets with millions of rows. I built a Power BI scenario-simulation platform for reinvesting Net Sales into advertising, and integrated multiple external auditor datasets into a governed model. At Dell …

Skills

  • data modeling
  • ETL
  • Python
  • SQL
  • Azure DevOps
  • DataBricks
  • DAX
  • Looker
  • Power BI
  • Power Query
  • Pyspark
  • Data engineering
  • PowerBI
  • Version Control (Git, GitHub)
  • Java, SpringBoot
  • Bl and reporting tools(Power BI, Tableau, SQL
  • MSQL
  • Data Quality
  • Microsoft Power BI
  • Microsoft powerBi
  • Datawarehouse
  • Delta Lake
  • Analytics Engineering
  • Business Intelligence
  • Advanced SQL
  • Star Schema
  • Unity Catalog

Senior Data Engineer | Senior Analytics Engineer

Estée Lauder Companies
November 2023 - present

Own BI delivery end to end for finance, e-commerce and supply chain at a Fortune 500 company: gather requirements from business leaders, translate them into KPIs and dashboard specifications, and build star-schema Power BI semantic models on Databricks (Unity Catalog, Delta Lake). Implemented Row-Level Security for 100+ users and administer Power BI Service (workspaces, apps, deployment pipelines, gateways, refresh schedules) to keep published reporting secure, governed and consistent. Optimized performance across the stack: cut a legacy distribution report's refresh time by 60%+ through model redesign, DAX optimization and refresh rework, and cut the global transportation dashboard's refresh by ~80% by moving SharePoint file ingestion into PySpark and Unity Catalog. Built a scenario-simulation dashboard using what-if and field parameters so leaders can model reinvesting Net Sales into advertising, and documented models with per-report business glossaries.

Senior Business Intelligence Analyst

Dell Technologies
October 2021 - October 2023

Delivered Power BI dashboards end to end for marketing: ran requirements sessions with non-technical stakeholders and defined KPIs (leads, opportunities, revenue) for the Dell Technologies World and Dell Technologies Forum events. Built star-schema models with Power Query (M) and DAX. Integrated Salesforce and Allocadia data through APIs using Python, Apache Airflow and SQL stored procedures. Led the data-quality initiative: identified gaps between API and extract data, built reconciliation and validation checks, and eliminated recurring pipeline failures. Served as technical lead across multiple BI initiatives, coordinating stakeholder alignment and on-time delivery.

Analyst Backend Developer

Banco General
April 2021 - September 2021

Built Java Spring Boot microservices and SQL data integrations at Panama's leading bank, including the Yappy P2P payment platform and the Payment Hub. Connected legacy systems to a service-oriented architecture for transaction-critical financial processing.

Backend Developer

Banco General
November 2018 - April 2021

Built Java Spring Boot microservices and SQL data integrations at Panama's leading bank, including the Yappy P2P payment platform and the Payment Hub. Connected legacy systems to a service-oriented architecture for transaction-critical financial processing.

Technician Trainee

Banco General
May 2018 - November 2018

Built Java Spring Boot microservices and SQL data integrations at Panama's leading bank, including the Yappy P2P payment platform and the Payment Hub. Connected legacy systems to a service-oriented architecture for transaction-critical financial processing.

Smart Scores

Communication
80
Role Fit
90
Adaptability
80
Problem-solving
80

Smart Skills

beta