Senior Consultant - Data Engineer
- The Hackett Group
- 5 - 8 years
- Hyderabad
- 3 months ago
- Email to a friend
- Report this job
Job Description
Senior Consultant is responsible for supporting and enhancing the existing on-premise BI environment and developing cloud BI stack. Tasks range from database maintenance and support to general BI development, including ETL and Visualizations.Must have the ability to work on end-to-end BI solution design and delivery.
Responsibilities
- 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/ETL 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
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: BI AdministrationEmployement Type: Full timeContact Details:
Company: The Hackett GroupLocation(s): Hyderabad
Keyskills: Power Bi Azure Data Factory Azure Synapse Data Modeling ETL Etl Pipelines Shell Scripting Powershell Security SQL Big Data Technologies Data Warehousing Data Governance Python
Similar positions
The Hackett Group
ESP provides IT support services across the globe. We understand how to maximise efficiency and effectiveness across a wide range of industries by delivering turnkey services from end user contact through to resolution.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in