← Back to jobs
TThe Hackett Group

Senior Consultant - ETL/BI/Azure

The Hackett Group

Jangaon
Full-Time
0-3 Years experience

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

Eligibility Criteria

  • Seniority: Senior Level
  • Languages: English

About The Hackett Group

The Hackett Group is a global strategic consulting firm providing benchmarking and advisory services for finance and HR, with a focus on operational excellence in India.

Industry: Business Consulting and ServicesEmployees: 1503+Website