Hector Sanchez

Experienced data engineer with 5+ years of expertise in developing and maintaining impactful data-driven solutions. Proficient in SQL for advanced data processing and cleansing. Specialized in designing ETL/ELT solutions using SSIS and Azure Data Factory for diverse applications,

including machine learning, business intelligence, and automated data processing. Background encompasses data mining, warehousing, and analytics. Skilled in implementing high-quality data processing and machine learning solutions. Known for excellent communication and project management skills, ensuring successful project delivery in dynamic environments.

Senior Data Engineer, Lean Solutions Group - May 2021 - Present

• Orchestrated the development and maintenance of intricate data transformation scripts in SQL, executing Extract, Load, Transform (ELT) processes to seamlessly extract, process, and integrate data from diverse sources.
• Engineered and implemented robust data pipelines within Azure Data Factory (ADF), streamlining and automating data processing workflows across various departments.
• Assumed the pivotal role of a liaison between clients and the development team, expediting the construction of the company's comprehensive data warehouse.
• Contributed to troubleshooting and QA testing to ensure data consistency, implementing automated solutions for identifying and addressing data quality anomalies.
• Leveraged technologies and platforms such as Azure DevOps and Git to proficiently adopt the Continuous Integration and Continuous Delivery (CI/CD) methodology, ensuring seamless and efficient deployment practices.

Data Engineer, AXA Colpatria - Jan 2020 -May 2021

• Employed Python and SQL, leveraging a suite of tools and technologies, to process, clean, and transform data for diverse purposes. Developed SQL scripts for comprehensive data quality assessments and automated data processing.
• Utilized Power BI expertise to craft interactive and automated data visualizations and dashboards, resulting in approximately 700 million in operational cost savings.
• Optimized call center campaigns, building a machine learning (ML) model that contributed to a 5% revenue boost (200 million).
• Engineered and structured data pipelines for the execution of ETL automated processes, seamlessly integrating data from multiple sources using Microsoft SSIS.
• Demonstrated proficiency in SCRUM methodologies, contributing to agile project management practices for enhanced efficiency and collaboration.

Data Analyst (Intern), Urban Science - Jul 2018 – Aug 2019

• Strategized, organized, and executed client-requested projects within specified timelines across the UK, Hungary, Germany, Switzerland, and other European countries.
• Established robust communication channels with clients and colleagues, proactively identifying and resolving data inconsistencies in day-to-day processes. Introduced effective solutions to identify, rectify, and prevent such inconsistencies.
• Developed and deployed SQL stored procedures, ensuring data correctness and completeness across multiple solutions.
• Coded and maintained SQL scripts and intricate queries for comprehensive data analysis and extraction, supporting diverse project requirements.
• Crafted a diverse range of business intelligence reports utilizing SQL and extracting data from multiple sources. These reports empowered clients to make informed decisions based on accurate and timely insights.

Power BI specialist, Quenty - Jul 2016 – Aug 2017

• Designed and implemented a Power BI logistics analytics solution, integrating data from various supply chain sources. Resulted in a 30% reduction in transportation costs for clients and improved delivery time accuracy by 20%.
• Contributed to the migration of legacy logistics systems to Power BI, resulting in a 30% reduction in reporting errors and a 15% improvement in report generation speed for a logistics optimization company.
• Successfully resolved performance bottlenecks in Power BI reports for a logistics planning and scheduling project
• Established row-level security in Power BI for a customer analytics project, ensuring compliance with privacy regulations. The solution provided secure access to sensitive data and received positive feedback from regulatory authorities.

MSc. Data Science and Analytics - Royal Holloway University of London United Kingdom

Advanced Project Management in IT - Lambton College Canada

BSc. Computing (Hons) - Cardiff Metropolitan University United Kingdom