Senior Data Engineer

About the Role

As a Senior Data Engineer, you will play a key role in designing, building, and maintaining the city’s data infrastructure. You will work with large and diverse datasets from multiple sources, ensuring they are reliable, high-quality, and accessible for analytics, reporting, and advanced data science use cases.

You will collaborate closely with data analysts, data engineers, and other technical teams to support operational reporting, analytical models, and smart city initiatives including Vilnius Mobility Map, Traffic regulation system,  The Greenness Index Calculator, Air quality monitoring system and much more.

Responsibilities

ETL & ELT:

• Design, implement, and maintain scalable data ingestion pipelines and data flows
• Integrate data from various internal and external sources using data flow management tools (e.g. Kafka, Azure Data Factory)
• Monitor, optimize, and troubleshoot data pipelines to ensure reliability and performance

Data Modeling & Storage:

• Design, develop, and maintain analytical and operational data models
• Work with relational and analytical databases (e.g. Microsoft SQL Server, PostgreSQL)
• Implement data structures optimized for reporting, analytics, and machine learning workloads
• Manage data storage layers and support efficient data access patterns

Data Quality & Governance:

• Ensure data accuracy, consistency, and completeness across systems
• Implement and maintain data quality checks using tools such as Great Expectations
• Identify and resolve data issues in collaboration with data producers and stakeholders
• Contribute to data documentation and best practices

Analytics & Visualization Support:

• Develop and support data visualization and reporting solutions
• Enable self-service analytics for business users using tools such as Power BI, Superset, Metabase
• Optimize datasets and models for efficient reporting and dashboard performance
• Work closely with data analysts and data scientists to support analytical and predictive models
• Assist in deploying and integrating data science workflows (e.g. Kubeflow, PyTorch)
• Support experimentation and innovation related to smart city and urban analytics use cases

Requirements

• 3+ years of experience as a Senior Data Engineer,  Data Software Developer, or in a similar role
• Strong SQL skills, including the ability to write complex queries
• Experience working with relational databases (e.g. MS SQL, PostgreSQL)
• Higher education in Computer Science, Data Science, or a related field
• Practical experience with data visualization and reporting tools (e.g. Power BI)
• Professional fluency in Lithuanian and English

Nice to Have

• Experience with Azure Databricks
• Programming skills in Python and/or SparkSQL
• Experience with ESRI ArcGIS products (ArcGIS Enterprise, ArcGIS Desktop)
• Experience working with spatial data or unstructured data (e.g. images)

What We Offer

• The opportunity to contribute directly to the digital transformation of Vilnius and smart city initiatives
• Meaningful projects with a real impact on the city and its residents
• Health insurance (after the probation period)
• Flexible working hours (7:00–19:00) and hybrid work options
• Public transport card or parking space near the office
• A friendly, professional, and collaborative team
• Training, growth opportunities, and all the tools you need to succeed
• Salary €5,500 – €6,500 per month (before taxes) + annual bonus