DATA AND ANALYTICS CONSULTANT – Req 2543213Bogotá, ColombiaAre you looking to expand your professional experience?Would you like to join a dynamic and inclusive team?This opportunity is waiting for you!This is a virtual position working from home.Aon is in the business of better decisions At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.What the day will look likeThe role is responsible for the design, development and implementation, creation, execution and control of extraction, transformation and loading processes with large volumes of data from various sources, maintenance, automation and optimization of data models and control systems to ensure quality and integrity of the information base in the data lake used by data visualization and analytics tools.- Monitoring process execution and tracking data replication incidents- Build data ingestion, transformation and loading (ETL's) processes collecting and transforming structured and unstructured data from multiple systems.- Analyze, optimize, automate and migrate existing data replication processes between different environments to new technologies.- Diagnose and troubleshoot data replication errors in process execution and quality of results.- Develop data transformation, normalization and structuring processes using architectures, principles, best practices to ensure process performance and data integrity in the data lake.Skills and experience that will lead to successStudies: Software, systems, electronic or related engineer.Languages: Intermediate level of EnglishExperience: 3 years as Data Engineer, with programming experience in languages such as Java, Python or similar.Technical skills: solid knowledge working with relational databases (Oracle/MySQL/Postgres/SQL Server) and cloud services (Azure/AWS).How we support our colleagues In addition to our comprehensive benefits package, we encourage a diverse workforce.Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon.Furthermore, all colleagues enjoy two "Global Wellbeing Days" each year, encouraging you to take time to focus on yourself.We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work... and we are all for it.We call this Smart Working!
