Functional Engineer Reporting

Job Title: Functional Engineer Reporting Data Modelling

Location: Pune, Hinjewadi Phase one

Experience: 6+ Years

Job Description:

We are looking for an experienced data professional with strong SQL and data modelling skills, along with exposure to Databricks and Power BI.

Key Responsibilities:

• Design and maintain data models for reporting and analytics.
• Write complex SQL queries for data extraction, transformation, and validation.
• Integrate and transform data from multiple sources.
• Work with Databricks and Power BI to develop analytics solutions.
• Optimize data models and query performance.
• Collaborate with business stakeholders and data engineering teams.
• Ensure data accuracy, quality, and technical documentation.
• Identify opportunities for automation and continuous improvement.

Required Skills:

• 6+ years of experience in data analytics, data modelling, or BI.
• Strong hands-on SQL skills.
• Exposure to Databricks.
• Experience with Power BI and DAX.
• Good understanding of data transformation, integration, and complex datasets.
• Strong analytical and stakeholder management skills.

Good to Have: PySpark, Python/R, Azure data services, SAP HANA/BW.

Ideal candidate should have

• Strong SQL skills complex queries, joins, CTEs, aggregations, data validation and optimization.
• Data Modelling expertise — designing data models, defining business logic, and translating business requirements into metrics and analytical datasets.
• Databricks exposure — working with data transformation, integration, and processing in a Databricks environment.
• Power BI experience — developing dashboards, reports, and DAX calculations.
• Data integration — experience combining data from multiple sources such as Azure SQL, SAP HANA/BW, Excel, and flat files.
• Data transformation — cleaning, enriching, joining, pivoting, and preparing complex datasets.
• Stakeholder management — translating business requirements into technical solutions and explaining insights to non-technical stakeholders.
• Documentation and quality — ensuring data accuracy, testing solutions, maintaining documentation, and optimizing performance.