Summary
✨ AI‑Generated
A senior database engineering position focused on data platform and warehouse solutions. You will develop complex SQL objects, own database architecture and data-integrity standards, build ETL pipelines, integrate diverse third-party data sources, create analytics dashboards, and automate database maintenance and monitoring. The environment includes SQL Server, Python-based data processing, distributed data technologies, and workflow orchestration.
Highlights
Work on large-scale data platform and data warehouse solutions in an Agile environment, with remote work possibilities. The role spans database architecture, ETL, data integration, analytics dashboards, automation, and modern lakehouse technologies.
Description
Join us to contribute to our Data Platform and Data Warehouse solutions for one of the largest e-commerce destinations in the US.
You'll be working in a multi-location Agile team.
The position is in Riga, Latvia, with remote work possibilities.
Primary Duties and Responsibilities:
Develop and optimize stored procedures, functions, triggers, views and complex queries (T-SQL) for our Order Management System and Data WarehouseOwn database architecture and design on your projects; define and enforce data-integrity standardsBuild and maintain ETL: T-SQL on SQL Server today, Python/PySpark on our Spark + Iceberg lakehouse orchestrated by AirflowIntegrate 3rd-party data sources (Google Analytics / BigQuery, Jira, Workday, Elasticsearch, MySQL systems)Build reports and dashboards in Apache Superset (some Power BI)Automate database maintenance and monitoringWork AI-first: the whole team uses Claude Code for development, reviews and documentation, and so will you
Skills & Requirements:
3+ years with Microsoft SQL Server 2017–2022Strong T-SQL: procedures, functions, triggers, views, complex queriesProven query/process optimization and database maintenance skillsData Warehouse concepts (dimensional modelling, incremental loads)Working knowledge of MySQLGit-based workflowStrong written and spoken English, problem-solving, ownershipWillingness to use AI coding assistants daily as a core part of the job
Qualification:
Python for data engineering (pandas, PySpark) is considered a plusLakehouse stack: Apache Spark, Apache Iceberg, Apache Airflow is considered a plusApache Superset or Power BI is considered a plusAWS (S3, EKS/Kubernetes), Apache Ranger or similar access-control tools are considered a plusSSIS / SSRS / SSAS / SSDT are considered a plusHands-on AI-assisted development (Claude Code, Copilot, Cursor) is considered a plusC# is considered a plusComputer Science or IT degree is considered a plus
We offer:
Competitive salary (€3500–€5500 gross, depending on experience), with annual salary reviews and clear career growth opportunitiesDirect employment with a stable Latvian company that has been successfully operating for over 15 yearsHybrid work opportunities and flexible working hours to support a healthy work-life balanceAccess to modern AI-powered development tools and powerful Lenovo or Apple hardware with your choice of macOS, Windows, or LinuxPremium health insurance covering dental care, physiotherapy, massage treatments, mental health support, sports activities, and vaccinationsProfessional development through conferences, internal learning sessions, individual mentorship, and continuous knowledge sharingChallenging international projects where you'll solve real engineering problems and work with modern technologiesAn Agile engineering culture focused on continuous improvement, clean code, and knowledge sharingFriendly, experienced colleagues and a collaborative work environmentA modern office in Riga with an active office culture, monthly team lunches, regular team events, and company-paid parking
