BI Developer

Company Description

Ramboll in India

Ramboll has more than 1,800+ experts working across six offices in India applying their passion to deliver innovative solutions in markets as diverse as Architecture & Landscape, Buildings, Transport, Water, Environment & Health, and Energy. Founded in Denmark, Ramboll is a people company. We invite you to contribute to a sustainable future working in an open, collaborative, and empowering culture.

Welcome to our Support Organization

In Ramboll’s Support Organization we take pride in keeping Ramboll running smoothly, enabling bright minds throughout the organization to focus on their areas of expertise as we tie together all parts of the business. We provide support within areas like Finance, HR, Client & Sales, Opex and more, coordinating efforts and securing common ground for the development and servicing of clients and markets.

You will join our Data & Analytics team

We are seeking a skilled and experienced independent Business Intelligence Developer with 5+ years of experience to join our team. The ideal candidate will have extensive expertise in SQL along with Data Warehousing knowledge, Data Modelling (Tabular Cube), SSIS, Azure Data Factory, Azure Database, and Power BI. In this role, you will be responsible for developing data solutions, transforming and integrating data, and delivering actionable insights through Power BI.

Your starting point for constant growth

From the moment you join Ramboll, we will support your personal and professional development so that you grow with the company. Whilst we look forward to supporting your continued learning and development, for this role we have identified some qualifications, skills, and capabilities that will set you up for success.

Key Responsibilities:

• Design, develop, and implement complex T-SQL queries and Stored Procedures to extract, manipulate, and report data from diverse sources.
• Work with Data Warehousing concepts to design, implement, and maintain data warehouses to support BI solutions.
• Data Modeling: Create and optimize data models to ensure efficient reporting, analysis, and business intelligence solutions.
• Develop and maintain ETL processes using SSIS (SQL Server Integration Services) and Azure Data Factory to integrate data from various sources into the data warehouse.
• Design, develop, and deploy Power BI reports, dashboards, and visualizations to provide stakeholders with meaningful insights.
• Optimize SQL queries, stored procedures, and ETL pipelines for performance, ensuring data retrieval and transformation processes are efficient.
• Ensure data quality and accuracy in all BI reports, dashboards, and data models.
• Collaborate with business users and technical teams to gather requirements, design BI solutions, and translate them into actionable insights.
• Document BI processes, SQL scripts, stored procedures, and data models.
• Stay updated on the latest BI trends, tools, and techniques, continuously improving BI solutions and data workflows.

Qualifications

Required Skills & Qualifications:

• Strong SQL skills, including complex queries and Stored Procedures.
• Expertise in Data Warehousing, Data Modeling, and designing scalable data structures.
• Proficient in SSIS and Azure Data Factory for ETL and data integration.
• Extensive experience with Power BI and complex DAX codes for creating reports and dashboards.
• Skilled in query optimization and performance tuning.
• Excellent communication and collaboration skills.

Good to have:

• Experience with Microsoft Fabric and cloud base platforms such as Azure Synapse, Azure Data Lake, or Azure SQL Data Warehouse.
• Exposure to Git, Azure DevOps, or other version control systems for code management
• Knowledge of scripting languages (e.g., Python, PowerShell) is a plus.

Additional Information

How to apply

Apply online. Attach your CV, cover letter and relevant documents showcasing why you are the right fit for the role, and when you are available to start. We look forward to receiving your application.