DATA ANALYST

Description

Job Summary: Ernesto Borges Advogados is seeking a professional to design and implement data pipelines, optimize data models, and develop Power BI dashboards, ensuring data governance and security. Key Highlights: 1. Working with Microsoft Fabric and Power BI technologies 2. Focus on data governance, security, and versioning 3. Collaborating to promote a data-driven culture **Job Description:** For seventy years, Ernesto Borges Advogados has provided legal services to resolve judicial, arbitral, and extrajudicial disputes. With a substantial multidisciplinary experience portfolio, the firm serves its clients’ interests in strategy definition, legal opinions, business development, and contract drafting and structuring. The firm excels across comprehensive practice areas and economic sectors and has earned numerous awards and recognitions in various fields of law—regional, national, and international. These achievements stem from its commitment to delivering excellence in legal services, efficiently led by its leadership and persistently executed by all professionals comprising the Ernesto Borges Advogados team. Responsibilities and Duties Design and implement data pipelines in Microsoft Fabric (Data Factory, Dataflow Gen2, Lakehouse). Create and optimize data models in Power BI. Develop dashboards in Power BI. Ensure best practices for data governance, security, and versioning. Perform integrations across diverse sources (ERP, CRM, SQL Server, APIs, Excel, SharePoint, etc.). Collaborate with business units to translate requirements into BI solutions. Monitor and optimize report and pipeline performance. Support the promotion of data literacy and best practices for self\-service BI. **Requirements:** Bachelor’s degree completed in Data Science, Information Systems, Systems Analysis and Development, Production Engineering, Statistics, or Mathematics. Desirable: short courses in legal, administrative, and technological fields. Intermediate/Advanced Excel proficiency. **Microsoft Fabric:** proficiency in Lakehouse, Dataflows, Data Pipelines, and integration with OneLake. **Power BI:** DAX, Power Query, Row-Level Security (RLS). **Databases:** SQL (T\-SQL, Postgres or similar) for queries and relational modeling. **Data Integration:** REST APIs, Microsoft 365 connectors, and external connectors. **Data Architecture:** concepts of layers (bronze, silver, gold), data lake, data warehouse, governance. **Versioning and DevOps:** Git, publication pipelines, and version control for datasets and reports. **Advanced Excel:** analysis, formulas, pivot tables, integration with Power BI.