Business Intelligence Junior Developer - Paris, France - Ipsos

Ipsos

Entreprise vérifiée

Paris, France

il y a 3 semaines

Posté par:

Sophie Dupont

beBee Recruiter

Description

BUSINESS INTELLIGENCE JUNIOR DEVELOPER *:

Paris

Full-Time

***
About:Ipsos est le leader en France des études de marché et des enquêtes d'opinion. Groupe français indépendant, fondé en 1975, Ipsos opère aujourd'hui dans 90 pays et donne aux entreprises et aux institutions pour lesquelles il travaille, les clés de compréhension de la société, des marchés, des citoyens et des consommateurs.

Une mission qui s'appuie sur la disruption numérique, l'extension des domaines d'observations et l'innovation continue pour améliorer la finesse des analyses.

Intégrer Ipsos aujourd'hui c'est:
Choisir un métier passionnant au cœur des enjeux d'actualités et des transformations de la société.
Bénéficier d'une multiplicité d'opportunités d'apprentissage dans des secteurs différents : le marketing, la publicité, les médias, la politique, le CRM, qui intègrent les dernières innovations digitales et technologiques.
Se voir confier des responsabilités immédiatement sur des études avec de véritables perspectives d'évolutions professionnelles.
Evoluer au sein d'un groupe international dans lequel les opportunités de mobilité sont une réalité.

Pour répondre aux nouveaux besoins de ses clients, Ipsos dispose de plus de 75 services différents regroupés dans 17 Lignes de Services.

Cette nouvelle organisation nous permet d'aiguiser nos expertises pour apporter à nos clients des réponses précises à leurs questions, en nous permettant d'être plus spécialisés, rapides et homogènes sur tous les marchés

Job Description:

We want you to understand the data model we have, analyse and communicate findings, as well as build queries and processes for automating reports or data loading.

This is the opportunity to combine your passion for SQL with the excitement of Finance.

Role overview
Creating queries, functions, and stored procedures; establishing and monitoring ETL processes; troubleshooting and resolving production issues; optimising database performance; creating, executing, and resolving data quality validation processes; interacting and linking various data file formats (e.g. flatfile,.csv, Excel) and producing reports aligned with the business needs.

Collaboration skills are essential to this role.

What will I be doing?

The list of tasks involves:
Data Mapping: using standard governance, create datapoint linkages between externally sourced data and the BI Enterprise Datawarehouse Database Maintenance: design, develop, test, optimise and maintain all database objects such as tables, views, and stored procedures Data migration: use your financial skills to migrate financial data for Mergers & Acquisitions. Participate in the migration of SQL databases to the Cloud Coding & implementation of new features: using standard SQL language,.NET, HTML/CSS, and C#, write code for ETL processes, data promotion across servers, create views and reports, and execute quality and validation checks, as well as other needs. Assist with platform maintenance and issue resolution and job monitoring: Help with ticket resolutions, monitor production runs to ensure expected performance, address breakfix issues, and implement needed changes to optimise performance. Troubleshoot, test, and debug core products to ensure optimisation and stability. Data Validation: create data quality and validation checks, generate and document exceptions, and implement corrective modifications Data Archiving: execute standardized archival processes to maintain optimal database operations Adhoc SQL queries to extract data from Financial Information SystemsIn addition you will have permanent activities:

Participate as an active member of the scrum team, providing input to team velocity and sprint events.

Collaborate with the testing team based in India to ensure the accuracy and reliability of developments Contribute to database tuning and query optimization efforts Participate in customer design conference calls and meetings Other duties as assigned by team leadership
Preferred Experience:
What do I need to bring with me?

Technical Skills:

Experience with MSSQL Server, SQL. Knowledge of creating and maintaining tables, views and stored procedures. Keeping objects and schemas consistent across multiple databases and servers. Experience with.
NET, HTML/CSS, and optionally C# and DAX Understanding of financial principles, including revenue recognition, gross margin, intercompany transactions and profit and loss Experience integrating data from various data sources and file types Experience writing and fixing code that is clear, well commented, easily understood and maintained Optional experience with financial job migrations Optional Exposure to Cloud technologies and SQL migration to the Cloud, Snowflake, Fabrics Optional working experience with database tuning and query optimization**