**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, Business, Industrial Engineering, Economics 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. - 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.