Data Analyst

Description

Job Summary: We are seeking a Data Analyst to manage and optimize databases, transforming information into strategic solutions and supporting informed decision-making. Key Highlights: 1. Transform data into strategic solutions 2. Serve as the bridge between data and key decisions 3. Work in a dynamic and collaborative environment **Introduction** Welcome to Gallagher, a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing the right thing. We help our clients navigate complexity with confidence, empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job—you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we are better together. Whether you join us in a client service role, in our brokerage division, in our benefits and human resources consulting division, or as part of our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s living the Gallagher Way. **Description** Are you passionate about working with data and turning information into strategic solutions? At Gallagher, we’re looking for a Data Analyst to play a key role in managing and optimizing our databases, helping leaders across various functions make informed decisions. This role is critical to ensuring information is up-to-date, consolidated, and ready for presentation to managers and key teams. **How You’ll Make an Impact** In this role, you will serve as the bridge between data and strategic decisions. Your responsibilities will include: * Maintain and enhance databases, macros, and files to ensure efficiency and accuracy. * Provide technical support to users across different locations in handling files and databases. * Update external information for the creation of managerial reports and enterprise databases. * Process files related to payments and quotations. * Create new databases and reports based on team needs. * Consolidate information from diverse sources to generate strategic reports. * Administer and optimize macros designed to consolidate enterprise data. * Collaborate with leaders from areas such as mechanical risk, engineering, and psychosocial safety to support the presentation of key data. You will work in a dynamic environment where your assertive communication skills and agility in responding will be essential to coordinate with multiple leaders and ensure high-quality outcomes. **About You** We seek individuals passionate about data and technology, with strong teamwork skills and the ability to adapt to a dynamic environment. To succeed in this role, you’ll need: * Advanced Excel skills (pivot tables, macros, and VBA language). * Experience in data modeling and integrating information from various Excel files. * Knowledge of Power BI. * Preferred: Familiarity with Power Pivot and occupational health and safety systems. * 2–3 years of experience in data analysis or related fields, managing databases and improving their performance. * Academic background in Industrial Engineering, Systems Engineering, Data Science, Statistics, Mathematics, or related disciplines. * Assertive communication skills to coordinate with multiple leaders and present information to managers. * Availability to work onsite in Chía. At Gallagher, we value diversity and believe every person brings something unique. If you meet the requirements and are ready to contribute to a team committed to excellence, we want to meet you!