Data Warehousing

About ERGO Technologies and Services India

ET&S India, a part of ERGO Technology & Services Management, is the latest addition as an IT outsourcing provider for ERGO Group Worldwide. Supported by ERGO Group, an 18 billion Euro organization operating in over 25 countries, ET&S India aims to offer technology services to the ERGO group. In the near future, ET&S India will drive ERGO's digital ambitions and establish offshore development centers in various cities across the country. ET&S India will also focus on developing expertise and offering career opportunities in a wide range of technologies within the insurance sector.

Role Description:

We are looking for a highly skilled Senior SQL & Power BI Developer to lead the design and delivery of business intelligence solutions that turn data into actionable insights. The candidate should have deep experience in writing optimized SQL, building complex Power BI reports, and working directly with business stakeholders. Experience or interest in modern tools like Databricks, Python, and DevOps practices is a strong advantage.

Key Accountabilities & Responsibilities:

• Design, develop, and maintain Power BI dashboards and reports to support business operations and strategic decisions.
• Connect to various data sources, import data, and transform it using Power Query and DAX.
• Develop data models that ensure data accuracy and performance optimization.
• Work closely with business analysts, data engineers, and end-users to gather requirements and ensure deliverables meet expectations.
• Create and manage Power BI workspaces, datasets, and dataflows.
• Ensure reports and dashboards are visually compelling and user-friendly.
• Perform data validation and testing to ensure data quality and consistency.
• Automate report distribution and maintain data refresh schedules.
• Troubleshoot and resolve data or reporting issues.
• Stay updated with Power BI features, updates, and best practices.

Key Competencies & Skills required

Technical Skills:

• Strong knowledge of Power BI, Power Query, DAX, and Power BI Service.
• Experience in creating complex dashboards and reports.
• Proficiency in SQL and working with relational databases (e.g., SQL Server, Azure SQL, Oracle).
• Understanding of data warehousing and ETL concepts.
• Ability to interpret business requirements and translate them into technical solutions.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Collaborate with infrastructure and DevOps teams to ensure Power BI components align with enterprise deployment strategies and cloud architecture.

Nice to have:

• Databricks: Experience working with Delta Lake, Spark SQL for data processing.
• Python: Ability to write data transformation scripts or automate tasks using Python.
• DevOps/CI-CD: Exposure to Git, Azure DevOps, or other tools for report version control and deployment pipelines.
• Experience with Azure Data Factory or cloud-based data platforms.

Behavioral Skills:

• Excellent interpersonal and communication skills for working in a global environment
• Willingness to learn and quickly adapt to changing requirements
• Proactive approach to identifying issues and presenting solutions and options

Previous Experience & Qualifications

Minimum Educational Qualification:

• Bachelors degree in Computer Science, Information Systems, Data Analytics, or a related field.
• Candidate with non-computer science degree must have minimum 1 year of relevant experience

Certification if any:

• NA

Years Experience & Knowledge:

• 5+ years of experience in writing complex SQL queries and working with relational databases (e.g., SQL Server) and ETL processes.
• 4+ years of experience in developing enterprise-grade dashboards and reports in Power BI.
• Strong proficiency in DAX, Power Query (M), and data modeling principles.
• Solid understanding of data warehousing concepts and BI best practices.
• Excellent problem-solving, communication, and stakeholder management skills.