Stephanie Avila Díaz

Stephanie Avila Díaz Email and Phone Number

Data engineering | SQL | GIS @ Lovelytics
Bogota, D.C.
Stephanie Avila Díaz's Location
Bogota, D.C., Capital District, Colombia, Colombia
About Stephanie Avila Díaz

Passionate and detail-oriented self-taught engineer proficient in database management tools, SQL and Python programming. Strong interest in data engineering, Geographic Information Systems (GIS) and dedicated to delivering precise results.Experience in handling tools and technologies such as SQL, Azure, Databricks, Git, Office package, SQL server, Power BI and ArcGis.Azure fundamentals AZ900, Azure Data fundamentals DP900, Azure Cloud Data Engineer associate DP203 and Databricks data engineer associate certified.

Stephanie Avila Díaz's Current Company Details
Lovelytics

Lovelytics

View
Data engineering | SQL | GIS
Bogota, D.C.
Website:
lovelytics.com
Employees:
484
Stephanie Avila Díaz Work Experience Details
  • Lovelytics
    Data Engineering | Sql | Gis
    Lovelytics
    Bogota, D.C.
  • Datalytics
    Data Engineer
    Datalytics May 2023 - Present
    Colombia
    Main tasks:• Extracting data from various sources, such as databases or files, and transforming it into a usable format for analysis or storage.• ETL (Extract, Transform, Load) Process: Implementing ETL processes to integrate data from multiple sources, transform it according to business requirements, and load it into target systems or data warehouses.• Assisting in the development and maintenance of data pipelines to automate data workflows, ensuring efficient and reliable… Show more Main tasks:• Extracting data from various sources, such as databases or files, and transforming it into a usable format for analysis or storage.• ETL (Extract, Transform, Load) Process: Implementing ETL processes to integrate data from multiple sources, transform it according to business requirements, and load it into target systems or data warehouses.• Assisting in the development and maintenance of data pipelines to automate data workflows, ensuring efficient and reliable data processing and integration.• Identifying and resolving issues related to data processing, database performance, or ETL processes to ensure data operations.• Documenting data engineering processes and workflows for future reference and knowledge sharing within the team. Show less
  • Datalytics
    Data School
    Datalytics Feb 2023 - May 2023
    Bogotá, Distrito Capital, Colombia
  • Rappi
    Bi Analyst
    Rappi Oct 2022 - Jan 2023
    Colombia
    Main tasks:• Ensured data quality in area-related tables by utilizing SQL through the Snowflake data warehouse and integrating external data sources such as Gsheets.• Developed, maintained, and supported Power BI dashboards to derive valuable insights for the involved areas.• Created a framework and template with UX standards for financial dashboards establishment.• Orchestrated ETL processes using Airflow to streamline data integration and… Show more Main tasks:• Ensured data quality in area-related tables by utilizing SQL through the Snowflake data warehouse and integrating external data sources such as Gsheets.• Developed, maintained, and supported Power BI dashboards to derive valuable insights for the involved areas.• Created a framework and template with UX standards for financial dashboards establishment.• Orchestrated ETL processes using Airflow to streamline data integration and transformation.• Implemented CI/CD methodology using the BitBucket service to ensure efficient development and deployment of code. Show less
  • Contreebute
    Set Up Analyst
    Contreebute Jan 2022 - Oct 2022
    Colombia
    Information management ESG - https://merosystem.contreebute.com/Main tasks:• Parametrization of the ESG information structure, highlighting usability, data centralization and creation of value connections with stakeholders.• 1:1 support with Mero customers to improve the customer experience in the system.• Promote ideas of continuous improvement using environmental and technological guidelines that allow for a friendly panorama between both topics.• Generate… Show more Information management ESG - https://merosystem.contreebute.com/Main tasks:• Parametrization of the ESG information structure, highlighting usability, data centralization and creation of value connections with stakeholders.• 1:1 support with Mero customers to improve the customer experience in the system.• Promote ideas of continuous improvement using environmental and technological guidelines that allow for a friendly panorama between both topics.• Generate instruments to define management follow-up indicators within the tool, prior to the development of dashboards for data analysis. Show less
  • Agq Labs
    Environmental Gdb Maker
    Agq Labs Nov 2021 - Oct 2022
    Colombia
    Main tasks:• Geodatabase Development: Creating geodatabases using ArcGIS Desktop to manage and organize environmental monitoring data for air, water, noise, and soil matrices.• Performing data cleaning and validation tasks to ensure the accuracy and quality of the collected environmental data from various sources such as flat files and xlsx files.• Creating maps and graphical outputs using ArcGIS Desktop to visually represent monitoring points and locations, aiding in data… Show more Main tasks:• Geodatabase Development: Creating geodatabases using ArcGIS Desktop to manage and organize environmental monitoring data for air, water, noise, and soil matrices.• Performing data cleaning and validation tasks to ensure the accuracy and quality of the collected environmental data from various sources such as flat files and xlsx files.• Creating maps and graphical outputs using ArcGIS Desktop to visually represent monitoring points and locations, aiding in data interpretation and communication of results.• Compliance with Standards and Regulations: Following the guidelines and standards set by entities like IGAC (Instituto Geográfico Agustín Codazzi) and ANLA (Autoridad Nacional de Licencias Ambientales) to ensure compliance with environmental regulations in data management and reporting. Show less
  • Daphnia Ltda
    Environmental Professional - Gis
    Daphnia Ltda Jul 2020 - Aug 2021
    Bogotá, Distrito Capital, Colombia
    Main tasks: • Creation of templates in Excel, integrated data into a geodatabase (GDB), and associated products using ArcGIS software. Managed environmental monitoring data for water, air, soil, noise, and radiation, ensuring adherence to ANLA's data model.• Providing support for graphic outputs using ArcGIS, including georeferencing and spatial analysis, to meet specific requirements.• Conducting training sessions on general topics of basic cartography to the data… Show more Main tasks: • Creation of templates in Excel, integrated data into a geodatabase (GDB), and associated products using ArcGIS software. Managed environmental monitoring data for water, air, soil, noise, and radiation, ensuring adherence to ANLA's data model.• Providing support for graphic outputs using ArcGIS, including georeferencing and spatial analysis, to meet specific requirements.• Conducting training sessions on general topics of basic cartography to the data processing team, enhancing their understanding and skills in cartographic principles and techniques.• Training and implementation in the management and transformation of data to different coordinate systems, following Resolution 471 of 2020 issued by the IGAC for basic cartography products. Show less
  • Colsubsidio
    Environmental Engineering Intern
    Colsubsidio Dec 2018 - Jun 2019
    Bogotá D.C., Colombia
    Main tasks:• Updating and reviewing environmental logs at IPS facilities.• Planning and conducting training sessions for medical staff focused on the PGIRASA (Integrated Waste Management Plan for Healthcare Facilities). • Preparation and monitoring of monthly comparative reports on waste generation and collection by authorized handlers.• Assisting in the registration of Special Waste (RESPEL) with IDEAM (Institute of Hydrology, Meteorology, and Environmental… Show more Main tasks:• Updating and reviewing environmental logs at IPS facilities.• Planning and conducting training sessions for medical staff focused on the PGIRASA (Integrated Waste Management Plan for Healthcare Facilities). • Preparation and monitoring of monthly comparative reports on waste generation and collection by authorized handlers.• Assisting in the registration of Special Waste (RESPEL) with IDEAM (Institute of Hydrology, Meteorology, and Environmental Studies), SIRHO (Water Resources Information System) for the SDA (Environmental Authority), and characterization of discharges with EAAB (Bogotá Aqueduct and Sewerage Company).• Conducting environmental assessments and providing support in updating the PGIRASA (Integrated Waste Management Plan for Healthcare Facilities). Show less

Stephanie Avila Díaz Education Details

Frequently Asked Questions about Stephanie Avila Díaz

What company does Stephanie Avila Díaz work for?

Stephanie Avila Díaz works for Lovelytics

What is Stephanie Avila Díaz's role at the current company?

Stephanie Avila Díaz's current role is Data engineering | SQL | GIS.

What schools did Stephanie Avila Díaz attend?

Stephanie Avila Díaz attended Universidad Nacional De Colombia, Universidad Libre ®, Instituto Tecnológico De Sonora, Coruniversitec.

Who are Stephanie Avila Díaz's colleagues?

Stephanie Avila Díaz's colleagues are Lovely Mejorada, Jared Lauer, Allistair Cota, Robert Fournier, Tejas Pandit, Alyssa Williams, Trang Leminh.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.