SENIOR BI CONSULTANT
Jobgether
Full-timesenior
Sign in to applyFree account, takes a minute.
Job description
Accountabilities
• 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.
Requirements
• 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.
Benefits
• 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.
• Opportunity to work on complex digital transformation initiatives and deliver measurable value for global clients.
How Jobgether works:
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Why Apply Through Jobgether?
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1
Skills
Power BIDAXSQLMicrosoft FabricETLELTData ModelingDimensional ModelingStar SchemasSlowly Changing DimensionsData WarehouseLakehouseMedallion ArchitectureSemantic ModelsStored ProceduresViewsData Transformation