Job Description - Lead Business Intelligence Consultant

Company : Supersourcing

Client : Elanco

Employment Type : Full-Time

Experience : 3 - 4 Years

Location : Bengaluru

Work Model : Hybrid - 3 Days Work From Office

About the Role :

We are looking for a Business Intelligence Consultant to join the Global Enterprise Data & Analytics (ED&A) team, supporting enterprise-wide commercial analytics and data-driven decision-making.

In this role, you will work with complex business datasets, develop insightful dashboards, and transform raw data into meaningful business intelligence. You will collaborate with cross-functional stakeholders to understand business challenges, identify analytical opportunities, and deliver scalable reporting and visualization solutions.

The ideal candidate should have strong hands-on experience with BI tools such as Power BI or Tableau, advanced SQL skills, and a good understanding of data modelling, data warehousing, and ETL processes.

We are looking for someone who combines technical expertise with business understanding and can communicate analytical findings effectively to business stakeholders.

Key Responsibilities :

1. Business Intelligence & Data Analytics :

- Analyze large and complex datasets to identify business trends, patterns, performance gaps, and opportunities.

- Translate business requirements into meaningful analytical solutions and reporting dashboards.

- Generate actionable insights to support strategic planning and operational decision-making.

- Develop, maintain, and enhance interactive dashboards and business performance reports.

- Present analytical findings through clear visualizations and concise business summaries.

2. Dashboard Development & Data Visualization :

- Design and develop interactive dashboards using Power BI, Tableau, or similar BI platforms.

- Create meaningful KPIs, performance metrics, reports, and visualization frameworks.

- Ensure dashboards are user-friendly, scalable, accurate, and aligned with business requirements.

- Improve existing dashboards and reporting processes to enhance usability and performance.

3. SQL & Data Modelling :

- Write and optimize SQL queries to extract, transform, validate, and analyze data from multiple sources.

- Work with relational databases and cloud-based data platforms such as SQL Server, Databricks, and Google Cloud Platform.

- Develop and maintain data models, data relationships, and reporting structures.

- Understand data warehouse architecture, ETL workflows, and data integration processes.

4. Data Preparation & Quality Management :

- Perform data cleansing, transformation, validation, and reconciliation to ensure reporting accuracy.

- Work with data preparation and ETL tools such as Power Query, Tableau Prep, and Alteryx.

- Establish data quality checks and support data governance standards.

- Ensure consistency, accuracy, security, and compliance across analytical datasets.

5. Stakeholder Collaboration :

- Collaborate with global ED&A teams and commercial business stakeholders to understand analytical requirements.

- Convert complex business questions into structured data analysis and BI solutions.

- Communicate insights and recommendations effectively to both technical and non-technical audiences.

- Support continuous improvement of enterprise reporting and analytics capabilities.

Required Technical Skills :

BI & Data Visualization :

- Strong hands-on experience with Power BI or Tableau.

- Experience developing interactive dashboards, reports, KPIs, and data visualizations.

SQL & Database Technologies :

- Strong SQL skills, including joins, aggregations, subqueries, CTEs, and analytical queries.

- Experience working with SQL Server, Databricks, GCP, or similar database platforms.

Data Modelling & ETL :

- Understanding of data modelling, data warehousing, and database concepts.

- Experience with ETL processes and data transformation.

- Familiarity with Power Query, Tableau Prep, Alteryx, or similar data preparation tools.

Analytics & Programming :

- Strong analytical and problem-solving abilities.

- Understanding of business metrics, data interpretation, and reporting methodologies.

- Exposure to Python, R, or other programming languages for data manipulation and analysis is an advantage.

Good to Have :

- Experience working with global or enterprise analytics teams.

- Exposure to commercial analytics, sales analytics, or business performance reporting.

- Familiarity with cloud-based data platforms and modern data environments.

- Understanding of data governance, data quality, and compliance practices.

- Relevant certifications in Power BI, Tableau, or Data Analytics.

Education :

- Bachelor's or Master's degree in Computer Science, Engineering, Business Administration, Data Analytics, or a related discipline.

What We Are Looking For :

- A technically strong BI professional with the ability to understand business problems.

- Someone who can independently develop dashboards and perform complex SQL-based analysis.

- Strong communication skills with the ability to present insights to global stakeholders.

- A detail-oriented professional who values data accuracy, quality, and consistency.

- Ability to work collaboratively in a global, cross-functional environment.

Join Supersourcing and work with Elanco's Global Enterprise Data & Analytics team to turn complex data into meaningful business intelligence and business impact.