Responsabilities ResponsibilitiesDaily activities include : Assisting the lead data architect in revising enterprise conceptual, logical, and physical data modelsImplementation of the data management solution including the platform architecture design, the ETL / ELT data processes, the databases / data warehouse / data lake solution, the data model and different data Marts and eventually additional Analysis services.
Creating data models that conform with existing standards and business requirements.Revising data dictionary definitions, governance practices, and standardsPartnering with Security specialists to ensure compliance with data security and privacy requirements.
Other Responsabilities : Work with the team (technical Lead / Architect / other members) and customer focal point to understand the business need and design / implement the technical data management solution.
Design and implement Data Warehouses and Data Lakes solutions, mainly using Microsoft technologies, based on the customers’ business requirements.
Design and implement complex ELT and ETL processes using Integration Services (SSIS) or Azure Data FactoryDesign and develop Analysis Services OLAP Cubes and Tabular ViewsDevelop scripts accordingly to the data need (stored Procedures with T-SQL, Python or R, eventually PowerShell or .
NET).Design conceptual and logical data models and data flowchartsDesign Data-as-a-Service solution, on-premises and Cloud based, based on Data API Gateway and other Cloud services.
Implement Data Catalog solutionsMigrate data from legacy systems to new data platform solutionsImprove system performance by conducting tests, troubleshooting and integrating new elementsOptimize new and current database systems Requirements RequirementsEducation / Certifications : University degree (Masters or equivalent) in computer science, engineering or other relevant fields.
Any Data certification as Microsoft Data Certifications, Microsoft Data Management and Analytics, Microsoft Azure Big Data Analytics Solution, will be a plus.
Prince2 Agile, ITIL, SCRUM, are a plusExperience & Skills : 7+ years of professional experience in Business Intelligence, Data Management, Information Systems with on-prem and cloud technologies required.
Expert knowledge on Data modelling (OLTP and OLAP models), Data Integration (ELT / ETL), Data Lake / Data Warehouse / Data Marts implementation and Data Analysis models (Analysis Services).
Microsoft Data Management technologies, platforms and applications experience is mandatory.Experience with Cloud Data & BI environment (MS Azure mandatory, AWS a plus).
Communicating in a credible and effective wayExperience working as a member of distributed data architecture teams (on premise or cloud)Knowledge of Agile development methodology and concepts.
Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures is a plus.
Strong experience with Databases such as Microsoft SQL Server. Oracle is a plus.Experience with data visualisation tools (e.
g. Power BI, Qlik, Tableau) is a plusFluent English is mandatory Benefits Benefits Interesting projects based on the newest technologiesOpportunity for self-improvement and career growthInternal & external software development education and trainings (certifications) covered by ERNIFlexible working time & overtime compensation5 weeks of vacation, 3 sick days, home officeLanguage courses (en, de) fully covered by ERNISport & culture personal budget (including medical care, yoga in the office)Referral & relocation bonusFully covered meal vouchersNewly renovated rooftop of the building for free time activitiesTeam buildings (grill parties, Christmas dinner, Hack&Hike session, EPD two day education & leisure event, sport events, company breakfast etc.
Well-established community : Developers Community Sessions, Brownback Sessions, Cinema , Gaming Club