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.
- 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.
Same as last analysts hired.
Reportar empleo
