Senior BI Consultant

Nortal; Brasil; Teletrabalho; BRL 180 000 - 280 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Remote LATAM team

Tech talks & virtual coffee breaks

Wellness support

Resumo da oferta

Nortal is seeking a senior BI Engineer to design and implement end-to-end BI solutions for our LATAM remote team. You will collaborate with stakeholders to translate objectives into data models, dashboards, and reports, and you will own data quality and performance across the BI stack.

You will work with Power BI, SQL, and modern data platforms like Microsoft Fabric, building scalable models and meaningful KPIs for US clients while enjoying a flexible remote setup and opportunities for

Qualificações

• 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.
• Experience designing and implementing ETL/ELT processes.

Responsabilidades

• Design and implement end-to-end BI 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.

Conhecimentos

Power BI

Data analytics

Stakeholder management

English communication

Formação académica

Bachelor's degree in Computer Science, Engineering, or related

Ferramentas

SQL

Microsoft Fabric

Descrição da oferta de emprego

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.

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 English Level is required for this role, as you will work with US clients.


• Effective communication in English is essential to deliver the best solutions to our clients and expand your horizons