About 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.
Experience
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.
Education
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
Professionals who compete with Hector
Professionals in the same Scientific sector as Hector Sanchez
Other users who are called Hector
Jobs near Toronto, Ontario
-
Automotive Technician
Found in: Talent CA C2 - 5 days ago
BMW Toronto Toronto, CanadaWould you like to be a part of one of the country's premier luxury car dealerships? Are you looking for an opportunity to be appreciated and involved in your career? If so, BMW Toronto is the place for you · BMW Toronto is a busy, fast paced downtown luxury car dealer looking a h ...
-
barber
Found in: Talent CA 2 C2 - 3 days ago
6955062 Manitoba Ltd Bradford West Gwillimbury, CanadaEducation: · Expérience: · Education · Secondary (high) school graduation certificate · Tasks · Book appointments · Cut and trim hair according to client's instructions or preferences · Shampoo customers' hair · Shave and trim beards and mustaches · Provide other hair treatment ...
-
shift manager
Found in: Talent CA 2 C2 - 3 days ago
Kfc/Taco bell Vaughan, CanadaEducation: · Expérience: · Education · Secondary (high) school graduation certificate · or equivalent experience · Work setting · Restaurant · Tasks · Establish methods to meet work schedules · Supervise and co-ordinate activities of staff who prepare and portion food · Train s ...