Juan David Julio San Juan Email & Phone Number

Barranquilla, Co

Barranquilla, Atlántico, Colombia

● Extracted data from diverse sources to provide clean and structured datasets to the BI team, employing Azure Data Factory, Azure Databricks, and SQL.● Designed and implemented ETL processes to transform raw data into actionable insights, leveraging Azure Data Factory and Databricks.● Integrated data from external APIs, automating data retrieval and ingestion processes to streamline information flow.● Orchestrated the migration of tables from various databases to Azure Databricks, optimizing data storage and accessibility for analytics purposes.● Collaborated closely with BI team members to understand data requirements, define data models, and deliver high-quality datasets for analysis.

Barranquilla, Atlántico, Colombia

● Analyzed and interpreted complex datasets to extract actionable insights, utilizing tools such as Azure Data Factory, Azure Databricks, and SQL.● Developed scalable data pipelines and ETL processes using Azure Data Factory and Databricks, ensuring efficient data processing and integration.● Utilized Scala and Python for data manipulation, transformation, and modeling tasks, enhancing data quality and accuracy.● Designed and created interactive dashboards and reports using Microsoft Power BI and Metabase, providing stakeholders with intuitive visualizations for data-driven decision-making.● Collaborated closely with cross-functional teams to understand business requirements, translate them into analytical solutions, and deliver valuable insights.

● Played a key role as a BI analyst and developer, contributing to successful data analysis and system integration projects.● Designed and developed APIs to streamline data integration between systems, enhancing operational efficiency and data accessibility.● Automated processes using RPAs to expedite repetitive tasks and boost team productivity.Created and optimized ETLs for extracting, transforming, and loading data from diverse sources, ensuring data integrity and quality.● Developed custom reports and visualization dashboards using tools like Microsoft Power BI, providing crucial insights for business decision-making.● Leveraged Python expertise to write programs and scripts, improving data analysis processes and handling complex data manipulation.● Demonstrated strong data analysis skills, working with complex data structures and performing advanced queries in database environments such as Microsoft SQL Server.● Collaborated closely with interdisciplinary teams to understand business needs, design effective solutions, and ensure timely project delivery.

United States

Engineer'S Degree, Systems Engineering

Education record

Activities and Societies: Researchers group of Universidad del Norte.