Consultant Data Analytics (m/f/d)

About the Position

Consultant Data Analytics (m/f/d)

Unlimited full-time

Data is the elixir of life for every company, and the growth and diversity of data is almost immeasurable. The goal is clear: to use this treasure trove of data to tap into valuable business knowledge. As a data analytics consultant, you will be working in this area of conflict. Based on the customer’s knowledge requirements, you will design suitable analytical data models, ensure efficient data storage and provide suitable query and evaluation options.

Responsibilities

• Your focus is on the customer’s knowledge needs, which are aligned with their business or technical/scientific goals, depending on the application. In addition, you obtain clarity about the existing data available in data profiling.
• In conceptual data models you will provide for the functional structuring of data. For the subsequent implementation with Oracle database technologies, you resort to relational, multidimensional, hybrid and for Big Data also NoSQL data schemas.
• For data storage you will use Oracle databases, data warehouses and data marts on premises and increasingly autonomous in the cloud. Performance management applications are realized based on Oracle Essbase. If required, you will also draw on open source products.
• The design of reporting and analysis applications and dashboards is carried out in close coordination with the customer. For the execution, the full range of Oracle Analytics products, competitor tools available at the customer as well as open source products are used.
• For data migration, you will provide support for data profiling, the conceptual design of the data transfer (ETL – extraction, transformation, loading) and the implementation of the ETL process, including the necessary automation and the provision of suitable test routines.

Requirements

• Degree in computer science, business informatics, information management or industrial engineering with IT affinity
• Required knowledge and practical experience – ideally in the Oracle environment:
  • Conceptualization 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: design, development and testing of ETL processes
  • Monitoring and online analysis: design 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 optionally in the following technologies:
    • Object Relational, In-Memory
    • Multidimensional, Essbase
    • Big Data (NoSQL, Hadoop + Spark Frameworks)
• Communication skills, abstraction and structuring abilities, diligence in creating documentation, and good German and English skills
• Mobility in project work at home and abroad

Nice to Have

• 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 goal of creating sustainable human user experiences

We Offer

• Challenging and varied tasks at our company
• Opportunities for individual development and regular annual meetings with your supervisor

About the Company

Career at PROMATIS

Here you can see available career opportunities at PROMATIS. Your individual development is also important to us: personal career goals and the way to achieve them are important points in your regular annual meetings with your supervisor.

If you have any questions, please feel free to contact us!

PROMATIS software GmbH

Pforzheimer Str. 160

76275 Ettlingen

Email: [email protected]