Position: Senior Database Engineer (MS SQL, PostgreSQL)
Company: Perfectial
Category: SQL
Experience required: 3y
English level: intermediate
Published: 2020-07-01T00:00:00+03:00

**Whom we are looking for:**
Perfectial is looking for a skilled Database Engineer who will be able to set up the Database to gather corporate analytics from scratch. We are implementing new internal systems for managing Business Development, HR, Finance, Delivery operations and need to set up and maintain a Database and Data Warehouses, collect analytics and visualize it.

**Requirements:**
- At least 4 years of experience as Database Developer (preferably PostgreSQL and MS SQL)
- Deep and wide understanding of databases’ structure
- Experience in creating a database from scratch
- Experience in creating a Data Warehouse and configuration of OLAP cubes
- Experience in setting up ETL jobs to ingest data from 3-rd party systems
- Excellent problem-solving and organizational skills

**Would be a plus:**
- Experience with PostgreSQL and MS SQL
- Knowledge of PowerBI or any other data visualization tool
- Experience with Python

**Responsibilities:**
- Creation of a Data Warehouse structure to store data across company departments (including Finance, HR, Delivery).
- Setup ETL jobs to ingest data from 3-rd party systems (Jira, Zoho, Odoo, Creatio) into Data Warehouse.
- Import historical data from Jira, Zoho People, Recruit, Xero, Excel.
- Connect Data Warehouse with other tools (Odoo, Creatio).
- Configuration of OLAP cubes on top of DataWarehouse.
- Configuration of PowerBI to visualize data.
- Configuration of a role-based access to databases and PowerBI using Active Directory.

**We offer:**
- Friendly and supportive environment
- Competitive salary
- Paid vacations and sick leaves
- Medical insurance
- Career development: professional guidance, certifications, and mentorship
- Professional events: participation and reimbursement
- English language courses
- Team buildings and corporate celebrations