Business Intelligence

Role Summary

We are looking for a high-impact Business Intelligence and insights Analyst to help shape the next phase of Aurolab's digital and data transformation journey. This role is ideal for someone who combines deep BI expertise with a strong understanding of business processes and can influence decision-making across the organization through insightful, predictive dashboards.

The candidate must have experience working in dynamic business environments, handling and solving simple to complex data and process problems. You will be critical in embedding a dashboard-driven decision-making culture across functions such as Finance, SCM, HR, Sales, and Manufacturing, enabling faster, more informed, and forward-looking decisions.

Key Responsibilities:

• Process & Metric Understanding:

Partner with functional heads to deeply understand workflows, KPIs, and process drivers. Translate these into structured metrics that reflect both operational performance and strategic objectives.

• Advanced Analytics & Dashboard Development:

Design and build interactive dashboards using Tableau with drill-downs, dynamic filters, and executive summaries. Incorporate diagnostic, predictive, and prescriptive analytics to move beyond descriptive reporting.

• Insight Generation:

Analyze trends, variances, and patterns to uncover actionable insights. Recommend process improvements, performance enhancements, or risk mitigations backed by data.

• Data Integration & Automation:

Integrate data from multiple sources (ERP – Microsoft Dynamics BC, Salesforce, HRMS, SQL DBs, Excel, Data Lake). Collaborate with IT/Data Engineering to automate pipelines and ensure data governance and integrity.

• Cultural Change Agent:

Drive a dashboard-driven decision-making mindset across the organization—coach departments on interpreting insights and leveraging dashboards for operational and strategic choices.

• Documentation & Collaboration:

Maintain comprehensive documentation, including data dictionaries, KPI definitions, and dashboard user manuals. Lead or contribute to cross-functional analytics, automation, or digital transformation projects.

Technical Skills & Tools

• BI Tools:

Tableau (Mandatory): Strong experience designing interactive dashboards using Tableau Desktop, publishing and managing them via Tableau Server or Tableau Cloud. Proficiency in Tableau Prep for data cleaning, reshaping, and prep workflows.

• Data Handling:

SQL (Mandatory): Strong in writing complex queries, joins, and subqueries, as well as optimizing for performance—Excel (Advanced): Pivot tables, Power Queries, and integrations with Tableau.

• Data Integration & Pipelines:

Experience connecting Tableau to diverse data sources: ERP (e.g., Business Central), Salesforce, flat files (Excel/CSV), and on-prem databases. Familiarity with building basic data pipelines using tools like Power Query, Dataflows, or scripting-based ETL (e.g., Python scripts or SQL-based ETL jobs).

• Analytics:

Exposure to fundamental statistical analysis and forecasting techniques. Capability to integrate calculated fields, parameters, sets, and LOD expressions in Tableau to enable dynamic insights.

• Documentation, Storytelling & Collaboration:

Ability to document KPI definitions, data dictionaries, and dashboard usage guides with clarity and structure. Strong capability to tell a compelling business story using dashboards and PowerPoint presentations, tailored for leadership teams. Familiarity with dashboard version control (e.g., manual tracking or Git-based methods) and effective collaboration with cross-functional stakeholders.

Qualifications

- Bachelor's or Master's degree in Data Science, Business Analytics, Engineering, Statistics, or related field

- 4–6 years of relevant experience in BI, data analytics, or insights roles

- Proven ability to work with business leaders, understand processes, and translate into meaningful KPIs and dashboards

- Excellent written and verbal communication skills with a business storytelling mindset

- Experience in manufacturing, healthcare, or regulated industries is an added advantage

What We Offer

- A pivotal role in Aurolab's data-driven transformation journey

- Exposure to end-to-end analytics — from raw data to boardroom decision impact

- Opportunity to collaborate closely with senior leadership and cross-functional teams

- Access to digital initiatives like ERP modernization, data lake development, and AI-readiness projects

- A culture that values ownership, innovation, and continuous learning