Senior Consultant - ETL/BI/Azure

• 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