Data Engineer

Data Engineer

to join our team in Kokkola or Pori

About the role:

As a Data / Analytics Engineer you help build and maintain Smartvatten's cloud data platform. You bring data from various source systems into our Google Cloud / BigQuery data warehouse, model it into reliable, reusable datasets, and serve it to reporting (Qlik) and other consumers. We develop with AI as an everyday tool rather than a side project, and the warehouse you build is also the foundation the company's AI and analytics use cases are built on.

Key responsibilities:

• Building data pipelines: ingesting data from source systems (e.g. Salesforce, NetSuite, MongoDB-based systems and SaaS APIs) into the BigQuery data warehouse.
• Data modeling & transformation: developing SQL transformations in Dataform following our layered (bronze → silver → gold → reporting) medallion architecture.
• Reporting datasets: building and maintaining the serve-layer tables and views consumed by Qlik dashboards and other reporting.
• Data quality & documentation: writing tests/assertions, validating results, and documenting datasets and KPI definitions.
• Collaboration: Work with the technology team and stakeholders to turn reporting and KPI needs into data solutions.
• AI in practice: using AI-assisted development in your daily work and building the datasets that make AI and analytics use cases possible — including a governed dataset, free of personal data, that AI tools can query safely.

Skills and competences needed in this role:

Required / core

• BSc/B.Eng. completed or ongoing in Computer Science, Data/Software Engineering or a related field — or equivalent demonstrable skills.
• Working knowledge of SQL.
• Basic programming skills, preferably Python.
• Eagerness to learn cloud data technologies, attention to detail, and good communication skills in English.
• Readiness to work with AI tools — either existing experience or a genuine willingness to learn. You do not need to have built AI systems; you do need to be interested in where they can be applied.

Technologies you will work with (prior experience is a strong plus, not required)

• Google Cloud Platform, especially BigQuery — our central data warehouse.
• The functions our data warehouse relies on: SQL-based data modeling, scheduled ingestion pipelines, and version-controlled transformations (Dataform, Git).
• Data ingestion / ETL pipelines (e.g. Apache Beam / Dataflow), incl. reading from MongoDB / NoSQL sources.
• Infrastructure as code (Terraform).

Considered an advantage

• Qlik (Qlik Cloud / Qlik Sense) or other BI / data visualization tools.

Why Smartvatten?

Positive Impact:

Be part of an innovative company making a real impact on sustainability and water conservation. We are passionate about devoting our talent and efforts to drive for a more sustainable future.

Innovative Environment

Work with talented, passionate professionals in a forward-thinking company that values creativity and progress. We understand the power of positive energy and praise our co-workers for a job well done.

Diversity and Inclusion

Collaborate with a team that celebrates diverse ideas and perspectives. We value our differences, treat everyone fairly, and encourage people to openly share their opinions.

Professional Growth:

Explore opportunities for personal and career development. We hire the best talent who shares our continuous development mindset.