Data Analyst

Role Overview

As a Data Analyst at SAVAR, you will play a key role in our mission to provide excellence in products and services. Your main responsibilities will be to develop, optimize, and maintain SQL queries, build and maintain data models in Power BI, and create and maintain dashboards and reports.

What You Will Do

Your day-to-day work will involve developing measures, indicators, and calculations in DAX, integrating and processing data from APIs, files, relational databases, and corporate systems, and analyzing data quality to identify inconsistencies and opportunities for improvement.

Why It Might Be a Fit

You will attend to managers and business areas, understanding their needs and translating managerial questions into data analyses, indicators, and solutions. You will also prepare and present objective analyses, contributing to data-driven decisions.

Requirements

• Develop, optimize, and maintain SQL queries to extract, cross-reference, and consolidate data from various systems and databases within the Group
• Build and maintain data models in Power BI, applying best practices in modeling, relationships, and table structuring
• Develop measures, indicators, and calculations in DAX, translating business needs into reliable metrics for managerial follow-up
• Create and maintain dashboards and reports in Power BI, ensuring clarity of information, good user experience, and performance of solutions
• Manage publication, scheduled updates, gateways, and access rules for reports in Power BI Service, including RLS
• Integrate and process data from APIs, files, relational databases, and corporate systems, using SQL and Power Query
• Analyze data quality, identifying inconsistencies, duplicates, registration failures, and opportunities for improvement in information sources
• Develop indicators related to the Group’s different operations, such as revenue, margin, average ticket, inventory turnover, workshop productivity, and customer retention
• Attend to managers and business areas, understanding their needs and translating managerial questions into data analyses, indicators, and solutions
• Prepare and present objective analyses, contributing to data-driven decisions
• Document sources, business rules, calculations, reports, and data dictionaries, ensuring traceability and standardization of information
• Identify opportunities for automation and improvement in data collection, treatment, and availability processes
• Collaborate with IT and business areas in the evolution of the Group’s data environment and Business Intelligence

Tagged as: Data Analysis