Senior Consultant - ETL/BI/Azure

Eeih; Telangana; On-site; INR 700,000 - 1,300,000; Full time

Job summary

Eeih in India is seeking a BI/Data Engineer to design and implement scalable data warehouse and BI solutions on Azure, driving Power BI dashboards and analytics aligned with business KPIs. You will collaborate with stakeholders to define reporting requirements, optimize ETL/ELT pipelines, and integrate Big Data technologies while ensuring data quality, governance, and security.

The role also requires scripting and automation to streamline data workflows and act as a BI strategy advisor within

Qualifications

• Experience in designing and implementing DWH solutions on Azure
• Proficient in Power BI data modeling, DAX, and optimization
• Advanced SQL querying and performance tuning
• Hands-on with ETL/ELT pipelines
• Knowledge of Data Governance and security best practices
• Familiarity with Big Data technologies (Spark, Databricks, Hadoop)
• Ability to translate requirements into BI solutions
• Strong stakeholder communication

Responsibilities

• Design and implement scalable data warehouse and BI solutions on Azure
• Develop Power BI dashboards aligned with KPIs and executive reporting
• Collaborate to define reporting requirements and translate into BI solutions
• Oversee and optimize ETL/ELT pipelines for performance and cost
• Drive scripting/automation to streamline data workflows
• Integrate Big Data technologies into BI/DWH
• Ensure data quality, governance, and compliance
• Identify opportunities to improve reporting processes and architecture
• Advise on BI strategy and emerging Azure tools

Skills

Power BI

Azure Synapse Analytics

SQL

ETL/ELT

Data Modeling

Cloud (Azure)

Python

Scripting (PowerShell)

Big Data

Data Governance

Tools

Databricks

Hadoop

ETL Tools

Job description

• Design and implementation of scalable data warehouse and BI solutions on Azure.
• Drive the development of Power BI dashboards and analytics solutions aligned with business KPIs and executive reporting needs.
• Collaborate with stakeholders to define reporting requirements and translate them into efficient BI solutions.
• Oversee and optimize ETL/ELT pipelines for performance, scalability, and cost-efficiency.
• Drive the use of scripting and automation to streamline data workflows and monitoring.
• Collaborate with teams to integrate Big Data technologies into BI/DWH solutions.
• Ensure data quality, governance, and compliance across all reporting layers.
• Proactively identify opportunities to improve reporting processes and data warehouse architecture.
• Act as a trusted advisor for BI strategy, suggesting best practices and emerging tools in the Azure ecosystem.

Essential Skills

Technical

• Data Warehousing (DWH) – design, architecture, and implementation
• Azure Synapse Analytics / Azure Data Warehouse
• Power BI – data modeling, DAX, dashboard/report design, optimization
• SQL – advanced querying, optimization, stored procedures, performance tuning
• Database Knowledge – relational models, indexing, schema design
• ETL/ELT Tools & Pipelines – data integration and orchestration
• Data Modeling – star schema, snowflake schema, SCDs, fact/dimension design
• Data Governance & Security – role-based access, compliance best practices
• Cloud Ecosystem (Azure) – storage, compute, and analytics services
• Scripting languages such as Python, Shell, or PowerShell for automation and data handling.
• Exposure to Big Data technologies (e.g., Spark, Databricks, Hadoop ecosystem).

Personal

• Stakeholder Management – engage with business users to gather and translate requirements into BI solutions
• Communication Skills – ability to explain technical concepts to non-technical stakeholders clearly
• Analytical Thinking – strong problem-solving mindset with focus on business outcomes
• Collaboration – work effectively with cross-functional teams (Business, IT, Data Engineering)
• Project Ownership – ability to manage end-to-end delivery with accountability for timelines and quality
• Adaptability – stay updated with emerging BI and cloud technologies, driving innovation in solutions

Preferred Skills

Job

• Knowledge of Oracle modules/tables: Financials, HR, Projects
• Knowledge of OTBI Subject Areas/BI Publisher
• Understanding of Financial Concepts is a plus

Personal

• Demonstrate proactive thinking
• Should have strong interpersonal relations and business acumen
• Negotiation and persuasion skills are required to work with partners and implement changes
• A very inquisitive mind that can factor in several variables acting on the situation