BI Analyst, Mid-level
GRUPO OTG
full-time
Posted on:
Location Type: Hybrid
Location: Barueri • Brazil
Visit company websiteExplore more
About the role
- Work independently to analyze, consolidate and visualize data, transforming information into strategic insights to support business decisions and optimize processes.
- Develop and maintain dashboards, reports and performance indicators, ensuring reliability, consistency and clarity in communicating results.
- Contribute to strengthening a data-driven culture, supporting business areas in the efficient use of information.
- Collect, clean and structure data from multiple sources.
- Develop, maintain and optimize managerial and operational dashboards and reports.
- Create visualizations and metrics using BI tools such as Power BI.
- Perform exploratory, diagnostic and comparative analyses to identify patterns, trends and opportunities.
- Ensure the quality, integrity and consistency of the data and metrics presented.
- Support business areas in defining, monitoring and interpreting KPIs.
- Automate data update and consolidation routines.
- Document data sources, business rules and metrics used in reports.
- Support continuous improvement initiatives in analytical and visualization processes.
- Work collaboratively with data, technology and business teams.
Requirements
- Advanced SQL
- SQL, CRM Excel, B2C strategies
- Knowledge of SQL, advanced Excel and BI tools (e.g., Looker, Power BI)
- API integration
- Basic to intermediate ETL
Benefits
- Bonus
- Wellhub
- Starbem
- Day off
- Birthday bonus
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Advanced SQLSQLExcelB2C strategiesETLData analysisData visualizationKPI monitoringData cleaningData consolidation
Soft Skills
Analytical thinkingCollaborationCommunicationProblem-solvingAttention to detailStrategic thinkingContinuous improvementData-driven mindset