BI Developer

Exillar Infotech Pvt Ltd; Ahmedabad District; On-site; INR 650,000 - 900,000; Full time

Job summary

Exillar Infotech Pvt Ltd in Ahmedabad seeks a BI Developer to own end-to-end BI solutions from requirements to dashboards and user enablement.

The role emphasizes SQL proficiency, data modeling, and strong communication to translate business needs into actionable insights. Collaboration with data engineers is key for reliable pipelines and scalable reporting.

Qualifications

• 2+ years in BI development or related data role.
• Power BI proficiency with DAX, Power Query, data modeling, and report publishing.
• Strong SQL skills including complex joins, window functions, and optimization.
• Experience with relational databases (SQL Server, MySQL, PostgreSQL).
• Understanding of data warehousing concepts (Star/Snowflake schema).
• Ability to manage a reporting requirement from brief to delivery.
• Strong analytical thinking and clear communication with stakeholders.

Responsibilities

• Design, develop, and maintain dashboards, reports, and scorecards in Power BI.
• Gather, document, and translate business requirements into BI solutions.
• Write, optimize, and maintain complex SQL queries for data extraction and reporting.
• Build semantic data models with relationships, hierarchies, DAX measures, and KPIs.
• Collaborate with Data Engineering to ensure clean data pipelines.
• Tune performance of reports, datasets, and queries for scalability.
• Document dashboards, data definitions, sources, and business logic.
• Provide user walkthroughs and BI tool support across teams.
• Identify reporting gaps and data quality issues for improvement.

Skills

Power BI

SQL

Data modeling

DAX

Power Query

Analytical thinking

Communication

Education

Bachelor's degree in computer science/IT or related field

Tools

SQL Server

MySQL

PostgreSQL

Azure Synapse/Databricks (nice to have)

Job description

Exillar is an Ahmedabad-based technology company specializing in Business Intelligence, Data Engineering, and AI-powered solutions. We partner with businesses to transform complex, siloed data into actionable insights -building scalable data infrastructure and intelligent reporting systems that drive real decisions.

We are seeking a detail-oriented and technically strong BI Developer to join our core delivery team. You will own the end-to-end development of business intelligence solutions -from requirement gathering and data modeling to dashboard delivery and user enablement. This role sits at the intersection of data engineering and business analysis, making it ideal for someone who is equally comfortable with SQL and storytelling through data.

Key Responsibilities

• Design, develop, and maintain interactive dashboards, reports, and scorecards using Power BI
• Engage with internal teams and clients to gather, document, and translate business requirements into BI solutions
• Write, optimize, and maintain complex SQL queries for data extraction, transformation, and reporting
• Build and manage semantic data models including relationships, hierarchies, DAX measures, and KPIs
• Collaborate with the Data Engineering team to ensure reliable, clean, and well-structured data pipelines
• Perform performance tuning of reports, datasets, and queries to ensure scalability
• Maintain documentation for dashboards, data definitions, data sources, and business logic
• Conduct user walkthroughs and provide support for BI tools across teams
• Proactively identify reporting gaps, data quality issues, and opportunities for improvement

Required Skills & Qualifications

• 2+ years of hands-on experience in BI development or a closely related data role
• Strong proficiency in Power BI -including DAX, Power Query (M), data modeling, and report publishing
• Solid command of SQL -complex joins, window functions, aggregations, and query optimization
• Experience with relational databases such as SQL Server, MySQL, or PostgreSQL
• Sound understanding of data warehousing principles -Star/Snowflake schema, fact and dimension tables
• Ability to independently manage a reporting requirement from brief to delivery
• Strong analytical thinking, problem-solving ability, and attention to detail
• Effective communication skills -ability to explain data findings to non-technical stakeholders
• Bachelor's degree in computer science, Information Technology, or a related field

Good to Have

• Experience with cloud platforms -Microsoft Azure (preferred), AWS, or GCP
• Hands-on exposure to Azure Synapse Analytics, Databricks, or similar modern data platforms
• Knowledge of ETL/ELT concepts and data pipeline tools
• Basic Python skills for data manipulation and automation
• Familiarity with version control (Git) for BI project management
• Exposure to Agile or sprint-based delivery environments

Who Will Thrive in This Role

Someone who takes ownership of their work, is curious about data, and enjoys turning messy, complex datasets into clean, intuitive visual stories. If you have a habit of asking “why does this number look off?” -you’ll fit right in.

What We Offer

• Work on high-impact, real-world data projects across multiple industries
• Collaborative team environment with direct exposure to BI, Data Engineering, and AI domains
• Structured growth path within a fast-scaling technology company
• A culture that values output, learning, and initiative