The organisation is the IT operations partner for French-speaking public-sector administrations, delivering BI platforms and reporting used by multiple governmental services. This consultancy role exists to strengthen the BI platform around SAP BusinessObjects with a focus on SAP BusinessObjects Data Services (BODS) for ETL, SQL-based data modelling and Web Intelligence reporting.
The mission
You will join a BI function that manages multi-source dataflows (DB2 LUW, DB2 UDB, SQL Server, flat files) and multi-environment deployments (development, acceptance, production). The work covers the full data chain from ETL and staging to semantic universes and Web Intelligence reports that support operational reporting for administrative teams.
On a day-to-day basis you will be responsible for designing and implementing ETL jobs in SAP BODS, producing and tuning SQL for staging and datamarts, and maintaining universes built with the Information Design Tool (IDT). You will also participate in transport and release activities, document solutions, and provide second-line support for Web Intelligence reports and end users.
Your responsibilities
- Design and deliver ETL jobs, dataflows and mappings in SAP BODS that reliably load staging areas and ODS layers.
- Develop and optimise SQL, views and stored logic to feed datamarts and improve runtime performance of ETL workloads.
- Maintain and improve SAP BusinessObjects universes using IDT, ensuring semantic consistency and query performance for Web Intelligence.
- Build, update and troubleshoot Web Intelligence reports, translating user requirements into report variables, queries and formatted outputs.
- Implement environment and release management practices for transports between Development, Acceptance and Production, including logging and rollback procedures.
- Produce technical documentation and handover materials, and coach or transfer knowledge to in-house teams.
Your profile
Essential skills
- Proven experience delivering ETL solutions using SAP BusinessObjects Data Services (BODS), including jobs, workflows and error handling.
- Strong SQL skills and experience in data modelling for staging, ODS and datamart layers.
- Practical knowledge of SAP BusinessObjects universes (IDT) and Web Intelligence report creation and support.
- Experience working with multi-source environments (DB2 LUW, DB2 UDB, SQL Server, flat files) and handling performance tuning.
- Familiarity with environment management and release processes for BI platforms, including transports and production deployments.
- Clear documentation habits and ability to explain data and reports to non-technical stakeholders.