Business Intelligence Developer

Job Overview

We are looking for skilled

Power BI and Advanced Excel Developers

with strong analytical, visualization, and data modeling skills. The ideal candidate will be responsible for building dashboards, creating data visualizations, automating reports, and handling complex database queries. Experience with SQL and backend integration (preferably Django) is an added advantage.

Key Responsibilities

Power BI Development

Design and develop

interactive dashboards, reports and data visualizations

to support business programs and operations.

Write and optimize

complex DAX formulas and SQL queries

for data modeling and analysis.

Connect and integrate data from multiple sources

APIs, databases, and external sources

into Power BI.

Implement

row-level security (RLS) ,

data refresh schedules , and

performance tuning

for efficient reporting.

Stay Current with Power BI features, SQL optimization techniques and industry’s best Practices.

Advanced Excel Development

Build

advanced Excel-based tools, models, and automation tools

to streamline business processes.

Strong proficiency in

lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH, etc.) ,

pivot tables , and

conditional formulas .

Ability to interpret and implement

Trucking Rater Guides

or similar rating / risk models within Excel.

Automate repetitive tasks using

macros and VBA

(preferred but not mandatory).

Work on cross-sheet data consolidation, validation, and data visualization in Excel.

SQL / Backend Development

Design and optimize

SQL queries, views, and stored procedures

for data extraction and transformation.

Need to ensure

data integrity and efficiency .

Familiarity with the

Django framework

or other backend platforms is a plus.

Understand

database relationships, indexing, and normalization

for report performance optimization.

Required Skills & Qualifications

Bachelor’s degree in computer science, Data Analytics, Information Systems, or related field.

3+ years of hands-on experience in

Power BI development, Advanced Excel development

and

SQL .

Proficiency in

data modeling ,

DAX ,

Power Query (M language) ,

Advanced Excel

functions and formulas.

Strong understanding of

SQL (PostgreSQL) .

Good understanding of

data structures ,

ETL processes , and

database design .

Ability to manage multiple projects with attention to detail and deadlines.