Kavitha Ch
Senior Data Engineer
Coventry,Warwickshire
Summary
As a skilled data platform developer with more than Four plus years of experience, I offer a solid foundation in business and data analysis, ETL/ELT, Data warehousing and Cloud solutions. With experience in data analysis, data integration, and data profiling, I have a track record of success in DWH, ETL, BI applications and data management. Expertise in creating data pipelines in Azure, On Premises enabling seamless data movement and transformation across on-premises and cloud environments and facilitating data-driven insights for the organization. I'm excellent at building and managing end-to-end data platforms, designing scalable solutions, and setting up analytical tools to deliver useful information. Experience working in an Agile sprint and producing and deploying applications in a production environment. Strong collaboration skills, presentation skills demonstrating the ability to effectively collaborate with other developers to achieve project goals and deliver high-quality solutions.
Overview
5
5
years of professional experience
3
3
Certification
Work History
Senior Data Engineer
Wesleyan
12.2025 - Current
- Designed and implemented end-to-end data pipeline solutions, enabling efficient data ingestion, transformation, and delivery across systems.
- Developed and maintained data contracts to ensure consistent metadata management, data quality, and governance standards.
- Built and optimized data transformation workflows using Azure Synapse Notebooks with PySpark for large-scale data processing.
- Automated deployments using CI/CD pipelines in Azure DevOps, ensuring continuous integration and reliable delivery of data solutions.
- Designed and managed ETL pipelines using Azure Data Factory (ADF) for ingesting raw data from multiple sources.
- Implemented robust error handling and data validation techniques to identify and manage corrupt or inconsistent data records.
- Developed and maintained SQL stored procedures for efficient data manipulation, transformation, and loading into relational databases.
- Created and maintained test evidence datasets to support data quality checks, validation processes, and auditing requirements.
- Collaborated closely with stakeholders, analysts, and cross-functional teams to gather requirements, provide updates, and support day-to-day data operations.
Data Base Administrator
Chartered Institute of Arbitrators (CIArb)
01.2025 - 08.2026
- Collaborated Stakeholder, with various upstream and downstream customers to interface different systems and processes for data extractions, ETL&ELT, analytics, Data Warehouse and reporting requirements.
- Administer and optimize Microsoft Dynamics 365 CRM, including data management, configuration, user roles, and process automation.
- Designed data integration solutions using Azure Data Factory, Databricks, Event hubs, ADLS, Azure SQL DWH streamlining ETL workflows for seamless data movement across disparate sources and destinations.
- Played a key role in enhancing data accessibility and operational efficiency within the organization.
- Executed the deployment and optimization of data processing workflows using Azure Databricks, ADF leveraging its advanced analytics and collaborative capabilities to empower data-driven decision-making.
- Successfully implemented Azure Data Lake Storage solutions, architecting scalable data repositories, and optimizing storage structures with that played a pivotal role in facilitating efficient data processing.
- Built advanced automation of Databricks data engineering pipelines through removal of manual stages.
- Define and enforce technical standards, ensuring data quality, availability, security, and implementing appropriate access controls and data protection measures to restrict user access to the data.
- Used ADLS Analytics, enabling distributed processing for complex analytical tasks, accelerating time-to-insight.
- Implemented CI/CD pipelines using Azure DevOps, enabling automated testing across environments and seamless deployments, reducing release cycle time and increasing software quality.
- Worked on documenting databases, data process flows, and maintaining data dictionaries, metadata, and data lineage documentation to provide transparency and traceability of data assets.
- Provided expert-level support in Microsoft Excel, including advanced formulas, data analysis, and pivot reporting.
- Played a key role in data governance and compliance efforts, ensuring GDPR and organizational data policies were upheld.
- Promoted best practices in documentation, version control, and knowledge sharing within the technical team.
- Created interactive dashboards and reports using Power BI to provide insights into data trends and patterns and integrated with Azure data sources to enable real-time data visualization and analysis.
- Trained and mentored junior interns, providing hands-on guidance in data tools, best practices, and professional development.
Data Engineer
Sai-Rasi-IT
03.2023 - 06.2024
- Worked on requirements gathering from the clients and estimation of efforts including analysis of data.
- Leveraged Azure Synapse, ADF pipelines and dataflows to consolidate data sources, enabling efficient data processing, real-time insights, and data-driven decision-making for the organization.
- Designed, developed, and maintained ETL pipelines to efficiently move and transform data from source to destination, ensuring seamless extraction, transformation, and loading of data between systems.
- Contributed to the acceleration of ETL processes, fostering a more agile, efficient data engineering environment.
- Manage source and target data sets, ensuring the accuracy and reliability of the data through ETL processes.
- Maintained data models, upheld schema design best practices, and provided training on Azure Data Factory, Azure Synapse Analytics functionalities to internal teams and external client stakeholders and users.
- Used Azure Key Vault to manage all keys and secrets, ensuring data security and achieving compliance audits.
- Set up Email alerts and notifications, monitoring alerts and automated workflows using Azure Monitor services to proactively identify and address issues in data pipelines and systems.
- Implemented event, error-handling mechanisms and logging frameworks to capture and manage errors, exceptions, and data anomalies during the ETL process, ensuring data integrity and reliability.
- Provided data insights for both internal and external clients, leveraging advanced Power BI, SSRS reports, and sophisticated KPIs through DAX, MDX and M Query functions and variables.
- Transforming data into user-friendly reports to give business users a complete view of business using Power BI.
Data Engineer & BI Developer
Floor Edge Sol
08.2020 - 02.2022
- Engaged closely with business stakeholders to understand their reporting requirements and translate them into effective paginated and self-service story telling report solutions using Power BI, Tableau and Excel.
- Designed DWH solutions using MS SQL server, enhancing query performance and enabling timely, data-driven insights and orchestrated the integration of disparate data sources, resulting in improved reporting capabilities.
- Worked on Star and Snowflake schemas, Managed, optimized Azure SQL Database, ensuring high availability, scalability, and performance with that implemented efficient indexing strategies, monitored and tuned queries.
- Designed and maintained SSIS packages to automate data extraction, transformation, and loading (ETL) processes, resulting in a reduction in data processing time and improved data accuracy.
- Played a key role in enhancing data accessibility and operational efficiency within the organization.
- Executed the deployment and optimization of data processing workflows using Azure Databricks, ADF leveraging its advanced analytics and collaborative capabilities to empower data-driven decision-making.
- Successfully implemented Azure Data Lake Storage solutions, architecting scalable data repositories, and optimizing storage structures with that played a pivotal role in facilitating efficient data processing.
- Built advanced automation of Databricks data engineering pipelines through removal of manual stages.
- Define and enforce technical standards, ensuring data quality, availability, security, and implementing appropriate access controls and data protection measures to restrict user access to the data.
- Used ADLS Analytics, enabling distributed processing for complex analytical tasks, accelerating time-to-insight.
- Implemented CI/CD pipelines using Azure DevOps, enabling automated testing across environments and seamless deployments, reducing release cycle time and increasing software quality.
- Worked on documenting databases, data process flows, and maintaining data dictionaries, metadata, and data lineage documentation to provide transparency and traceability of data assets.
- Created interactive dashboards and reports using Power BI to provide insights into data trends and patterns and integrated with Azure data sources to enable real-time data visualization and analysis.
Junior Data Platform Developer
Greentech
04.2019 - 07.2020
- Responsible for gathering/refining requirements from the customer for developing reports in Power BI, SSRS.
- Design data pipelines Using SSIS to pull Data from multiple client sources and perform Data Cleansing using the various SSIS Data Flow Transformation and applying Business logic as defined in the BRD.
- Responsible for creating and modifying visualizations in Power BI, SSRS reports based on client requests.
- Developed and maintained Power BI mobile solutions, enabling seamless access to reports on various devices.
- Acted as the point of contact for all ETL, data processes, data mappings, data pulls, and reporting solutions.
- Published Power BI Reports in the required originations and Made Power BI reports available in Web clients.
- Developed SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
- Automated Power BI Dashboards using Gateways by scheduling them timely and provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
Education
M.Sc. - Data science
12.2023
M. Tech - Embedded Systems
12.2016
B. Tech - ECE
12.2007
Skills
- Azure
- Azure Data Factory (ADF)
- Azure SQL
- Databricks
- Azure Synapse
- ADLS
- Functions
- Power BI
- SSRS
- Tableau
- Microsoft Excel
- Looker
- SQL Server
- MySQL
- RedShift
- Snowflake
- Delta Lake
- Alteryx
- SSIS
- Power Automate
- Power Automate Work Flows
- Power Query
- DAX
- Git
- DevOps
- Microsoft dynamics 365 CRM
- JIIRA
- Microsoft office suite
- Python
- Pyspark
Certification
- Microsoft Azure Data Engineer Associate, DP-203
- Microsoft Power BI, PL-300
- Salesforce Certified Administrator, ADM-201
Technology Stack
Azure, Azure Data Factory (ADF), Azure SQL, Databricks, Azure Synapse, ADLS, Functions, Power BI, SSRS, Tableau, Microsoft Excel, Looker, SQL Server, MySQL, RedShift, Snowflake, ADLS, Delta Lake, Alteryx, SSIS, ADF, Synapses, Databricks, Power Automate, Power Automate Work Flows, Power Query, SQL Server, DAX, Git, DevOps, Microsoft Dynamics 365 CRM, JIRA, Microsoft Office Suite, Python, Pyspark
Timeline
Senior Data Engineer
Wesleyan
12.2025 - Current
Data Base Administrator
Chartered Institute of Arbitrators (CIArb)
01.2025 - 08.2026
Data Engineer
Sai-Rasi-IT
03.2023 - 06.2024
Data Engineer & BI Developer
Floor Edge Sol
08.2020 - 02.2022
Junior Data Platform Developer
Greentech
04.2019 - 07.2020