BCF - Ihr zuverlässiger Partner für Softwareentwicklung

BI Strategy & Development Analyst

Bright Coders' Factory – unser Name spricht für uns, denn unsere Software ist im Herzen globaler Unternehmen angesiedelt. Wir versorgen unsere Kunden mit modernsten Technologien. Unser Potenzial wächst ständig, was durch die Auszeichnungen Forbes Diamond und Great Place to Work belegt wird.

Wir schreiben Code, um das Leben der Menschen einfacher zu machen. Bei BCF findest du deinen Platz und siehst, dass deine Arbeit zählt. Unser Portfolio umfasst Projekte aus mehr als 15 Branchen – je nach deinen Vorlieben und deiner Karrierestufe finden wir also bestimmt das Richtige für dich.

Über die Position

We are looking for a BI Strategy & Systems Development Analyst to join a project focused on modernizing an enterprise-grade reporting architecture. The key objective is to conduct a performance audit of the current Jasper-based solution and provide strategic recommendations for implementing modern BI platforms (Oracle Analytics, Power BI). This is a long-term, stable project within the public sector.

Anforderungen

BI & Reporting Systems Proficiency: Hands-on experience with Jasper, Oracle BI, and Power BI.
Advanced SQL Optimization: Expert-level skills in query tuning and performance optimization to minimize processing time.
Data Modeling: Proven track record of working with triple-source data environments and designing cohesive, integrated reporting models.
Feasibility Analysis: Ability to conduct comprehensive technical feasibility studies for enterprise-grade systems.
Documentation Excellence: Proficiency in analyzing and drafting detailed technical and process documentation.
Security Clearance: Valid criminal record check (certificate of non-criminality) or willingness to obtain one (required for public sector compliance).

Ihre Verantwortung

Performance Analysis: Conduct a comprehensive audit of the Jasper-based reporting system, with a specific focus on identifying bottlenecks related to its single-threaded architecture.
Feasibility Studies: Prepare strategic recommendations and Feasibility Studies regarding the migration from legacy solutions to modern BI platforms, such as Oracle Analytics (OAC/OAS), Microsoft Power BI, Tableau, or Qlik.
Query Optimization: Diagnose and resolve long-running query issues to reduce the load on production databases.
Data Integration: Manage data ingestion and maintain data consistency across three distinct, disparate data sources.
Documentation Management: Perform deep-dive analysis of existing system and project documentation to ensure business continuity of analytical processes.
Data Offloading: Implement offloading techniques to alleviate pressure on primary databases by optimizing the reporting layer.
BI Benchmarking: Conduct performance and functional benchmarking (e.g., Oracle BI vs. Power BI) tailored to specific statistical reporting requirements.
Multi-source Analysis: Execute data consolidation strategies for environments involving three distributed data sources.
Iterative Feasibility Assessment: Continuously validate project hypotheses through documentation review and rigorous performance testing.