Senior BI Engineer

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 (2022, 2025), 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, bicycle parking, terraces full of greenery) and excellent work tools (e.g., raised desks, ergonomic chairs, interactive conference rooms).

• A 16" or 14" MacBook Pro or corresponding Dell with Windows (if you don't like Macs) and all the necessary accessories.

• 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 related to the specific nature of your job.

• A training budget, inter-team tourism (see more here), hackathons, and an internal learning platform where you will find multiple trainings.

• An additional day off for volunteering, which you can use alone, with a team, or with a larger group of people connected by a common goal.

• Social events for Allegro people - Spin Kilometers, Family Day, Fat Thursday, Advent of Code, and many other occasions we enjoy.
  
  And that's just the beginning! You can read more about the benefits here.

#goodtobehere means that:

• You will join a team you can count on - we work with top-class specialists who have knowledgee- and experience-sharing in their DNA.

• You will love our level of autonomy in team organization, the space for continuous development, and the opportunity to try new things. You get to choose which technology solves the problem and you are responsible for what you create.

• You will value our Developer Experience and the full platform of tools and technologies that make creating software easier. We rely on an internal ecosystem based on self-service and widely used tools such as Kubernetes, Docker, Consul, GitHub, and GitHub Actions. Thanks to this, you can contribute to Allegro from your very first days on the job.

• You will be equipped with modern AI tools to automate repetitive tasks, allowing you to focus on developing new services and refining existing ones (also leveraging AI support).

• You will create solutions that will be used (and loved!) by your friends, family and millions of our customers.

• You will meet the Allegro Scale, which starts with over 1000 microservices, an open-source data bus (Hermes) with 300K+ rps, a Service Mesh with 1M+ rps, tens of petabytes of data, and production-used machine learning.

• You will become part of Allegro Tech - We speak at industry conferences, cooperate with tech communities, run our own blog (it's been over 10 years!), record podcasts, lead guilds, and we organize our own internal conference - the Allegro Tech Meeting. We create solutions we love (and can) to talk about!
  
  Send us your CV and… see you at Allegro!

This may also be of interest to you - Allegro Tech Podcast → https://podcast.allegro.tech/