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. #J-18808-Ljbffr