Senior Database Developer (MS SQL / Data Platform)

Senior Database Developer (MS SQL / Data Platform)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 Warehouse
• Own database architecture and design on your projects; define and enforce data-integrity standards
• Build and maintain ETL: T-SQL on SQL Server today, Python/PySpark on our Spark + Iceberg lakehouse orchestrated by Airflow
• Integrate 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 monitoring
• Work 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–2022
• Strong T-SQL: procedures, functions, triggers, views, complex queries
• Proven query/process optimization and database maintenance skills
• Data Warehouse concepts (dimensional modelling, incremental loads)
• Working knowledge of MySQL
• Git-based workflow
• Strong written and spoken English, problem-solving, ownership
• Willingness to use AI coding assistants daily as a core part of the job

Qualification:

• Python for data engineering (pandas, PySpark) is considered a plus
• Lakehouse stack: Apache Spark, Apache Iceberg, Apache Airflow is considered a plus
• Apache Superset or Power BI is considered a plus
• AWS (S3, EKS/Kubernetes), Apache Ranger or similar access-control tools are considered a plus
• SSIS / SSRS / SSAS / SSDT are considered a plus
• Hands-on AI-assisted development (Claude Code, Copilot, Cursor) is considered a plus
• C# is considered a plus
• Computer 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 opportunities
• Direct employment with a stable Latvian company that has been successfully operating for over 15 years
• Hybrid work opportunities and flexible working hours to support a healthy work-life balance
• Access to modern AI-powered development tools and powerful Lenovo or Apple hardware with your choice of macOS, Windows, or Linux
• Premium health insurance covering dental care, physiotherapy, massage treatments, mental health support, sports activities, and vaccinations
• Professional development through conferences, internal learning sessions, individual mentorship, and continuous knowledge sharing
• Challenging international projects where you'll solve real engineering problems and work with modern technologies
• An Agile engineering culture focused on continuous improvement, clean code, and knowledge sharing
• Friendly, experienced colleagues and a collaborative work environment
• A modern office in Riga with an active office culture, monthly team lunches, regular team events, and company-paid parking