Aurolab - Business Intelligence & Insights Analyst

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 (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 (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 (manual tracking or Git-based methods) and effective collaboration with cross-functional 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