Senior BI Consultant

Join a high-performing Business Intelligence and Analytics practice focused on turning complex data into clear, actionable business insights. Local São Paulo - SP 100% remoto

Responsabilidades

Design and implement end-to-end Business Intelligence solutions aligned with business, analytical, and reporting requirements. Partner with business stakeholders to understand objectives, processes, KPIs, performance measures, and reporting needs. Translate business requirements into effective data models, analytical solutions, dashboards, and visualizations. Develop and maintain Power BI dashboards, reports, semantic models, and advanced DAX measures.

Design scalable data models using dimensional modeling principles, star schemas, facts, dimensions, and slowly changing dimensions. Develop, optimize, and maintain SQL queries, stored procedures, views, and complex data transformation processes. Design and implement ETL/ELT pipelines that integrate information from multiple data sources. Work with Microsoft Fabric capabilities including Lakehouse, Data Warehouse, pipelines, notebooks, and semantic models.

Contribute to modern Medallion Architecture implementations across Bronze, Silver, and Gold data layers. Ensure BI solutions meet high standards for data quality, consistency, security, scalability, and performance. Assess existing BI environments and identify opportunities for modernization, optimization, and improved business value. Define and implement KPIs, metrics, balanced scorecards, and management reporting solutions. Troubleshoot data, reporting, and performance issues across the BI technology stack.

Collaborate with Data Engineers, Solution Architects, Developers, and business teams throughout the full data-to-insight lifecycle. Provide technical guidance and mentoring to less experienced BI professionals. Communicate findings, recommendations, and technical considerations clearly to both technical and non-technical stakeholders.

Requisitos

Bachelor's degree in Computer Science, Engineering, or a related discipline, or equivalent professional experience. 7+ years of professional experience in Business Intelligence, Data Analytics, Data Warehousing, or a closely related field. Strong hands-on expertise with Power BI, including advanced DAX, semantic models, dashboards, and reporting solutions. Advanced SQL skills, including query optimization, complex transformations, stored procedures, and views.

Strong understanding of data modeling and dimensional modeling concepts, including star schemas, facts, dimensions, and slowly changing dimensions. Proven experience designing and implementing ETL/ELT processes and integrating data from multiple sources such as databases, APIs, files, ERP, CRM, and cloud platforms. Hands-on experience with Microsoft Fabric or comparable modern data platforms. Experience with data warehouse and/or lakehouse architectures and a practical understanding of Medallion Architecture.

Strong understanding of BI architecture and the complete lifecycle from raw data through transformation, modeling, analysis, and business insight. Demonstrated ability to gather business requirements and translate them into practical, scalable technical solutions. Strong analytical, problem-solving, and troubleshooting skills, combined with a structured and detail-oriented approach.

Excellent stakeholder management and communication skills, with the ability to collaborate effectively across business and technical teams. Advanced English proficiency is required to work effectively with international and US-based clients.

Benefícios

Competitive USD salary. 100% remote work from Brazil and across the LATAM region. Flexible work model focused on outcomes and impact rather than hours worked. Access to coworking spaces across LATAM. Paid time off and national holidays according to local regulations, with full salary maintained. Sick leave to support health and wellbeing. Annual flexible credit to spend on benefits and perks that enhance work-life balance. Birthday day off during your birthday week.

Team-building activities, including coffee breaks, technical talks, and social gatherings. Support from a dedicated people-focused team throughout your professional journey. Opportunities for professional growth, continuous learning, and development. Collaborative and inclusive remote culture with strong connections across international teams. Sobre A Empresa: Join a high-performing Business Intelligence and Analytics practice focused on turning complex data into clear, actionable business insights.