Business Intelligence Junior Developer - Paris, France - Ipsos
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.
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.
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.
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**
Plus d'emplois de Ipsos
-
CDD - Contrôleur·euse de Gestion H/F
PARIS, France - il y a 2 semaines
-
Lead Machine Learning Engineer
Paris, France - il y a 1 semaine
-
Enquêteur en Face À Face
Paris, France - il y a 1 semaine
-
ContrÔleur(Se) Interne
Paris, France - il y a 2 jours
-
Enquêteurs (H/F) en Face À Face, Mission en Zone
Paris, France - il y a 1 semaine
-
Chargé-e D'études Publicitaires
Paris, France - il y a 2 jours