15 Nov
|
Ganit Business Solutions
|
Mumbai
15 Nov
Ganit Business Solutions
Mumbai
Job Overview
We are looking for a skilled Data Intelligence Engineer with strong expertise in SQL, Databricks AI/BI, Genie, and analytical data modelling. The ideal candidate will combine data engineering capabilities with business intelligence expertise to build optimized data models, develop curated datasets, and deliver scalable, self-service analytics solutions.
The role requires hands-on experience in transforming raw data into business-ready insights, developing Gold-layer tables, and enabling interactive analytics using Databricks AI/BI and Genie. Candidates should have a solid understanding of data transformation, data modelling, and BI visualization tools such as Power BI, Tableau, or Amazon QuickSight.
Candidates with a pure-play BI development background and limited data engineering, SQL, or data modelling experience will not be considered.
Key Responsibilities
- Design, develop, and maintain data models and analytical datasets to support business intelligence and decision-making.
- Write, optimize, and troubleshoot complex SQL queries for data transformation, aggregation, and analytical processing.
- Develop and maintain Gold-layer tables and curated datasets using SQL and Databricks.
- Leverage Databricks AI/BI and Genie to build interactive analytics solutions and enable self-service business intelligence.
- Develop and maintain dashboards, reports, and visualizations using Power BI, Tableau, or Amazon QuickSight.
- Implement data modelling practices, including dimensional modelling, fact and dimension tables, and analytical data structures.
- Work closely with data engineering teams to understand source systems, data pipelines, ETL/ELT processes, and transformation workflows.
- Ensure data quality, consistency, accuracy,
and performance across analytical datasets and reporting solutions.
- Translate business requirements into scalable data solutions, analytical models, and actionable insights.
- Optimize SQL queries, data models, and reporting datasets for performance and scalability.
- Collaborate with business stakeholders, analysts, and technical teams to understand requirements and deliver effective data intelligence solutions.
- Support the development of reliable, reusable, and business-ready datasets for reporting and advanced analytics.
Required Skills and Qualifications
- 47 years of relevant experience in data intelligence, data engineering, analytics engineering, or BI development with strong data engineering capabilities.
- Strong hands-on expertise in SQL, including complex queries, joins, aggregations, window functions, and query optimization.
- Practical, hands-on experience with Databricks AI/BI and Genie.
- Experience creating, maintaining, and optimizing Gold-layer tables and curated analytical datasets.
- Strong understanding of data modelling, dimensional modelling, fact and dimension tables, and analytical data structures.
- Experience with at least one BI visualization tool: Power BI, Tableau, or Amazon QuickSight. Experience with two or more tools is preferred.
- Understanding of data engineering concepts, including ETL/ELT processes, data transformation, data pipelines, and data quality.
- Ability to understand end-to-end data flows, from source data ingestion and transformation to curated datasets and business insights.
- Experience working with Databricks-based data platforms and analytical workloads.
- Strong problem-solving, analytical, and troubleshooting skills.
- Good verbal and written communication skills, with the ability to engage effectively with business stakeholders and technical teams.
📌 Data Intelligence Engineer (Mumbai)
🏢 Ganit Business Solutions
📍 Mumbai