Greater Toronto Area, Canada
I’m Palkin Kaur, a Data Engineer with 5 years of experience delivering data-driven solutions in the legal and transportation sectors. I specialize in building scalable ETL pipelines, designing star schema models, and developing interactive Power BI dashboards that transform complex datasets into actionable insights. In my role at Helm360, I optimized reporting for law firms by implementing data governance, documenting metadata lineage, and streamlining pipelines—reducing processing time by 60% and improving billing accuracy by 30%. I also developed dashboards with advanced DAX and Power Query, applied Row-Level Security for secure access, and automated manual reporting, increasing adoption and efficiency across teams. I have hands-on experience integrating SQL databases, and cloud platforms like Snowflake and Azure Data Warehouses using SSIS, ADF. I ensure data quality, consistency, and reliability to support strategic decision-making. Earlier, I migrated legacy databases to Azure SQL, designed complex ETL processes, and delivered timely reporting solutions that met business needs and compliance standards. I’m passionate about leveraging data to solve business problems, whether it’s through automation, analytics, or insightful reporting. I continuously refine my skills in Power BI, SQL, and Azure technologies to drive measurable impact and help organizations make informed decisions. Let’s connect if you share a passion for data-driven insights and innovative BI solutions.
Solved challenges with fragmented, inconsistent, and siloed data across legal and transportation projects. Profiled source data to identify duplicates, gaps, and quality issues. Designed clean, scalable star-schema models for standardized reporting. Built automated ETL pipelines using SSIS, T-SQL, ADF, and Snowflake, with validation rules and incremental loads. Collaborated with stakeholders to finalize data mappings, business rules, and KPIs. Developed interactive Power BI dashboards with advanced DAX and RLS for secure, actionable insights. Reduced reporting turnaround time by 60–70% and improved billing accuracy by 30%. Increased dashboard adoption by 40% and enabled faster, data-driven decision-making for leadership.
Legacy on-premises systems caused slow, unreliable reporting and lacked scalability to meet growing analytics demands. Migrated data to Azure SQL DB with automated ADF pipelines, reducing data refresh times by 60%. Developed advanced Power BI dashboards using Power Query, enhancing analytics across departments. Maintained data accuracy at 99.9% via SQL validation scripts and optimized database objects in SSMS.