Summary: This role focuses on building Business Insights assets through advanced BI technology, transforming data, and developing Power BI dashboards to provide actionable data-driven recommendations. Highlights: 1. Develop and maintain Power BI dashboards and reports 2. Contribute with easy-to-interpret and actionable data stories 3. Collaborate with stakeholders to provide data-driven recommendations **A\&BI Consulting Analyst (Analytics \& Business Insights)** **Objective:** Build Business Insights assets that facilitate data analysis through advanced BI technology. **Education Level:** Bachelor’s degree in Computer Science, Mathematics, Information Technology, Data Science, or a related field. **English Level:** Advanced **Years of Experience:** 0 \- 2 Years ***(Entry level)*** **Location:** Bogotá, Colombia **Technical Skills:** * Power BI, Data Modeling, Data Manipulation (DAX), Visuals Customization, Data Transformation * DAX Studio, Azure Analysis Services * Azure SQL * Excel (Advanced Formulas, Pivot Tables, Power Query, PowerPivot, Macros, VBA) * Python **Specific Knowledge:** * Basic understanding of data analysis principles and BI technologies. * Familiarity with Power BI, SQL Server, and Excel for data manipulation and reporting. * Analytical skills: Basic understanding of data analysis principles and analytics tools. * Business knowledge: Curiosity and interest in understanding in\-depth a specific industry, company, and clients' analytical needs. * Relationship Management: interest in developing client relationships through analytical advisory. * Communication: Interest and potential to develop and deliver effective presentations to clients. **Main Responsibilities:** * Manage and transform data using Power Query and Power Pivot, and utilize Azure Analysis Services for advanced data analysis. * Develop and maintain Power BI dashboards and reports, perform data modeling and manipulation using DAX and SQL, and customize visuals and transform data for insightful analysis. * Apply Excel formulas, pivot tables, and macros, and develop VBA scripts for automation and advanced analysis. * Contribute with data stories that are easy to interpret and actionable, optimizing visual designs for clarity and impact. * Collaborate with Delivery Managers to ensure that business stakeholders to understand their goals, translate them into data needs, and provide data\-driven recommendations that align with strategic priorities.