Senior Database Engineer (MS SQL, PostgreSQL) (offline)

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

About Amach Software

Amach software helps organisations of all sizes achieve continuous software delivery through automation. We specialise in automation testing and deployments. Our team will help build and integrate a bespoke automation framework that aligns testing and operational practices within your organisation. We build frameworks using best of breed 100% open source technologies based on best practices and decades of experience.

Our frameworks will enable your organisation to delivery each and every release quickly and with confidence. They are fast, scalable, easily maintained and will integrate seamlessly with any build server and source code management repository.

Amach software are a small company making a big impact for a number of our clients in the Aviation and financial services space in Ireland and the UK. We currently have between 20-30 employees spread across 3 main regions, Ireland, Romania and Ukraine in particular Lviv.

Company website:
https://amach.ie/index.html

DOU company page:
https://jobs.dou.ua/companies/amach/