Carlos Pacheco
Summerville,SC
Summary
Results-driven Data Engineering Consultant with 8 years of experience optimizing data workflows and designing robust cloud solutions. Expertise in leveraging innovative technologies to enhance analytics capabilities and ensure data-driven decision-making across organizations. Proven track record of delivering scalable solutions that improve operational efficiency and drive business growth. Committed to staying at the forefront of industry trends to provide clients with cutting-edge strategies and insights.
Overview
8
8
years of professional experience
1
1
Certificate
Work History
Senior Data Engineer
ATI | Advanced Technology International
06.2025 - Current
- Designed and implemented a Data LakeHouse initiative for the enterprise using Medallion Architecture.
- Showed leadership skills in managing projects from start to finish.
- Utilized critical thinking to analyze problems, assess solutions, and make decisions.
- Collaborated on ETL (Extract, Transform, Load) tasks, ensuring data integrity and verifying pipeline stability on Azure Data Factory.
Data Engineer Consultant
Self-Employed
10.2024 - Current
- Executed the comprehensive deployment of a Snowflake-based Data Warehouse, coordinating multidisciplinary teams to ensure timely delivery.
- Developed scalable data pipelines with Databricks to support analytics and BI projects.
- Collaborated with stakeholders to gather requirements and create detailed technical specifications.
- Streamlined data workflows to improve efficiency, reliability, and system performance.
- Reviewed project requests outlining database user needs to estimate the time and cost required for completion.
- Managed the identification, protection, and use of data assets.
- Designed data models tomeet complex analysis requirements.
- Developed database architectural strategies during modeling, design, and implementation stages to address business or industry needs.
- Gathered, defined, and refined requirements, led project design, and oversaw implementation.
Lead Data Engineer
Booz Allen Hamilton, BAH
05.2024 - 10.2024
- Led federal cloud migrationto ensure smooth transitions and minimal downtime.
- Developed innovative Azure cloud-native solutions that enhanced operational efficiency.
- Optimized timelines and team resources, boosting performance and delivery schedules.
- Prepared, cleaned, and processed data for proper management.
- Used mathematical techniques to create engineering and scientific solutions.
Data Architect
Booz Allen Hamilton, BAH
11.2023 - 05.2024
- Integrated technologies improved data platforms, boosting both efficiency and performance.
- Assessed processes to find opportunities for better data assurance.
- Developed strong security measures to protect data integrity and ensure compliance across the enterprise.
- Implemented internal process improvements to automate repetitive tasks, reducing data delivery times.
- Created sets of pre-designed systems architecture models for deployment at multiple facilities within enterprise-level organizations.
- Confirmed the isolation of data according to specific geographic borders to adhere to national and international data transmission laws and regulations.
- Developed customized architecture tailored to optimize several database technologies.
Senior Data Engineer
Booz Allen Hamilton, BAH
05.2023 - 11.2023
- Prepared technical documentation to streamline workflows and boost performance.
- Coordinated troubleshooting support that boosted team efficiency and cut resolution times.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Assisted with day-to-day operations, working efficiently and productively with all team members.
- Resolved problems, improved operations and provided exceptional service.
Data Engineer
ANDMORE
06.2021 - 04.2023
- Built custom connectors and workflows with Apache Airflow for streamlined integrations.
- Ensured high-quality data in Azure Data Lake and Snowflake for reliable analytics.
- Developed data pipelines with Databricks and Azure Data Factory, boosting efficiency.
- Created interactive Power BI dashboards to visualize key performance data.
- Developed and delivered business information solutions.
- Documented and communicated database schemas using accepted notations.
Technology Analyst
Royal Caribbean Group
05.2020 - 06.2021
- Identified technology initiatives that aligned with strategic goals, fostering innovation.
- Supported revenue management and BI infrastructure to drive operational efficiency.
- Enhanced PL/SQL code boosts business adaptability and performance through innovation.
- Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
- Collaborated with internal and external stakeholders to optimize data sourcing pipelines and verify data quality.
- Performed preemptive resolution of technical issues by utilizing detailed knowledge of ongoing processes and policies.
- Created dashboards to monitor and track key performance indicators.
- Developed customized reports, summarizing and presenting data in visually appealing format.
Analyst, Data Visualization & BI
Royal Caribbean Group
03.2019 - 05.2020
- Applied predictive modeling to forecast trends, refining strategy and promoting efficiency.
- Consolidated data into executive dashboards, streamlining cross-department decisions.
- Designed interactive visualizations that improved reporting for key stakeholders.
- Designed customized data collection models for specific visualization tasks.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
Business Intelligence Developer
AltaReturn
09.2017 - 03.2019
- Maintained ETL processes and SSRS reports, guaranteeing accurate data flow and reporting.
- Executed automated test plans, enhancing efficiency in quality assurance processes.
- Conducted thorough security audits, ensuring robust protection of sensitive data.
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
- Wrote and optimized in-application SQL statements.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
Education
Bachelor of Science - Nuclear Chemistry
06.2010
Artificial Intelligence Boot Camp - Artificial Intelligence
06-2024
Skills
- Database architecture expertise
- Big data management solutions
- Skilled in Python coding
- Data storage solutions
- Data integration development
- SQL data analysis techniques
- Databricks platform expertise
- Experience with machine learning techniques
- Proficient in Snowflake
- Experience with Azure cloud solutions
- Expertise in Databricks Unity Catalog
- Medallion Aerchitecture
Certification
- CIW v5 Database Design Specialist
- Artificial Intelligence Engineer Expert
- Databricks Certified Data Engineer
- Databricks Lakehouse Fundamentals
- ITIL Foundation Level
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Senior Data Engineer - ATI | Advanced Technology International
06.2025 - Current
Data Engineer Consultant - Self-Employed
10.2024 - Current
Lead Data Engineer - Booz Allen Hamilton, BAH
05.2024 - 10.2024
Data Architect - Booz Allen Hamilton, BAH
11.2023 - 05.2024
Senior Data Engineer - Booz Allen Hamilton, BAH
05.2023 - 11.2023
Data Engineer - ANDMORE
06.2021 - 04.2023
Technology Analyst - Royal Caribbean Group
05.2020 - 06.2021
Analyst, Data Visualization & BI - Royal Caribbean Group
03.2019 - 05.2020
Business Intelligence Developer - AltaReturn
09.2017 - 03.2019
INSTEC - Bachelor of Science, Nuclear Chemistry
UCF College of Health Professions And Sciences - Artificial Intelligence Boot Camp, Artificial Intelligence
Languages
English
Spanish