Federico Aguilar
Senior Data Analyst
Montreal
Summary
Results-driven data professional with a strong foundation in data analysis and business intelligence. Known for transforming complex datasets into business solutions and compelling, insightful dashboards while maintaining rigorous data quality standards. Consistently fosters team collaboration and adapts seamlessly to dynamic project requirements, using SQL, Power BI, and Python to deliver industry insights.
Overview
4
4
years of professional experience
3
3
Languages
Work History
SENIOR DATA ANALYST
IATA
01.2024 - Current
- Took the lead in enhancing our data sources, playing a critical role in establishing IATA as a global leader in aviation incident programs.
- Owned and managed the data collection and collation processes for the Incident Data Exchange Program (IDX), serving as the primary point of contact for participating members.
- Reduced manual data entry errors by designing and deploying automated ETL processes that transform raw data into usable, standardized formats.
- Lead workshops and training sessions, ensuring all participants have the skills and knowledge to engage effectively with our data program.
- Served as a subject matter expert on various projects and in user forums, sharing valuable insights drawn from extensive industry experience as a Senior Data Analyst.
- Led initiatives to enhance and expand IDX’s data sources, improving the depth and breadth of incident data, including airport-related incidents, flight frequency, and turnaround movements.
- Oversaw the integration of AI and advanced analytics into the incident data program, validated results from large language models, and trained interns and data scientists to develop Python code aligned with our business requirements.
DATA ANALYST
IATA
01.2023 - 12.2023
- Responsible for optimizing reporting processes, designing and revamping the IDX dashboards, and improving data quality in the data warehouse.
- Collaborated with internal teams, airlines, and external stakeholders to deliver data-driven insights, industry-relevant safety performance indicators, and compelling, clear, and engaging data visualizations.
- Developed and implemented automated dashboards and reports in Power BI, designing and delivering 20+ dynamic Power BI reports that made data visualizations more interactive and accessible to stakeholders.
- Implemented comprehensive data quality control measures, including SQL view creation and SQL cleanup queries, removing over 100K unreliable records.
- Prioritized and managed ad hoc analysis requests from airlines and internal teams, enhancing interdepartmental collaboration and encouraging airlines to participate in the voluntary data submission process.
INTERN, DATA ANALYST
IATA
05.2022 - 12.2022
- Supported the Global Aviation Data Management (GADM) team by automating data extraction, performing quality checks, and developing machine-learning models to optimize data processes.
- Developed a machine-learning model for domain masking and actor anonymization to enhance data security and ensure compliance with privacy regulations across all incident data exchange (IDX) reports generated by the GADM team.
- Developed and maintained data quality metrics to ensure consistent, reliable data, thereby improving the quality of the ETL process.
- Analyzed complex datasets using SQL queries to identify trends, patterns, and anomalies for further investigation or corrective action.
Education
MBA - MBA
Concordia University
Montreal, QC09-2029
Master of Science - MSc. Data Science and Business Analytics
HEC Montral
Montreal, QC01.2022
Bachelor of Engineering - BEng. Materials Engineering
McGill University
Montreal, QC01.2020
Skills
Advanced Excel
ETL processes
Data quality assurance
Advanced analytics
SQL expertise
Data warehousing
Python programming
R programming
Dashboard creation and design
Power BI
Data validation
Accomplishments
Managed and owned the data quality processing for +3 years of the Incident Data Exchange (IDX) program, which helped IATA win the 2025 Data & AI for Good Hero Organization Award (and the overall Grand Prix Award), recognizing organizations that use data and AI for social benefit.
Timeline
SENIOR DATA ANALYST
IATA
01.2024 - Current
DATA ANALYST
IATA
01.2023 - 12.2023
INTERN, DATA ANALYST
IATA
05.2022 - 12.2022
MBA - MBA
Concordia University
Master of Science - MSc. Data Science and Business Analytics
HEC Montral
Bachelor of Engineering - BEng. Materials Engineering
McGill University