BI Developer

Job Description :

Work Schedule

Environmental Conditions

BI Developer

Location:

Bangalore, India

Department:

IT CoE

Reports To:

Sr Manager

Position Summary:

The BI Developer is responsible for designing, developing, and delivering business intelligence and analytics solutions that support data-driven decision-making across operational and business domains.

This role combines technical skills with functional understanding to translate business requirements into effective data models, dashboards, and reports. The position contributes to maintaining data quality, optimizing reporting solutions, and supporting analytics initiatives aligned with enterprise data strategy.

Key Responsibilities:

Business Analysis & Requirements Management

• Collaborate with business stakeholders to gather, analyze, and document reporting requirements.
• Assist in defining KPIs, metrics, and data definitions.
• Support creation of functional specifications, source-to-target mappings, and technical documentation.
• Ensure alignment between business requirements and developed BI solutions.

BI Development & Technical Execution

• Develop dashboards and reports using Power BI (PBI), including DAX and data modeling.
• Support development and maintenance of semantic models (e.g., SSAS tabular or Power BI datasets).
• Write and optimize SQL queries in Amazon Redshift or similar databases.
• Perform basic performance tuning for dashboards and queries.
• Support UAT, deployment, and post-production activities.

Data Engineering & Platform Support

• Assist in developing data transformation workflows using Databricks (Spark, PySpark, SQL).
• Support ETL/ELT pipeline development and maintenance for BI workloads.
• Work with Delta Lake concepts such as data storage, partitioning, and versioning.
• Integrate data pipelines with AWS services (S3, Redshift, Glue).
• Monitor and troubleshoot data pipelines to ensure reliability.

Analytics & Innovation Support

• Contribute to analytics use cases such as reporting automation and basic trend analysis.
• Support implementation of AI/ML or GenAI-enabled reporting features where applicable.
• Explore opportunities for improving insights through enhanced reporting capabilities.

Collaboration & Support

• Work with BI Leads, product owners, and data engineers to deliver solutions.
• Participate in issue resolution and support activities.
• Provide documentation and basic knowledge transfer to end users.

Qualifications:

Education & Experience

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field required.
• 4-6 years of experience in BI development, reporting, or data engineering.
• Experience in operational or business analytics domains preferred.

Skills & Knowledge

Business Analysis

• Basic to strong skills in requirement gathering and documentation.
• Exposure to business systems such as ERP (SAP), CRM (SFDC), or similar platforms.

BI & Reporting

• Proficiency in Power BI (DAX, Power Query, data modeling).
• Working knowledge of SSAS tabular models or Power BI semantic models.
• Strong SQL skills with experience in Redshift or similar data warehouses.

Data Engineering

• Hands-on experience or exposure to Databricks (Spark/PySpark, SQL).
• Understanding of ETL/ELT processes and data warehousing concepts.
• Familiarity with AWS services (S3, Redshift, Glue) is a plus.

Analytics

• Basic understanding of analytics concepts and data interpretation.
• Exposure to AI/ML or Generative AI concepts is an advantage.

Additional

• Experience working in Agile/Scrum environments preferred.
• Relevant certifications in Power BI, AWS, or Databricks are a plus.