Opis oferty:
The vacancy is a new position in an IT backoffice team, close to the corporate financial data warehouse and IBM Cognos ecosystem (mostly IBM Planning Analytics, a.k.a. TM1), both for internal and external integrations with on-premise and cloud applications and environments.
You will be the main developer of our corporate financial relational data warehouse, which will be the source of truth for other backoffice ecosystems. Most of your time you will be spending with SQL (GCP/BQ and MSSQL) and Python (including CRUD via API of different applications), close to IBM Planning Analytics (OLAP cubes). You will work in a team being an IT bridge between our financial ERP system and preparing financial statements. To handle issues and plan our work, we use Jira (with weekly sprints) and Slack channels. Mostly you will work in Polish, however rarely (a few times a month) there will be a meeting, user’s issue or case to face with using English only.
Wymagania:
- Loves SQL, data warehouse, backend and API integrations (must have)
- Has experience in designing architecture, building, developing and maintaining SQL databases, especially data warehouse, both facts and planning (must have)
- Works daily on designing, using and optimizing ETL processes
- Has worked at least with two of them: GCP/BQ, MSSQL, Oracle, PostgreSQL, Snowflake
- Has experience in Python, especially pandas and numpy
- Has good understanding of backend, including REST API
- Takes responsibility for their topics, pay attention to details, are independent and well organized
- Used to create dashboards (e.g. Looker, Tableau, Power BI)
Dodatki i korzyści:
- Well-located offices (with fully equipped kitchens and bicycle parking facilities) and excellent working tools (height-adjustable desks, interactive conference rooms)
- Annual bonus up to 10% of the annual salary gross (depending on your annual assessment and the company's results)
- A wide selection of fringe benefits in a cafeteria plan – you choose what you like (e.g., medical, sports or lunch packages, insurance, purchase vouchers)
- English classes that we pay for are related to the specific nature of your job
- Macbook Pro or a corresponding Dell with Windows (if you don't like Macs), and other gadgets that you may need
- Working in a team you can always count on — we have on board top-class specialists and experts in their areas of expertise