Stephanie Avila Díaz Email and Phone Number
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.
-
Data Engineering | Sql | GisLovelyticsBogota, D.C. -
Data EngineerDatalytics May 2023 - PresentColombiaMain 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 -
Data SchoolDatalytics Feb 2023 - May 2023Bogotá, Distrito Capital, Colombia -
Bi AnalystRappi Oct 2022 - Jan 2023ColombiaMain 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 -
Set Up AnalystContreebute Jan 2022 - Oct 2022ColombiaInformation 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 -
Environmental Gdb MakerAgq Labs Nov 2021 - Oct 2022ColombiaMain 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 -
Environmental Professional - GisDaphnia Ltda Jul 2020 - Aug 2021Bogotá, Distrito Capital, ColombiaMain 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 -
Environmental Engineering InternColsubsidio Dec 2018 - Jun 2019Bogotá D.C., ColombiaMain 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
-
Engineering -
Nature Appreciation -
Engineering -
CoruniversitecHospitality Administration/Management
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial