Data Engineer
Lyon, Auvergne-Rhône-Alpes, France
Data Engineering projects:▪ Boxes Sales : follow-up of the “sell out” of physical sales of games, collected from retailers.▪ Digital Sales : follow-up of the digital sales of games, provided by Sony, Steam, Microsoft, Nintendo…▪ GSD : sales data from a panel of competing publishers.▪ CRM : collection of gamers touchpoints from our websites.▪ Finance : consolidation of data from the ERP and the financial forecast and consolidation tool.For each of these projects:▪ Design of data models (Oracle).▪ Creation, maintenance and optimization of data pipelines (Datastage and Talend).▪ Creation, maintenance and optimization of dashboards (Business Objects, Tableau Software and Power BI).▪ Writing of ad hoc SQL queries for extraction and data quality, SQL optimization.▪ Project management support to business teams.▪ Supervision of service providers and collaboration with partners and suppliers.Other projects:▪ Projects to harmonize data practices with the head office in Japan.▪ Implementation of a centralized customer support solution for European gamers (Oracle Service Cloud), in collaboration with the Customer Support Manager.▪ Participation in internal controls of J-SOX audits on IT subjects, exchanges with external audit firms (Deloitte and KPMG).▪ Management of the PIM: product information centralization and sharing. Strong business expertise on the product.▪ Various technical migrations: impact analysis, implementation, tests, production delivery and follow-up, user support and training.Support and maintenance in operational condition:▪ Resolution of user requests, to more than 500 internal customers.▪ Detection and correction of anomalies in automated processing.▪ Supervision of servers, in collaboration with the IT team and external DBAs.Lead role in the BI/Data team (3 to 7 people):▪ Designing the organization, processes and best practices of the team, in an Agile context.▪ Mentoring, training and knowledge transfer to team members.
