Business Intelligence Developer

Role overview

Core responsibilities

• Translate business and reporting requirements into BI solutions, KPI frameworks, dashboards, reports, analytical models, and visualizations.
• Develop executive dashboards, KPI scorecards, operational dashboards, management reports, and interactive analytical views.
• Define KPIs, measures, calculations, business rules, dimensions, and reporting logic.
• Analyze data for trends, patterns, anomalies, performance gaps, and business insights.
• Develop semantic, logical, and analytical data models for BI reporting.
• Use BI and visualization platforms such as Power BI, Tableau, SAP BusinessObjects, or equivalent tools.
• Write and optimize SQL queries for data extraction, transformation, validation, and analysis.
• Validate outputs, perform data profiling and quality checks, and reconcile results with source data.
• Optimize dashboard and report performance through modeling, query optimization, calculations, and refresh strategies.
• Support integration with data warehouses, databases, cloud platforms, and other data sources.
• Review outputs with stakeholders, conduct testing and UAT, and publish reports to appropriate environments.
• Maintain documentation and support governance through access controls, security, metadata, standards, ad-hoc analysis, and continuous improvement.

Required qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Business Administration, or a related field.
• Four to eight years of experience in Business Intelligence, BI Development, Data Analytics, Reporting, or a related role.
• Hands-on experience with Power BI, Tableau, SAP BusinessObjects, or an equivalent BI platform.
• Strong understanding of KPI development, dashboard design, reporting, data analysis, and BI concepts.
• Strong SQL skills and experience with relational databases.
• Experience with logical, physical, dimensional, or semantic data models.
• Experience translating business requirements into reports, dashboards, KPIs, and analytical solutions.
• Experience with multiple data sources and BI data integration.
• Strong understanding of data quality, validation, and reconciliation.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

Preferred skills

• Advanced Power BI experience, including DAX, Power Query, data modeling, and dashboard development, is preferred.
• Experience with Tableau, SAP BusinessObjects, SAP Analytics Cloud, QlikView, MicroStrategy, or similar BI platforms is preferred.
• Experience with SQL Server, Oracle, MySQL, SAP HANA, or similar databases is preferred.
• Experience with SSIS, Informatica, Talend, Azure Data Factory, or equivalent ETL technologies is preferred.
• Knowledge of Microsoft Fabric, Azure Synapse, Databricks, Snowflake, or equivalent modern data platforms is preferred.
• Knowledge of data governance, metadata management, data quality, and data management is preferred.
• Experience with executive scorecards, advanced analytics, forecasting, and Agile or Scrum tools is preferred.

Expected deliverables