Data Engineer PAM F/H/X

About KISIO Services et Consulting

Inspirer et mettre en mouvement une mobilité responsable.

KISIO Services et Consulting offre aux collectivités, aux opérateurs de transports et aux entreprises une approche experte, multidisciplinaire et sur-mesure de la mobilité.

Au quotidien, nous allions conseil et services opérationnels et œuvrons à la transition sociétale, environnementale et énergétique, en agissant en faveur d'une mobilité durable au service des citoyens.

Nous sommes une filiale française du groupe Keolis, fruit du rapprochement de plusieurs entités expertes en 2015.

What we can accomplish together:

The PAM IDFM manages all transport reservations for People with Reduced Mobility in the Île-de-France region, involving the following non-exhaustive actions:

• Trip planning
• Service registration management
• Real-time transport regulation

Under the responsibility of the PAM Data and Tools Suite Manager, you will collect, provide, and process data in line with the needs of the teams.

Your role:

1. Collect the data (application database, particularly SQL, and flat files like CSV, excel, API, CRM tools...)

   • Gather business needs from different units requesting and using data collection and storage solutions
   • Manage data collection and provision
   • Manage, maintain, and document multiple databases

2. Set up ingestion pipelines

   • Define the frequency: real-time, daily batch...
   • Manage errors: handle duplicates, alerts if a source fails...
   • Set up and maintain batches

3. Model the data (data schema, data normalization and denormalization)

   • Design data models
   • Deploy models to production
   • Ensure production monitoring and maintenance
   • Write documentation related to databases (management rules, variable dictionary...)

4. Transform and verify data quality (cleaning, enrichment, historization, tests, anomaly monitoring...)

5. Automate and industrialize data

   • Perform unit and integration tests

Additional missions:

• Ensure GDPR compliance, security, and quality of service in tool usage
• Contribute to IT system evolutions related to service regionalization
• Participate in committees/meetings between IT, business units from DRC or Keolis (Keolis IT, Mediation, ....)

Your profile:

• You have a Bac +5 degree in computer science, statistics, mathematics, or a related field
• A first experience in inter-team or multi-stakeholder coordination is a plus
• You master programming languages such as Python, SQL, and BI tools like Tableau, Power BI, or Looker
• You have skills in project management, communication, and the ability to work in an agile environment and manage multiple projects simultaneously

What we offer:

• Compensation: 40-45k + 10% variable
• A pleasant and dynamic work environment, where ideas will be heard and valued.
• A collaborative environment, with events, experience sharing, and regular updates
• Our CSR commitments: create value for our clients and territories, put people at the heart of our priorities, protect the planet, and ensure sustainable growth
• Numerous benefits: telework (up to 3 days), CSE, employee savings plan, Sustainable Mobility Pass, 75% reimbursement of transport costs, social commitment (Kisio offers each employee the opportunity to dedicate 0.5 day per year to a high-impact social mission)

Recruitment process:

1- If your application is shortlisted, you will be contacted for an initial HR discussion.

If your profile is not selected for this offer, you will receive a response by email.

2- If your application is selected after the pre-qualification, you will meet your future manager and possibly other team members.

3- Is your application approved? You will be contacted by the HR team to receive a contract offer.

If you are not selected after the interviews, you will be informed as soon as possible.

For readability and accessibility, this offer is written in generic masculine, without gender preference. Kisio cultivates diversity and inclusion within its teams, without distinction of origin, experience, age, gender, sexual orientation, religion, or disability.