(1564) Senior BI Consultant
Nortal · São Paulo, São Paulo, Brazil
Join Nortal for your next big adventure. We are seeking **Senior BI Consultant** to join our team, grow with us, and teach us a few things along the way. **Why join Nortal** * Say Goodbye to Micromanagement: We champion autonomy, open communication, and respect for diversity as our core values. * Outcomes Over Hours: We believe in a work model focused on impact, providing you with the flexibility to balance your professional success with your personal well\-being. * Vibrant Community: Join our close\-knit LATAM remote team and connect through tech talks, virtual coffee breaks, and team\-building activities. * Support from Day One: Our People Care team is here to support you throughout your journey, from wellness check\-ins to professional growth. **Our benefits** ✨ * Competitive USD salary. * 100% remote work: While you can work from anywhere, you’re always welcome to connect with teammates and grow your network at our coworking spaces across LATAM. * Paid time off \& national holidays: Take the time you need according to your country’s regulations while receiving your full salary. * Sick leave: Focus on your health without stress. Take the necessary time to recover and feel better. * Annual credit: Spend it on the perks you love to enhance your work\-life balance. * Team\-building activities: Join us for coffee breaks, tech talks, and after\-work gatherings to bond with your Nortal family and feel part of our vibrant community. * Birthday off: Enjoy an extra day off during your birthday week to celebrate in style with friends and family. **About The Project** As we continue to grow, we are looking to add a Senior BI Consultant to our team. If you are passionate about turning complex data into clear, actionable insights and thrive on owning a BI solution end\-to\-end, this is a great opportunity for you. This role sits within our Business Intelligence \& Analytics practice and owns the technical and consultative quality bar from requirements gathering through delivery. You will work closely with business stakeholders, data engineers, and technical teams, combining strong hands\-on skills in Power BI, Microsoft Fabric, and SQL with a solid understanding of business requirements and performance management. This is a role where technical depth, business understanding, and ownership across the entire BI lifecycle are equally important. What you'll do * Design and implement end\-to\-end Business Intelligence solutions based on business and analytical requirements. * Work closely with business stakeholders to understand objectives, KPIs, processes, and reporting needs. * Translate business requirements into effective data models, analytical solutions, and visualizations. * Develop and maintain Power BI dashboards, reports, semantic models, and DAX measures. * Design and implement scalable data models using dimensional modeling and best practices. * Develop and optimize SQL queries, stored procedures, views, and data transformation processes. * Design and implement ETL/ELT processes for integrating data from multiple sources. * Work with Microsoft Fabric components such as Lakehouse, Data Warehouse, pipelines, notebooks, and semantic models. * Contribute to modern Medallion Architecture (Bronze/Silver/Gold) implementations. * Ensure data quality, consistency, performance, security, and scalability across BI solutions. * Analyze existing BI solutions and identify opportunities for optimization and modernization. * Define and implement KPIs, metrics, balanced scorecards, and management reporting solutions. * Troubleshoot data, reporting, and performance issues across the BI stack. * Collaborate with Data Engineers, Solution Architects, Developers, and business teams. * Provide technical guidance and mentoring to less experienced BI professionals. What makes you a great fit * Bachelor's Degree in Computer Science, Engineering, or related * 7\+ years of professional experience in Business Intelligence, Data Analytics, Data Warehousing, or a related field. * Strong hands\-on experience with Power BI, including advanced DAX and semantic models. * Strong SQL skills, including query optimization and complex data transformations. * Solid understanding of data modeling, dimensional modeling, star schemas, facts, dimensions, and slowly changing dimensions. * Experience designing and implementing ETL/ELT processes. * Hands\-on experience with Microsoft Fabric or equivalent modern data platforms. * Experience with data warehouse and/or lakehouse architectures, and understanding of Medallion Architecture. * Experience integrating data from multiple sources such as relational databases, APIs, files, ERP, CRM, or cloud platforms. * Strong understanding of BI architecture and the complete data\-to\-insight lifecycle. * Experience gathering and translating business requirements into technical solutions. * Strong analytical and problem\-solving skills, with excellent communication and stakeholder management abilities. * Advanced Eng