Accordion India
|Data Engineer 2
Hyderabad, Telangana, India
Summary
Led data engineering initiatives for Southern Orthodontic Partners, focusing on ELT development, process automation, and performance optimization to enhance CRM integration and data reporting.
Highlights
Engineered and optimized ELT processes, integrating data from 7 diverse Practice Management Systems (PMS) and Active Campaign CRM into a centralized Data Warehouse using Azure Data Factory, facilitating seamless CRM integration and data-driven reporting.
Automated CRM data management by establishing processes to remove irrelevant contact and deal data, implementing comprehensive exception handling with Azure Logic Apps, Azure Data Factory, and SQL stored procedures for reliable data mapping.
Redeveloped and optimized SQL stored procedures and Azure Pipelines, enhancing CRM integration and dashboard reporting reliability and reducing client costs by 30% by resolving bottlenecks.
Managed and automated daily PMS to CRM data refresh processes for 60 practices, ensuring accurate and timely data delivery within a strict 2-hour window through SQL CI/CD with Microsoft Visual Studio and Azure DevOps.
Delivered client data reporting requirements on time with thorough validation, creating and optimizing reporting workflows for CRM integration and dashboard reporting to provide actionable insights.