At H&P, our people are our strength.

Job Overview

We are hiring a BI Engineer for our Advanced Analytics and Reporting team. This role is best suited for someone with a strong curiosity to understand business operations and a passion for creating data pipelines and turning data into meaningful insights. You will act as a solution partner to stakeholders, translating business requirements into impactful analytics solutions using Databricks, Microsoft Fabric and Power BI. A key focus of this role is continuous learning, both in understanding the business and adopting modern technologies such as AI-driven Business Intelligence, including conversational and agentic experiences within reports. The ideal candidate should have ability to create modular, robust and scalable data pipelines with an eye for intuitive, visually compelling dashboards, along with the ability to explore data, uncover insights, and communicate clear data stories.

Responsibilities

Partner with stakeholders to understand business operations, KPIs, and BI requirements.
Translate requirements into well-defined Jira epics, stories, and acceptance criteria.
Translate business logics and requested transformation into accurate and efficient Scripts (PySpark, SparkSQL, Power Query).
Build and optimize Fabric and Databricks Pipelines and Notebooks for performance and reliability.
Monitor pipeline(s) for efficiency, cost effectiveness, stability and for continuous data flows.
Design and develop scalable pipelines and data models with Databricks (ADF, ADLS, Databricks Notebooks) and Microsoft Fabric (Lakehouse, Direct Lake, Dataflows).
Work with IT Team and other concerned departments to fix any source level data issues including break in data flow/refresh.
Develop Power BI reports and dashboards with a focus on usability, performance, and visual storytelling.
Leverage AI-driven BI capabilities (insights, conversational/agentic experiences) to enhance user interaction.
Perform data analysis to uncover trends, insights, and actionable recommendations.
Ensure data quality, consistency, governance, and security across all reporting solutions.
Work closely with senior developers and cross-functional teams to deliver high-quality solutions.
Present insights and solutions to stakeholders, enabling data-driven decision-making.
Maintain clear technical and functional documentation for all deliverables.
Continuously learn and adopt new technologies in Fabric and AI to improve BI capabilities.

Required Skills

Solid experience with Databricks Notebooks (PySpark/SparkSQL) for data transformation and advanced analytics.
Experience in creating data pipelines using ADF, ADLS, Databricks Notebooks and MS Fabric.
Strong expertise with Notebook optimization (PySpark/SparkSQL).
Advanced expertise in Power BI (Desktop & Service), including DAX, Power Query, and semantic data modeling.
Strong experience in building scalable, high-performance data models and optimizing report performance.
Hands-on experience with the Microsoft Fabric ecosystem (Lakehouse, Dataflows Gen2, Warehouses, Deployment Pipeline).
Proficiency with version control tools like GitHub.
Solid understanding of data architecture (ETL/ELT, medallion architecture, data pipelines).
Experience in data analysis, with the ability to derive insights and present compelling data stories.
Strong focus on data visualization, UX, and intuitive dashboard design.
Experience implementing Row Level Security (RLS) and data governance practices.
Exposure to Paginated Reports and enterprise reporting standards.
Hands-on experience or strong interest in Agentic AI / AI-driven BI, including:

Conversational analytics and chatbot integrations
AI-assisted insights within BI tools

Experience integrating Power BI with external services/APIs for enhanced interactivity.
Familiarity with CI/CD practices and version control in BI development.
Experience with Power Automate.
Domain experience in Oil & Gas or similar data-intensive industries is a plus.

Qualifications And Attributes

Engineering Degree or master's degree in petroleum, Mechanical, Computer Science/Analytics, or other quantitative fields.
Operational experience in Oil & Gas, Manufacturing, Maintenance etc.
Solid documentation and organization skills.
Excellent organizational skills in order to manage multiple tasks.
Excellent professional, interpersonal, and communication skills.
Must be flexible and team oriented.
Ethical, self-motivated individual with the ability to set and achieve goals.
Demonstrates a workplace culture that is committed to the H&P Way

Actively C.A.R.E
Service Attitude
Innovative Spirit
Teamwork
Do the Right Thing

Thank you for your interest in joining our team!

India: Business Intelligence Engineer