Junior SQL Developer
Posted Updated
Description
Some of the data we work with in Germany sits in on-premise SQL Server and Oracle databases that are staying where they are, and changes to them have to happen during the client's working day. Grainset Data is hiring a Junior SQL Developer in Germany for this work. The job is full-time and can be done from anywhere in Germany; the team is in Boston, six hours behind.
Main tasks
What we check for in your CV
Not required, but useful
Working at Grainset
Grainset Data, in Boston, builds data pipelines, analytical models and metric definitions, and traces a reported figure back to the source records behind it.
#LI-Remote
Main tasks
- Write and tune SQL queries, views and stored procedures
- Prepare extracts from SQL Server, PostgreSQL or Oracle for loading into the warehouse
- Check row counts and totals after each load
- Investigate slow queries with execution plans
- Keep database scripts in Git with a short change note
What we check for in your CV
- A degree in computer science, business informatics or a related field, or completed Fachinformatiker training
- SQL including joins, subqueries and aggregate functions
- One relational database: SQL Server, PostgreSQL, MySQL or Oracle
- Git basics
Not required, but useful
- T-SQL or PL/SQL
- Python
- SSIS or another ETL tool
Working at Grainset
- 30 vacation days
- Employer-funded company pension
- Training budget for courses and certifications
- Laptop and home office setup
- Flexible hours with a daily overlap with Boston
Grainset Data, in Boston, builds data pipelines, analytical models and metric definitions, and traces a reported figure back to the source records behind it.
#LI-Remote
Skills
Sign in to read and join the discussion.