Role Overview:

The BI Specialist is a key member of the Business Intelligence team, responsible for designing, developing, and continuously improving trusted data and reporting solutions. This is a hands-on specialist role combining strong technical expertise in Azure Databricks, data engineering, semantic modelling, and Power BI with the ability to translate business requirements into scalable insight products. Working under the direction of the Head of Business Intelligence, the role will contribute to the organisation's BI architecture, delivery standards, and governance while taking ownership of assigned solutions from discovery through to production support.

While the core responsibilities of this role are consistent across the organisation, the specific focus, priorities, and day-to-day activities will vary depending on the business area, data domain, or delivery roadmap supported. Further detail will be provided during the recruitment and screening process.
Key Responsibilities:

BI Delivery & Collaboration:

- Deliver assigned BI solutions and work packages in line with the priorities and technical direction set by the Head of Business Intelligence.
- Work with business stakeholders and BI colleagues to understand reporting needs, clarify requirements, and define appropriate technical solutions.
- Contribute to team standards, documentation, knowledge sharing, peer review, and continuous improvement of BI ways of working.
- Provide reliable progress updates, raise risks early, and take ownership of agreed deliverables through to completion.

Databricks & Data Engineering:

- Develop and maintain scalable data pipelines and analytical data products using Azure Databricks and associated Azure data services.
- Use SQL and Python/PySpark to ingest, transform, enrich, and curate data from SaaS platforms, operational systems, APIs, databases, and files.
- Apply agreed lakehouse patterns, including Delta Lake, reusable data layers, and governed datasets.
- Optimise processing, orchestration, refresh performance, storage, and compute efficiency, resolving technical issues where required.

Business Intelligence & Analytics:

- Design and deliver Power BI dashboards, reports, reusable semantic models, advanced DAX, and Power Query transformations.
- Translate business requirements into clear data definitions, analytical models, KPIs, and intuitive reporting experiences.




- Create reusable datasets that support consistent reporting and appropriate self-service analytics.
- Own assigned solutions across development, testing, deployment, adoption, maintenance, and continuous improvement.

Governance, Quality & Support:

- Follow agreed BI architecture principles, development standards, naming conventions, source-control practices, and release processes.
- Apply data quality, lineage, security, access-control, testing, monitoring, and documentation requirements across delivered solutions.
- Ensure reporting logic is transparent, traceable, and aligned to approved metric definitions and trusted source systems.
- Monitor scheduled refreshes and production performance, investigate incidents, and support timely resolution of data or reporting issues.

Automation & Continuous Improvement:

- Automate manual reporting and data-preparation activities using Databricks, Python, SQL, APIs, Power BI, and Azure services.
- Develop reusable components and frameworks for ingestion, transformation, deployment, monitoring, and metadata-driven reporting.
- Identify technical debt, reliability risks, and performance constraints within assigned solutions and recommend practical improvements.
- Explore emerging BI, data, and AI capabilities where they can improve insight quality, speed, or productivity.

Stakeholder & Delivery Management:

- Work with business owners to clarify outcomes, manage expectations, and convert requirements into practical delivery plans.
- Communicate technical concepts and analytical findings clearly to specialist and non-specialist audiences.
- Coordinate dependencies with data owners, platform teams, security, operations, and third-party suppliers.
- Maintain clear documentation and provide effective handover, training, and support for delivered BI solutions.

Qualifications & Experience:

- Strong experience delivering business intelligence and data solutions within an enterprise or complex operational environment.




- Hands-on experience with Azure Databricks, including SQL, Python/PySpark, notebooks, Delta Lake, and scalable ETL/ELT patterns.
- Advanced Power BI expertise across Desktop and Service, semantic modelling, dimensional modelling, DAX, Power Query, row-level security, deployment, and performance optimisation.
- Experience integrating data from relational databases, APIs, cloud applications, and structured file formats including Parquet, JSON, CSV, and Excel.
- Positive understanding of Azure data services, orchestration, storage, security, monitoring, and CI/CD practices.
- Proven ability to translate business requirements into governed data products, meaningful KPIs, and clear visual insight.
- Experience applying technical standards, data governance controls, testing, documentation, and production support practices.
- Strong communication and stakeholder-management skills, with the ability to collaborate effectively across business and technology teams.
- Experience with Microsoft Fabric, Azure Data Factory, Azure Dev Ops, Git Hub delivery pipelines, Power BI REST APIs, or service principals is advantageous.
- Experience in workforce solutions, talent acquisition, HR technology, or another data-rich services environment is desirable.

Ways of Working:

- Hands-on and delivery-focused, with the discipline to take ownership of work through to completion.
- Analytical and curious, able to investigate problems and identify practical solutions.
- Quality-focused, with strong attention to data accuracy, usability, documentation, and operational resilience.
- Collaborative and pragmatic, comfortable working with colleagues across business and technology teams.
- Open to feedback and committed to building technical knowledge and improving team practices.

What We Offer:

- The opportunity to contribute to the development of the Business Intelligence capability within a growing global organisation.
- Hands-on work across Databricks, Power BI, Azure, data engineering, and enterprise analytics.
- Exposure to varied business challenges and stakeholders across a global, data-rich organisation.
- A collaborative and forward-thinking culture that values technical excellence, innovation, and continuous improvement.
- Competitive compensation, performance-based incentives, and career development opportunities.

📌 BI Specialist (India)
🏢 Guidant Global India
📍 India