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
- D esign 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 implementationAzure Synapse Analytics / Azure Data WarehousePower BI – data modeling, DAX, dashboard / report design, optimizationSQL – advanced querying, optimization, stored procedures, performance tuningDatabase Knowledge – relational models, indexing, schema designETL / ELT Tools & Pipelines – data integration and orchestrationData Modeling – star schema, snowflake schema, SCDs, fact / dimension designData Governance & Security – role-based access, compliance best practicesCloud Ecosystem (Azure) – storage, compute, and analytics servicesScripting 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 solutionsCommunication Skills – ability to explain technical concepts to non-technical stakeholders clearlyAnalytical Thinking – strong problem-solving mindset with focus on business outcomesCollaboration – work effectively with cross-functional teams (Business, IT, Data Engineering)Project Ownership – ability to manage end-to-end delivery with accountability for timelines and qualityAdaptability – stay updated with emerging BI and cloud technologies, driving innovation in solutionsPreferred Skills
Job
Knowledge of Oracle modules / tables : Financials, HR, ProjectsKnowledge of OTBI Subject Areas / BI PublisherUnderstanding of Financial Concepts is a plusPersonal
Demonstrate proactive thinkingShould have strong interpersonal relations and business acumenNegotiation and persuasion skills are required to work with partners and implement changesA very inquisitive mind that can factor in several variables acting on the situationSkills Required
Data Modeling, Power Bi, Database Knowledge, Sql