Consultant Data Analytics (m/f/d)

  • PROMATIS software GmbH
  • Ettlingen, Germany
  • 15/05/2024
Full time Data Science Data Analytics Data Management Data Governance 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.

A variety of 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 provide support in data profiling, in the conception of data transfer (ETL – extraction, transformation, loading) and in 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 practical experience – ideally in the Oracle environment:
    • Conception and design: data profiling, information needs analysis, data modeling, design of data warehouses and data marts
    • Data modeling for data warehousing and OLAP: Star Schema, Snowflake Schema, Data Vault
    • ETL: Conception, development and testing of ETL processes
    • Monitoring and online analysis: Conception and development of reports, dashboards, reporting systems on the web and on mobile devices
    • Physical design, implementation and tuning of business intelligence databases and applications using either the following technologies:
      • Object relational, in-memory
      • Multidimensional, Essbase
      • Big Data (NoSQL, Hadoop + Spark Frameworks)
  • Interesting additional qualifications:
    • Modern data visualization methods and technologies
    • Oracle ETL and Real-Time Integration: Data Integrator, Golden Gate, Streams
    • Oracle Analytics Cloud
    • Oracle Fusion Analytics
    • Oracle Enterprise Performance Management Cloud
    • Advanced Analytics: Data Mining, R Statistical Computing, Predictive Analytics
    • Information Discovery: Oracle Endeca
  • 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