Julieth Patiño Garcia
@juliethpatiogarcia
Analytics Engineer who directs AI to deliver faster data solutions. SQL · Python · ETL/ELT · Bilingual
What I'm looking for
I'm an Analytics Engineer and BI Engineer with 5+ years designing and implementing data solutions across the full analytics stack—from raw ingestion to clean, tested, and documented data models. I specialize in data modeling, ETL/ELT pipeline development, and large-scale data migrations across cloud platforms, and I focus on making data reliable and usable for decision-makers. I actively integrate AI into my workflows—certified by Anthropic in Claude Code and Agent Skills—using it to accelerate transformation logic, automate documentation, and sharpen pipeline development. My approach: direct AI as a force multiplier, not a replacement for engineering judgment.
At Picap App, I designed and executed a large-scale data warehouse migration from BigQuery to ClickHouse, delivering measurable cost optimization and significant query performance improvements. I build and maintain end-to-end ETL/ELT pipelines using Apache Airflow, develop custom transformation logic in Python and SQL for ClickHouse, and engineer robust Airflow DAGs with error handling, retries, and alerting to keep pipelines dependable. I also champion data governance through comprehensive technical documentation, training BI teams, and building dashboards and KPIs with Power BI, Looker Studio, and Apache Superset.
Earlier, at Teleperformance Colombia and MiBanco, I led database and pipeline modernization projects, served as a technical liaison between reporting and engineering teams, and automated 80% of manual reporting using Python and SQL ETL pipelines. I've also built dimensional models, data marts, Power BI reporting with DAX, and SSIS-based ingestion with improved reliability and traceability, plus performance monitoring to support product teams. My professional ethos is simple: prioritize data quality, clarity in documentation, and cross-functional collaboration—amplified by AI—so analytics teams can move faster with confidence.
Experience
Work history, roles, and key accomplishments
BI Engineer | Analytics Eng
Picap App
Sep 2024 - Present (1 year 9 months)
Designed and executed a BigQuery to ClickHouse data warehouse migration, improving performance for high-volume analytical workloads and reducing costs. Built and maintained end-to-end Airflow ETL/ELT pipelines with Python/SQL transformations, governance documentation, and Power BI/Looker Studio/Superset dashboards.
BI Engineer | Analytics
Picap App (Digital Platforms SAS)
Aug 2024 - Present (1 year 10 months)
Designed and executed a large-scale data warehouse migration from BigQuery to ClickHouse, achieving cost optimization and significant query performance improvements for high-volume analytics. Built and maintained end-to-end ETL/ELT pipelines with Apache Airflow, and delivered self-service reporting using Power BI, Looker Studio, and Apache Superset.
Served as the primary technical liaison between Colombia reporting teams and India engineering teams, aligning ETL/ELT requirements across time zones. Led agile database and pipeline modernization initiatives and supported Azure Synapse extraction using PySpark to validate data consistency and accuracy.
BI Specialist
MiBanco Colombia
Dec 2022 - Mar 2023 (3 months)
Automated 80% of manual bank reporting using Python and SQL-based ETL pipelines, reducing operational overhead. Built dimensional data models and data marts and delivered Power BI dashboards with advanced DAX for financial reporting.
Monitored and improved database health by establishing data quality frameworks for product development teams. Built performance dashboards and structured monitoring/governance processes to provide real-time visibility into key operational metrics.
Monitored and improved cross-functional database health by establishing data quality frameworks for product development teams. Built data product process monitoring and governance structures, and delivered performance dashboards for real-time visibility into key operational metrics.
Designed and maintained data warehouses and marts to support enterprise reporting needs. Developed ETL pipelines with SSIS, optimized SQL Server stored procedures and objects, and built SSAS cubes for analytical workloads, including internal ETL training for the team.
Monitoring & Evaluation Analyst
World Vision Colombia
Jul 2020 - Mar 2021 (8 months)
Defined data collection systems by integrating SQL databases with social media data sources, ensuring data quality and timeliness for impact measurement. Created Power BI/Google Data Studio/Excel dashboards for leadership and donor reporting.
Monitoring & Evaluation Professional
World Vision Colombia
Jun 2020 - Feb 2021 (8 months)
Defined data collection systems with IT teams by integrating SQL databases and social media data sources. Ensured data quality and timeliness across CRMs and internal databases for program impact measurement, and built reporting dashboards in Power BI, Google Data Studio, and Excel.
Information Analyst
SmartLogy
Dec 2019 - Feb 2020 (2 months)
Analyzed and maintained HR and operational databases to ensure data accuracy and integrity for management reporting. Built HR KPI dashboards in Power BI and Google Data Studio and created Excel-based automated tools to streamline recruitment reporting.
Data Analyst
Kolvoz
Oct 2018 - Oct 2019 (1 year)
Managed workforce management analytics including call forecasting, staff sizing, scheduling, and productivity incentive calculations. Built real-time dashboards for SLA and operational performance tracking and analyzed workflows to support training and continuous improvement.
Operations Analyst
AXA Partners
May 2018 - Aug 2018 (3 months)
Led workforce management analysis for contact center operations, including call forecasting, staff sizing, scheduling, and productivity incentives. Built real-time Excel dashboards for customer SLA metrics and trained supervisors on data-driven implementation.
Operations Intern
AXA Partners
Nov 2017 - May 2018 (6 months)
Conducted method and time studies to identify operational inefficiencies and support data-driven process improvements. Built customer SLA reporting dashboards in Excel and analyzed/documented operating procedures to support onboarding and process standardization.
Education
Degrees, certifications, and relevant coursework
Anthropic
Course, LLM Tooling
2026 - 2026
Completed the Claude Code in Action training with Anthropic in March 2026.
Anthropic
Course, AI Agents
2026 - 2026
Completed the Introduction to Agent Skills training with Anthropic in May 2026.
Google Cloud / Coursera
Course, Data Analytics
2025 - 2025
Completed BigQuery for Data Analysts via Coursera in July 2025.
Google Cloud / Coursera
Course, Data Engineering
2025 - 2025
Completed Introduction to Data Engineering on Google Cloud via Coursera in June 2025.
British Council
Course, Business English
2024 - 2024
Completed Business English training with the British Council in August 2024.
365 Data Science
Course, Machine Learning
2022 - 2022
Completed Machine Learning in Python with 365 Data Science in November 2022.
Platzi
Course, Web Analytics
2021 - 2021
Completed Google Analytics training with Platzi in April 2021.
Universidad Militar Nueva Granada
Industrial Engineering
Studied Industrial Engineering at Universidad Militar Nueva Granada, completing the program in 2019.
EF SET
English Certificate, English Language
Grade: 58/100 (B2 Upper Intermediate)
Earned an EF SET English Certificate score of 58/100 (B2 Upper Intermediate).
Platzi
Course, Databases & SQL
2021 - 2021
Completed Azure Databases, SQL Server Optimization, Database Fundamentals, and Software Engineering Fundamentals with Platzi in 2021.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Job categories
Skills
Interested in hiring Julieth?
You can contact Julieth and 90k+ other talented remote workers on Himalayas.
Message JuliethFind your dream job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
