The Senior Consultant will design and implement scalable data warehouse and BI solutions on Azure, drive Power BI development, oversee ETL pipelines, ensure data quality, and act as a trusted advisor for BI strategy while collaborating with stakeholders.
- 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
- 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
Top Skills
Azure Data Warehouse
Azure Synapse Analytics
Big Data Technologies
Elt
ETL
Power BI
Powershell
Python
Shell
SQL
Similar Jobs
Cloud • Information Technology • Productivity • Software • Automation
The Revenue Analytics Engineer will design and maintain analytics solutions for revenue reporting, focusing on subscription metrics and ensuring data quality and technical implementation.
Top Skills:
DbtPower BISalesforceSnowflakeSQL
Cloud • Information Technology • Productivity • Software • Automation
As a Senior ServiceNow CRM Developer/Administrator, you will lead the design and implementation of CRM solutions, manage platform governance, and mentor junior developers while ensuring optimal service delivery.
Top Skills:
CSSFlow DesignerGlide ApiHTMLIntegration HubJavaScriptRestServicenowSoapXML
Cloud • Information Technology • Productivity • Software • Automation
The ServiceNow CPQ Developer/Administrator designs and configures product pricing and quoting functionalities, integrates with ERP systems, and ensures performance efficiency in the ServiceNow environment.
Top Skills:
CSSFlow DesignerGlide ApiHTMLIntegration HubJavaScriptJSONRest ApiServicenow
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
