Data Engineer

Company Description

About Ramboll

Founded in Denmark, Ramboll is a foundation-owned people company. We have more than 18,000 experts working across our global operations in 35 countries. Our experts are leaders in their fields, developing and delivering innovative solutions in diverse markets including Buildings, Transport, Planning & Urban Design, Water, Environment & Health, Energy, and Management Consulting. We invite you to contribute to a more sustainable future working in an open, collaborative, and empowering company. Combining local experience with global knowledge, we together shape the societies of tomorrow.

Equality, diversity, and inclusion are at the heart of what we do

We believe in the strength of diversity and know that unique experiences and perspectives are vital for creating truly sustainable societies. Therefore, we are committed to providing an inclusive and supportive work environment where everyone can flourish and reach their potential. We welcome applications from candidates of all backgrounds and encourage you to contact our recruitment team to discuss any accommodations you need during the application process.

Job Description

We invite you to bring your experience in building dashboards related to HR and Clients & Sales domains. To succeed in this role, you must have hands-on experience working extensively in DWH and Power BI.

Inviting bright minds

Do you want to push the boundaries of your profession and develop your excellence in an open, collaborative, and empowering culture? We work to create a sustainable future and our inspiring projects and innovative solutions aim to set the standard among our peers. You will join a global company that has been growing successfully since its founding in 1945. Together, we lead and leave a positive impact on societies, companies, and people around the world.

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

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.

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.

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.