Open to opportunities

Surabhi Chauhan

@surabhichauhan

Message

Analytic Engineer designing reliable data models, SQL transformations, and analytics pipelines.

Germany

Message

What I'm looking for

I’m looking for a role where I design reliable data models and analytics pipelines, automate reporting workflows, and partner with stakeholders to improve data quality and support better business decisions.

I’m an Analytic Engineer focused on designing and maintaining analytics data models that power product performance reporting and downstream BI consumption. At BASF Services Europe GmbH, I built and optimized data models using DAX, Power Query, and SQL-based transformations to improve data accuracy, refresh reliability, and performance.

I integrate Databricks and SQL sources with Power BI for end-to-end analytics and reporting workflows, implementing Row-Level Security (RLS), workspace roles, and dataset refresh schedules to strengthen data security and governance. Previously, as an Analytic Consultant at Ultimate Kronos Group (UKG), I configured and deployed UKG Analytics & DataHub, delivered best-practice visualizations and dashboards, and led data validation, reconciliation, and root-cause analysis to support self-service analytics.

Experience

Work history, roles, and key accomplishments

Current

Analytic Engineer

Current

BASF Services Europe GmbH

Apr 2024 - Present (2 years)

Architected and maintained analytics data models for product performance reporting and downstream BI consumption, optimizing DAX, Power Query, and SQL-based transformations to improve data accuracy, refresh reliability, and performance. Implemented Row-Level Security (RLS) and automated Power BI/Databricks workflows (refresh, access requests, notifications) while delivering SQL root-cause analysis

Data Modeling DAX Power Query SQL Power BI Databricks Power Automate Python NumPy GitHub

Analytic Consultant

Ultimate Kronos Group

Feb 2022 - Jul 2023 (1 year 5 months)

Gathered requirements and supported data quality validation through reconciliation and root-cause analysis, then delivered analytics solutions using UKG Analytics and Data Hub. Designed and deployed best-practice visualizations and dashboards with SQL/Databricks, performing risk analysis and ensuring maintainable, well-documented models for self-service analytics.

SQL Databricks Data Validation Reconciliations Root Cause Analysis Dashboarding Git

Analytic Consultant

Ultimate Kronos Group (UKG)

Feb 2022 - Jul 2023 (1 year 5 months)

Configured and deployed UKG Analytics and DataHub products and delivered best-practice dashboards and visualization layers for self-service analytics. Led requirement gathering and risk analysis, and performed data validation/reconciliation and root-cause analysis while managing a 5–6 person team.

SQL Databricks DataHub Dashboarding Data Validation Root Cause Analysis Data Modeling Git

Senior Software Engineer

Microsoft

Jun 2015 - Jan 2022 (6 years 7 months)

Developed and executed ETL processes to move data between on-premises and cloud environments using Azure Data Factory, and supported service operation planning for migrations and reporting. Created reports for month-end productivity, calculated data quality metrics, and delivered interactive dashboards and actionable insights based on business requirements.

Azure Data Factory ETL Data Pipelines Data Modeling Power BI Data Quality Reporting Service Operations Documentation

Senior Software Engineer

HCL Technologies

Jun 2015 - Jan 2022 (6 years 7 months)

Developed and performed ETL processes moving data between on-prem and cloud environments using Azure Data Factory while supporting service operations and global customer reporting. Built interactive dashboards, handled customer requirement analysis and scoping, and created month-end productivity and data-quality insight reports for quarterly reviews.