Datastage/Power BI Business Intelligence Engineer

Keoni; Paris; Hybrid; EUR 60,000 - 90,000; Full time

Job summary

Kéoni Consulting, founded in 2008, is an IT consulting and engineering firm specializing in the banking, financial markets, insurance, and industrial sectors. We partner with major accounts in their digital transformation and help align technologies and processes.

The BI Engineer role focuses on building dataware/datamarts with Datastage, SQL, and Power BI, delivering datasets, dataflows and reports, and ensuring quality through unit tests in a SCRUM environment.

Qualifications

• Experience with Power BI in a Datastage Teradata environment.
• Strong SQL querying and optimization.
• Familiarity with SCRUM and ticketing systems (JIRA).
• Knowledge of ETL/ELT processing.

Responsibilities

• Develop dataware and datamart programs with Datastage and SQL.
• Create datasets, dataflows and Power BI reports.
• Perform unit testing and delivery.
• Ensure compliance with standards and best practices.
• Participate in BE qualification and anomaly handling.

Skills

Power BI

SQL

Scrum / Jira

Data integration

Tools

Datastage

Teradata

PostgreSQL

Job description

# Datastage/Power BI Business Intelligence Engineer* Datastage/Power BI Business Intelligence EngineerMISSIONSReporting to the Business Intelligence Development Manager, the consultant's main responsibilities will be:– Development of dataware and datamart programs (Datastage and SQL)– Development of datasets, dataflows and reports using the Power BI tool– Unit testing and delivery– Compliance with standards and best practices within the SID– Taking into account anomalies and developments related to the BE and qualification– SQL query optimizationTechnology or certifications required: Power BI in a Teradata Datastage environment, and PostgreSQLDefinition of expected services:Development services provided in coordination with the engineering team, qualification, and scrum master.SKILLS :POWER BI, Datastage Teradata, and PostgreSQL »expected deliverables"Operations file for the Production team"Unit test (plan and test sheets)Progress Reporting »Technical and technological environmentETL/ELT/Processing: Datastage/SQLRestitution: PowerBI (dataset, dataflow, reports)Storage: Teradata, PostgreSQL »Technical skillsKnowledge of ETL/DEALING: DATASTAGE in particularSQL queryingDevelopment of Power BI decision-making reporting tools (datasets, dataflows, reports)SCRUM methodology & use of a ticketing system (like JIRA)Professional skillsExperience in the social protection ecosystemSupplementary pension scheme for private sector employees ideallyFounded in 2008, Kéoni Consulting is an IT consulting and engineering firm specializing in the banking, financial markets, insurance, and industrial sectors. We are the partner for major accounts in their digital transformation. We help them transform their business model, align their operational processes, select the best technologies, and mitigate and address the risks associated with digitalization.Kéoni Consulting helps companies to:Making a differenceInnovate and createReinvent your businessSatisfying customersGaining a competitive advantageTo become the leader in their sectorBecome the leader in your sectorOur activity covers the entire lifecycle of information systems (Project Management and Steering, Business Analysis Consulting, Design, Implementation, Maintenance, Production and Operation).**Work location:** Europe