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
Data Engineer Consultant
Self-Employed
10.2024 - Current
- Led the full deployment of a Snowflake Data Warehouse, coordinating cross-functional teams to deliver on schedule.
- Designed and implemented an enterprise Lakehouse (Databricks + Delta), establishing governed data domains to enhance reliability and facilitate cross-team usage.
- Built scalable data pipelines using Databricks to support analytics and BI projects.
- Worked with stakeholders to gather requirements and develop detailed technical specifications.
- Optimized data workflows to improve efficiency, reliability, and system performance.
- Reviewed project requests detailing database user needs to estimate the time and cost for completion.
- Handled the identification, safeguarding, and utilization of data assets.
- Developed data models to fulfill complex analysis needs.
- Developed database architecture strategies during modeling, design, and implementation phases to meet business or industry needs.
- Gathered, defined, and refined requirements, led project design, and supervised implementation.
Lead Data Engineer
Booz Allen Hamilton, BAH
05.2024 - 10.2024
- Led federal cloud migration to ensure smooth transitions and minimal downtime.
- Created innovative Azure cloud-native solutions that improved operational efficiency.
- Streamlined timelines and team resources, enhancing performance and delivery schedules.
- Data was prepared, cleaned, and processed for proper management.
- Applied mathematical techniques to develop engineering and scientific solutions.
Data Architect
Booz Allen Hamilton, BAH
11.2023 - 05.2024
- Integrated technologies enhanced data platforms, increasing both efficiency and performance.
- Evaluated processes to identify opportunities for improved data assurance.
- Implemented robust security measures to safeguard data integrity and maintain compliance throughout the enterprise.
- Implemented internal process enhancements to automate repetitive tasks, decreasing data delivery times.
- Developed sets of pre-designed systems architecture models for deployment across multiple facilities within enterprise-level organizations.
- Confirmed the separation of data based on specific geographic boundaries to comply with national and international data transmission laws and regulations.
- Developed a customized architecture designed to optimize various database technologies.
Senior Data Engineer
Booz Allen Hamilton, BAH
05.2023 - 11.2023
- Developed technical documentation to streamline workflows and enhance performance.
- Provided coordinated troubleshooting support that increased team efficiency and reduced resolution times.
- Examined large datasets to find trends and patterns in customer behaviors.
- Supported daily operations by working efficiently and productively with all team members.
- Resolved issues, enhanced operations, and delivered 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
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