Analytics Engineer

Are you ready to build the data infrastructure that enables smarter decisions across a global organization? As Analytics Engineer, you'll design Azure pipelines, craft semantic layers, and empower teams to discover insights independently, all while shaping the future of Ampelmann's data platform.

About Ampelmann

Ampelmann makes offshore access as easy as crossing the street. Driven by innovative technology, we are continuously working on impactful projects, while supporting the shift to cleaner energy. Our international and safety minded environment values your well-being, and our culture is built on open communication and mutual respect. With us, you’ll thrive in a fast-growing, global company with opportunities for personal and professional development.

About the Digital Team

You will join the Digital team, where business applications, integrations, and digital improvement come together. The team ensures digital enablement by designing, implementing, and managing solutions that support operational excellence and organizational transformation. Working with internal stakeholders and external partners, the team delivers scalable, secure digital capabilities in line with company strategy and governance frameworks. The team consists of 2 Functional Consultants, 2 Product Owners / Solution Architects, 1 Project Manager, and 1 Data Engineer.

Your role

As an Analytics Engineer, you work in the space between data engineering and reporting. You maintain existing data structures, connect new data points and help shape datasets that support meaningful analysis. This role offers a great mix of hands-on work, business contact and room to grow as the data platform evolves. You will have the chance to influence the next phase of Ampelmann’s data landscape while working closely with experienced colleagues and external partners. In this role, you will report temporarily to the Director Structural Change.

Regular Activities

• Design, build and optimize ETL pipelines in Azure Synapse Analytics to ensure reliable, scalable data flows from multiple sources
• Integrate internal and external data sources into a centralized data warehouse, handling complex transformations and data quality
• Create and maintain dimensional data models and semantic layers for reporting and analysis
• Develop and optimize self-service analytics and Power BI solutions that enable stakeholders across the business to discover insights independently
• Partner with business stakeholders to translate data requirements into technical specifications

We ask

• BSc degree and 5+ years of experience in a similar role
• Solid expertise in SQL/T-SQL, ETL, Azure services, data warehousing and Power BI
• Experience in the Microsoft data stack and working with business-focused analytics environments
• Ownership mindset with analytical thinking to proactively improve data quality
• Strong communication and collaboration skills
• Fluent English (spoken and written)

You get

• A great work environment with innovative and change-willing aspirations
• High degree of responsibility and room to have significant impact
• Great secondary benefits (e.g., annual bonus, Working from Home policy, non-contributory pension plan, unlimited vacation days, NS-Business card and more)
• Ampelmann Academy for all your personal and professional development needs