Junior Consultant Data Analytics (m/f/d)

  • PROMATIS software GmbH
  • Ettlingen, Germany
  • 01/05/2024
Full time Data Science Data Analytics Data Management Biostatistics Data Warehouse

Job Description

In focus: Oracle Business Analytics and Enterprise Performance Management

Data is the lifeblood of every company, and the growth and diversity of data is almost immeasurable. The goal is clear: valuable business knowledge should be developed from this treasure trove of data. Key figures measure the performance of the company, individual products or means of production, create an image of customers and business partners and promise a view into the future that is crucial for success using predictive analyzes and AI/ML. As a data analytics consultant, you move in this area of ​​tension. Based on the customer's knowledge needs, you design appropriate analytical data models, ensure efficient data storage and provide suitable query and evaluation options.

Challenging tasks await you:

  • Your focus is on the customer's knowledge needs, which, depending on the application, are aligned with their business or technical/scientific goals. In addition, you can use data profiling to gain clarity about the available data.
  • In conceptual data models, you ensure the technical structuring of the data. For the subsequent implementation with Oracle database technologies, you use relational, multidimensional, hybrid and, for big data, NoSQL data schemas.
  • For data storage, you use Oracle databases, data warehouses and data marts on premises and increasingly autonomously in the cloud. Performance management applications are implemented based on Oracle Essbase. If necessary, you can also use open source products.
  • The design of the reporting and analysis applications and dashboards is carried out in close coordination with the customer. The entire range of Oracle Analytics products, competitor tools available to the customer and open source products are used for implementation.
  • During data migration, you will support data profiling, the conception of data transfer (ETL - extraction, transformation, loading) and the implementation of the ETL process, including the necessary automation and the provision of suitable check routines.

You bring with you:

  • Completed studies in computer science, business informatics, information economics or industrial engineering with an IT affinity
  • Required knowledge and ideally practical experience in the following areas:
    • Architecture and use of data management systems
    • Conceptual modeling of data, business processes, business rules
    • Logical and physical database design
    • Data modeling for data warehousing and OLAP: Star Schema, Snowflake Schema
    • Monitoring and online analysis: Conception and development of reports, dashboards, reporting systems on the web and on mobile devices
  • Interesting additional qualifications:
    • Modern data visualization methods and technology
    • Modeling agile data warehouses: Data Vault
    • Oracle Analytics Cloud
    • Oracle Enterprise Performance Management Cloud
    • Dealing with business intelligence databases and applications using either the following technologies:
      • Object relational, in-memory
      • Multidimensional, Essbase
      • Big Data (NoSQL, Hadoop + Spark Frameworks)
  • Responsible use of digital technologies and AI with the aim of creating sustainable, humane user experiences
  • Communication skills, abstraction and structuring skills, care in creating documentation and good knowledge of German and English
  • Mobility in project work at home and abroad

If you are interested in challenging and varied tasks in our company, we look forward to receiving your application