Senior Business Intelligence Consultant

KWA Analytics; Mexico; On-site; PHP 7,299,000 - 9,732,000; Full time

Job summary

KWA Analytics in a dynamic BI environment seeks a Senior BI Developer to design and deliver enterprise Power BI reporting using Databricks data. You will build scalable dashboards, semantic models, and robust security controls while collaborating with Databricks engineers and business stakeholders to ensure accuracy and performance.

Ideal candidates bring deep Power BI expertise, extensive data modeling experience, and a track record in fast-paced Agile settings, delivering reports end-to-end

Qualifications

• 5+ years experience building enterprise BI solutions.
• Advanced Power BI development and semantic modeling.
• Strong dimensional modeling and large dataset handling.
• Experience creating dashboards and operational reports.
• Experience with row-level security and performance tuning.
• Experience in Agile teams and collaborating with stakeholders.

Responsibilities

• Design and develop enterprise-grade Power BI reports and dashboards.
• Build reports using Databricks Gold datasets and semantic models.
• Translate requirements and wireframes into production reports.
• Develop DAX measures, calculations, filters, hierarchies, drill-downs.
• Create reusable components and templates to accelerate delivery.
• Maintain Power BI semantic models and optimize performance.
• Collaborate with Databricks engineers to define data needs.
• Partner with analysts to validate requirements and UAT support.
• Support deployment, CI/CD, testing, and documentation.

Skills

Power BI

DAX

SQL

Power Query

Semantic Modeling

Dimensional Modeling

Performance Optimization

Row-Level Security

Tools

Databricks

Databricks SQL

Unity Catalog

Microsoft Fabric

Git / CI/CD

Job description

Role Overview

We are seeking experienced Senior BI Developers to join a large-scale Openlink-to-Databricks reporting modernization program.

The role will be responsible for designing and developing enterprise reports and dashboards using certified datasets produced within Databricks. The reporting scope covers Front Office, Risk, Credit, Accounting, Settlements, Operations, and Management Reporting.

The successful candidate will work within a high-velocity delivery environment where multiple reporting workstreams operate concurrently. The emphasis will be on building reusable, scalable reporting solutions rather than embedding report-specific business logic independently within each report.

Key Responsibilities

• Design and develop enterprise-grade Power BI reports and dashboards.
• Build reports using certified Databricks Gold datasets and approved semantic models.
• Translate functional requirements and wireframes into production reporting solutions.
• Develop DAX measures, calculations, filters, hierarchies, and drill-down capabilities.
• Build reusable report components and templates to accelerate delivery.
• Develop and maintain Power BI semantic models where appropriate.
• Work closely with Databricks engineers to identify reporting data requirements.
• Partner with business analysts and SMEs to validate business requirements.
• Support reporting across areas including:
• Trading
• Position and P&L
• Risk and sensitivities
• Accounting
• Settlements and invoicing
• Management reporting
• Implement row-level security and appropriate access controls.
• Optimize reports and semantic models for performance.
• Conduct unit and functional testing.
• Reconcile report outputs against Databricks datasets and source-system control totals.
• Investigate and resolve data and reporting discrepancies.
• Support business UAT and defect remediation.
• Participate in peer reviews and enforce reporting development standards.
• Support automated deployment and CI/CD processes.
• Produce technical documentation and support production transition.

Required Experience

• 5+ years of experience developing enterprise Business Intelligence solutions.
• Advanced Power BI development experience.
• Experience building and maintaining Power BI semantic models.
• Strong understanding of dimensional data modeling.
• Experience developing dashboards and detailed operational reports.
• Experience working with large enterprise datasets.
• Experience implementing row-level security.
• Experience troubleshooting and optimizing report performance.
• Experience working with Agile development teams.
• Strong analytical and problem-solving capabilities.
• Ability to work effectively with technical teams and business stakeholders.

Preferred Experience

• Experience developing reports directly against Databricks.
• Experience with Databricks SQL.
• Understanding of Delta Lake and Medallion Architecture.
• Experience with Microsoft Fabric.
• Experience with Azure data platforms.
• Experience with financial-services, energy, commodity trading, or risk reporting.
• Experience with Openlink Endur or other ETRM/CTRM platforms.
• Experience with high-volume report migration or modernization programs.
• Power BI or Databricks certifications.

Key Technical Skills

Required

• Power BI
• DAX
• SQL
• Power Query
• Semantic Modeling
• Dimensional Modeling
• Performance Optimization
• Row-Level Security

Preferred

• Databricks
• Databricks SQL
• Unity Catalog
• Microsoft Fabric
• Git / CI/CD

Role Profile

This position is best suited to a hands-on senior developer who can independently take a report from approved requirements and wireframes through development, testing, reconciliation, UAT, and production deployment.

The project will operate using a report factory approach, with multiple BI developers working concurrently against common Databricks data products. Developers must therefore be comfortable working within established architecture and development standards while delivering reports at a rapid cadence.

Experience working with complex financial or trading datasets is particularly valuable because report accuracy, reconciliation, data lineage, and consistent business calculations are critical to the program.