Data Engineer
Job Summary
Smartvatten is Europes leading SaaS platform for data-driven water management designed for both real estate portfolios and water utilities. Through digital monitoring analysis and data-driven insights Smartvatten helps its customers detect deviations early optimise water use and make better decisions. Today Smartvatten monitors more than 40000 buildings over 200000 apartments and more than 40 water networks contributing to more efficient operations reduced risk and more sustainable water use.
We are now looking for a
Data Engineer to join our team in Kokkola or Pori
About the role:
As a Data / Analytics Engineer you help build and maintain Smartvattens 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 companys 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/. 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.
We are looking forward to hearing from you! Please send your application by 22nd of November.
About Company
Smartvatten: Where Strategy, Leadership, and Teamwork Create an Outstanding WorkplaceSmartvatten is not just any workplace; it's a thriving environment where strategy and leadership take center stage. Here, we value our people, promote diversity, equity, and inclusion, and strive to c ... View more