BI Analyst

Description

Job Summary: A professional to develop and maintain dashboards and reports using Power BI, perform ETL, data modeling, and automate routines for various departments. Key Highlights: 1. Develop and maintain dashboards and reports using Power BI 2. Collaborate with various business areas 3. Ensure data integrity, consistency, and quality **Description and Responsibilities:** **Working Hours:** Monday to Friday, from 8:00 AM to 6:00 PM, with a 1-hour and 30-minute lunch break **Level:** Professional **Employment Type:** Full-time – CLT **Job Activities:** * Develop and maintain dashboards and reports using Power BI, focusing on data sourced from the TOTVS RM ERP and SQL Server; * Perform extraction, transformation, and loading (ETL) of data; * Create and maintain optimized data models, applying dimensional modeling concepts (facts and dimensions); * Ensure data integrity, consistency, and quality; * Automate data collection and update routines; * Collaborate with departments such as HR, Finance, Procurement, and Operations, understanding their requirements and transforming\-them into analytical solutions; * Document processes, data sources, and data dictionaries. **Requirements:** **Requirements:** * Solid experience with Power BI (data modeling, DAX, Power Query, workspace publishing and governance); * Proficiency in SQL for writing optimized queries on SQL Server; * Knowledge of dimensional modeling and Data Warehouse architecture; * Familiarity with programming languages for data processing, such as Python or R; * Experience integrating with REST APIs (public and private); * Basic understanding of performance and security in on-premises BI environments. **Preferred Qualifications:** * Integration with Microsoft 365 (Excel, SharePoint, Outlook); * Knowledge of design tools such as Figma or Canva; * Experience with TOTVS RM ERP data; * Data governance projects; * Basic understanding of script versioning using Git. * Valid Brazilian driver's license, category B. **Benefits:** Life Insurance, Meal Allowance, Transportation Allowance