Position: Database and Data Warehouse Developer
Company: Upplabs
Category: Other
Experience required: 3y
English level: intermediate
Published: 2020-08-01T00:00:00+03:00

**Job Summary:** The role is part of a development team for a dynamic and forward-thinkingISV. The software product you will be developing is an enterprise-class data warehousing andworkflow   tool,   used   by   some   of   the   world’s   largest   and   most   demanding   blue-chiporganisations. You will be responsible for delivering database and data warehousing solutionsof exceptional quality.

**Job Description:**   There is no limit to how involved you can be in the development ofDashworks. There’s a lot of moving parts and you’ll always be able to find something new toget your teeth into. We’re very interested in finding new ways of improving, so your opinionsand innovations will always be welcome.You will be developing databases for both OLTP and OLAP systems using Microsoft SQL Server;both relational and dimensional (star) schemas are used. Behind the scenes are SQL Serverdatabases which have data bulk imported into them via C# executables and CLR. You havesubstantial input into architectural decisions and will need to translate requirements into atechnical solution that is future proof and progressive, but also sympathetic to existingfunctionality and commercially viable.
**Your responsibilities will include the following:**
- Creating   database   schemas   using   SQL   server,   using   both   relational   and   analyticaldatabase models
- Performance tuning over large datasets using monitoring tools and query execution plans
- Developing new functionality to requirements and integrating this with existing systems
- Creating and supporting SQL Server agent jobs
- Managing and enhancing ETL processes
- Developing database unit tests
- Managing database source control
- Developing   and   supporting   business   intelligence   systems   using   SQL   Server   AnalysisServices
- Understanding new data sources that will integrated into the data warehouse
- Creating and managing large datasets for testing
- Testing and supporting the database code base
- Liaising with the QA team to improve the ongoing quality of the application

You will be working as part of an existing development team, in an agile developmentenvironment.  Clear deliverables will be set and you must manage these to agreed milestonesand   deadlines,   collaborating   with   the   Product   Manager   to   give   progress   reports   andunderstand changing requirements. Much of the development team may be working remotelyfrom you, so an ability to self-manage and self-motivate is essential. Communication will be akey skill to enable you to work effectively with the rest of the development team andunderstand cross-impacts. You will work within a development lifecycle and be responsible formuch of your own testing, documentation and bug-fixing. You must be flexible enough toadapt to a rapidly changing development landscape, whilst managing your time effectively tobe able to meet deadlines.

**Key Technical Skills:**
- SQL Server Development 2017, 2019)
- SQL Server Analysis Services Development (2017, 2019)
- MDX
- DAX
- T-SQL
- tSQLt
- C# and CLR Stored Procedures
- Data Warehousing and Dimensional Data Modelling
- ETL (Extract Transform Load) Development
- Database Performance Tuning
- Database Administration
- Source Control (GIT)
- XMLA (desirable)Microsoft   SSIS   and   SSRS   are   not   required. 
All   skills   require   a  minimum  of   2-3   yearsexperience.
Practicalities:  Core working hours are 9am to 6pm (GMT), Monday to Friday. You will be in constant contact with the other members of the team usinginstant messaging and VoIP, attending a scrum call each morning. Fluent English is essential.