I am a data analytics and engineering specialist with 8 years of experience across financial services, pharma consulting, and e-commerce. Over the past year I’ve been an independent consultant delivering scalable data pipelines, dbt models, and analytics infrastructure. I am now seeking a full-time role or long-term contract where I can drive deeper impact through modern data engineering and BI solutions. I design and implement robust data solutions that improve reporting reliability and business decision-making. I thrive on collaborating with stakeholders, translating complex data into actionable insights, and continuously optimizing data workflows for scale and speed.

Harsh Punjabi

I am a data analytics and engineering specialist with 8 years of experience across financial services, pharma consulting, and e-commerce. Over the past year I’ve been an independent consultant delivering scalable data pipelines, dbt models, and analytics infrastructure. I am now seeking a full-time role or long-term contract where I can drive deeper impact through modern data engineering and BI solutions. I design and implement robust data solutions that improve reporting reliability and business decision-making. I thrive on collaborating with stakeholders, translating complex data into actionable insights, and continuously optimizing data workflows for scale and speed.

Available to hire

I am a data analytics and engineering specialist with 8 years of experience across financial services, pharma consulting, and e-commerce. Over the past year I’ve been an independent consultant delivering scalable data pipelines, dbt models, and analytics infrastructure. I am now seeking a full-time role or long-term contract where I can drive deeper impact through modern data engineering and BI solutions.

I design and implement robust data solutions that improve reporting reliability and business decision-making. I thrive on collaborating with stakeholders, translating complex data into actionable insights, and continuously optimizing data workflows for scale and speed.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

English
Fluent
Hindi
Fluent
French
Beginner

Work Experience

Founder / Consultant at Halcyon Analytics
November 1, 2024 - Present
Designed and deployed team upskilling training and projects on modern data stacks using dbt, Snowflake, and automated pipelines to improve reporting reliability for SMB clients across Canada and the Middle East.
Solutions Intelligence Specialist at Essex Lake Group
March 1, 2023 - November 30, 2024
Built comprehensive BI dashboards and reporting packages using Power BI and Tableau for expense analytics at a major Canadian bank. Automated reporting pipelines, reducing manual efforts by 50% and increasing insights delivery speed. Created localized data marts and validated data quality across reporting layers. Used Databricks and PySpark for ETL orchestration and large-scale data processing. Partnered with stakeholders to define business metrics, improving executive decision-making through enhanced reporting packages.
Senior Data Engineering Analyst at Opontia
January 1, 2022 - March 31, 2023
Developed interactive Tableau dashboards for product engagement and sales KPIs across multiple business units. Used Azure Data Factory and Snowflake for scalable data warehousing and transformation. Migrated CRM data to Salesforce, maintaining data accuracy and enabling robust analytics post-migration. Enhanced customer engagement metrics and account management insights using Python and SQL-based reporting.
Senior Business Analyst at American Express
January 1, 2020 - January 31, 2022
Promoted to Senior Business Analyst (Sept 2021). Led analytics and reporting for international markets, delivering BI scorecards and insights to senior stakeholders. Designed and implemented Tableau dashboards aligned with customer behavior and product performance. Integrated AI/ML forecasting models into reports, improving strategic planning accuracy. Maintained data integrity and governed access in compliance with corporate policies.
Business Operations Associate at ZS Associates
June 1, 2018 - January 31, 2020
Developed data pipelines and Tableau dashboards using pharma sales data (IQVIA, McKesson) for client insights. Built ETL pipelines with Teradata and Informatica, optimizing reporting processes. Created modular data extracts for ad-hoc client requests, improving turnaround time by 60%.
Management Trainee (Intern) at Data Consulting Services
September 1, 2017 - June 30, 2018
Coordinated client data requirements and implemented strategy for enterprise-level software deployments. Collaborated with technical PMs to ensure successful data onboarding and configuration.
Senior Data Engineering Analyst at Opontia (Dubai, UAE)
January 1, 2022 - March 1, 2023
Developed interactive Tableau dashboards for product engagement and sales KPIs across multiple business units; leveraged Azure Data Factory and Snowflake for scalable data warehousing and transformation; migrated CRM data to Salesforce; enhanced customer engagement metrics and insights using Python and SQL-based reporting.
Management Trainee (Internship) at Tata Consultancy Services
September 1, 2017 - June 1, 2018
Coordinated client data requirements and implemented enterprise-level software rollout strategies; collaborated with technical PMs to ensure successful data onboarding and configuration.

Education

Master of Science in Data Science at Liverpool John Moores University
June 11, 2020 - July 31, 2022
Bachelor of Engineering in Industrial Engineering at Thapar University
January 1, 2013 - July 30, 2017

Qualifications

Tableau Desktop Specialist
January 11, 2030 - December 25, 2025
Alteryx Designer Core Certification
January 11, 2030 - December 25, 2025
Lean Six Sigma Green Belt
January 11, 2030 - December 25, 2025
Postgraduate Diploma in Data Science
January 11, 2030 - December 25, 2025
Tableau Desktop Specialist
January 11, 2030 - December 25, 2025
Alteryx Designer Core Certification
January 11, 2030 - December 25, 2025
Lean Six Sigma Green Belt
January 11, 2030 - December 25, 2025

Industry Experience

Financial Services, Life Sciences, Professional Services, Software & Internet, Retail, Healthcare, Media & Entertainment, Other