Senior Bi Engineer
Salva questo lavoro e mantieni la tua ricerca organizzata
Crea un account gratuito per salvare lavori, creare avvisi e tornare a questa inserzione dalla tua dashboard.
Continuando accetti i nostri Termini & Informativa sulla privacy.
Senior BI Engineer
Location:
Warszawa, Fabryka Norblina
Company:
Allegro sp. z o.o.
Job Description
A position for a Senior BI Engineer for the Allegro Group Financial corporate applications of Cognos ecosystem: IBM Controller, IBM Planning Analytics (a.k.a. TM1, PA), Workiva and a few more both with internal and external integrations with on-premise and cloud applications and multi-environments. You will work as a developer (in the IBM applications, SQL and Python) both with users (internal business), with code and other IT technical teams, lead projects and be a third-line team support. Your time will be balanced between improving and developing ETLs, extending our custom financial DWH (GCP/BQ/MSSQL) and maintaining core financial systems. Additionally, you will have a unique opportunity to participate in our newly launched greenfield projects involving AI/LLM implementations on financial data, metadata and logs.
You will be the sole technical (IT) owner and core anchor of the Group Financial Consolidation platform within our team. While a separate, dedicated business team handles all accounting standards and audit substance, you will have complete technical ownership over the applications (IBM Controller, TM1) and existing integration landscapes. No massive development overhauls are planned, but you will be the single go-to technical expert ensuring system stability and scalability.
Our Tech Environment & Tools:
Core stack: IBM Controller, IBM Planning Analytics, Google Cloud Platform (BigQuery), MSSQL, Python (including the tm1py library), Workiva, TIBCO (ESB), Kafka/Hermes, Salesforce CRM.
Infrastructure: 2 redundant data centers, 2 Active Directory domains, Windows Server *, ****), and Red Hat Enterprise Linux.
Scale: 10+ virtual machines in production, 5 in non-production, and 4 active TM1 instances.
Way of working: Git, Jira (weekly sprints), Slack, AI-powered automation (including building and managing agents).
We are looking for a specialist who:
Has deep expertise in advanced Python programming, SQL queries and database architecture (including query optimization, indexing, and a clear understanding of row-oriented vs. column-oriented databases like BigQuery/MSSQL) with visualization skills (e.g. Looker/Data Studio).
Has hands-on experience in building, managing and maintaining internal Data Warehouses (DWH) and developing ETL/ELT pipelines using Python.
Is a strong team player with good communication skills, ready to discuss technical requirements with Business PMs and stakeholders.
Has a strong willingness to learn and manage corporate financial platforms (IBM Controller, IBM Planning Analytics / TM1, Workiva) - we provide full training in TI, RUX and PA/PAW if your core SQL/Python engine is strong:)
Understands or wants to learn the technical logic behind financial data flows (multi-entity data mapping, dimensions, structures) and how IT supports Group financial, controlling and reporting processes.
Shows initiative, high independence and can easily prioritize tasks in a dynamic environment using Git.
Nice to have (a massive asset, but we provide full training):
Experience with financial consolidation tools (best: IBM Controller) and OLAP cubes (best: IBM Planning Analytics).
Interest or basic experience with AI/LLM frameworks (e.g., Python AI libraries) or advanced log analytics.
Your main responsibilities will include:
Full tech ownership and leadership: acting as the sole technical leader and single point of contact within the team for the IBM Controller ecosystem, taking full ownership of existing integration pipelines.
Vendor transition management: strategically managing technical relations with external suppliers and preparing for a long-term vendor phase-out over the next 12 months, ensuring platform control is retained fully in-house.
Data flow & DWH expansion: designing and maintaining stable data flows between production environments and our corporate financial DWH. Extending advanced integrations (such as automated TM1 to Google Spreadsheets data streaming via the tm1py library).
Financial modules development: participating in the development of new system modules and metadata changes (e.g., structural changes for Group budgeting by Business Units, multi-entity mapping, and currency conversion logic).
AI & analytics innovation: contributing to our internal initiative: extracting transactional and application logs into the DWH to help build analytical heatmaps (user workload analysis) and AI/LLM-powered search agents for financial users.
IT consultancy and support: providing high-level IT consultancy and third-line support for core financial systems (IBM Controller, IBM Planning Analytics, and the Close Code applications) during financial peaks (e.g., month-end closing).
What's in it for you:
Well-located offices (with e.g. fully equipped kitchens, bicycl