Position: Middle MS SQL DB Developer, Investment Management Platform; Sign-on Bonus
Company: DataArt
Experience required: 3y
Category: SQL
English level: intermediate
Published: 2021-06-01T00:00:00+03:00

Our client is a leading provider of capital and services to the mortgage and financial services industries. It offers attractive risk-adjusted returns while also protecting the existing portfolio and generating long-term value for its investors. The company’s investment portfolio includes mortgage servicing-related assets, non-agency securities (and associated call rights), residential loans, and other related opportunistic investments.

We hire people not to a project, but to the company. If the project (or your work in it) is over, you go to another project or to a paid “Idle”.

Responsibilities:

Designing database and data structures
Writing, maintaining, and optimizing stored procedures, etc.
Creating SQL queries to facilitate data needs
Designing, implementing, and optimizing ETL processes for extracting data from different sources using SQL Server Integration Services
Development and implementation of reports with SQL Server Reporting Services
Work cooperatively with DevOps, DBAs on different components of the solution cooperatively
Creating customized reports and dashboards

Must have:

4+ years of directly related work experience
Solid development experience working with SQL Server
Experience designing schemas of high-load relational database management systems (RDBMS)
Strong experience with SQL Server Reporting Services (SSRS)
Solid experience with SQL Server Integration Services (SSIS)
Understanding of ETL, Database Replication, T-SQL
Knowledge of Ad Hoc SQL
Experience in query optimization
Good spoken English

Would be a plus:
Working with XML Data in SQL Server
Knowledge of .NET
Financial background/experience: working with financial data projects, fixed income instruments understanding is a big plus
Solid communicational skills
Experience working with foreign clients
Understanding of Agile methodologies