Business Intelligence Developer

Job Summary:

The BI Developer will be responsible for designing, developing, and maintaining scalable and robust BI solutions that transform complex data into actionable reports & insights. This role requires a strong understanding of data warehousing principles, ETL processes, data modeling, and proficiency in leading BI visualization tools. The ideal candidate will be a critical thinker, an excellent problem-solver, and possess strong communication skills to collaborate effectively with various business stakeholders.

PRIMARY DUTIES AND RESPONSIBILITIES:

• Design, develop, and maintain high-quality, interactive, and visually appealing dashboards and reports primarily using Microsoft Power BI Desktop and Power BI Service.

• Develop complex DAX (Data Analysis Expressions) formulas and measures to create robust calculations and advanced analytical solutions within Power BI.


• Optimize Power BI reports and dashboards for performance, efficiency, and scalability, leveraging best practices for data models and visuals.


• Manage and administer Power BI workspaces, datasets, security roles, and refresh schedules within the Power BI Service.


• Implement row-level security (RLS) and other data governance features within Power BI.


• Design and implement robust relational and dimensional data models.


• Utilize Power Query (M language) extensively to connect to diverse data sources, perform complex data transformations, cleaning, and shaping to prepare data for Power BI models.


• Develop and optimize complex SQL queries, stored procedures, and views to extract, manipulate, and load data from various relational databases (e.g., MySQL, MongoDB, other DBs) to support Power BI reporting needs.


• Understand and apply ETL/ELT processes to bring data from source systems into data warehouses, which then feed Power BI.


• Ensure data quality, integrity, and accuracy across all data sources feeding into Power BI.


• Work closely with business stakeholders, subject matter experts, and end-users to gather, analyze, and document their reporting and analytical requirements.


• Translate complex business questions into clear, concise, and effective Power BI solutions.


• Provide training and support to end-users on Power BI functionalities and developed reports, fostering a data-driven culture.


• Document technical designs, data flows, and reporting specifications for Power BI solutions.


• Monitor, troubleshoot, and optimize the performance of Power BI reports, dashboards, and underlying datasets.


• Adhere to best practices for Power BI development, deployment, and governance.


• Stay up-to-date with the latest features and updates in Microsoft Power BI and the broader Microsoft data ecosystem.

REQUIREMENTS:

• Bachelor's or master's degree in computer science or equivalent.


• Should have minimum 5+ years in business intelligence development.


• Must Needed Skills: RDBMS, Document based DB, Power BI, ETL.


• Strong SQL skills & with Microsoft Fabric workloads and data services.


• Good to have: Experience dealing with other Business Intelligence Tools.


• Ability to work independently and collaboratively within a team environment.


• Nice to have Java Microservices Knowledge.