BI Developer

Role & responsibilities

• Design, develop, and maintain interactive dashboards, scorecards, and reports using Power BI and Tableau. • Build and optimize Power BI semantic models and Tableau data sources to support business reporting and analytics needs. • Develop advanced DAX measures and Power Query transformations for data preparation and analysis. • Troubleshoot and resolve data model, report performance, and data quality issues. • Design and maintain dimensional data models including fact and dimension tables. • Analyze business data to identify trends, patterns, anomalies, and performance improvement opportunities. • Develop KPI frameworks, metrics definitions, and executive reporting dashboards. • Create meaningful visualizations and data stories that support business decision-making. • Support self-service analytics initiatives by creating reusable datasets and governed reporting assets. • Collaborate with data engineering teams to ensure data is accurate, complete, and analytics-ready. • Participate in BI deployments, report migrations, and environment management activities. • Document BI solutions, data models, reporting processes, and business definitions.

Must Have:

Power BI • Strong experience developing reports, dashboards, and scorecards in Power BI. • Hands-on experience with data modeling, relationships, star schemas, and semantic models. • Proficiency in DAX including calculated measures, time intelligence, and performance optimization. • Experience with Power Query (M) for data transformation and preparation. • Knowledge of Power BI Service features including workspaces, deployment pipelines, Row Level Security (RLS), and scheduled refreshes. • Experience implementing self-service reporting solutions and reusable datasets. Tableau • Experience building interactive dashboards and visualizations using Tableau. • Understanding of Tableau Server/Tableau Cloud and published data sources. • Ability to optimize dashboard performance and user experience. • Experience designing enterprise reporting and analytics solutions using Tableau. Microsoft Excel • Advanced proficiency in Microsoft Excel for reporting, analytics, and data management. • Strong experience with Pivot Tables, Pivot Charts, Power Pivot, and Power Query. • Expertise in advanced Excel formulas and functions such as XLOOKUP, INDEX MATCH, SUMIFS, COUNTIFS, and logical functions. • Experience performing data reconciliation, validation, trend analysis, and ad-hoc reporting. • Ability to create automated reports, KPI scorecards, and executive reporting templates.