Senior Data Designer

Aether Biomedical; Deutschland; Vor Ort; EUR 95.000 - 115.000; Vollzeit

Zusammenfassung

Aether Biomedical seeks an experienced Data Architect to create high-quality Enterprise Data Warehouse data designs. You will map data sources, ingestion, and transformation logic, documenting data harmonization and calculations. Expect occasional trips to Krakow for team alignment.

The role requires strong data modeling, solid DW concepts, and stakeholder-facing documentation skills, within an Agile environment.

Qualifikationen

• Strong experience in data modeling for enterprise DW.
• Knowledge of data warehousing concepts, source-to-target mappings.
• Experience bridging business and technical teams.
• Ability to translate business needs into clear technical documentation.
• Experience preparing functional specifications and design documents.
• Comfort with Agile environments and cross-team collaboration.

Aufgaben

• Gather and analyze business requirements related to data warehousing.
• Act as the main point of contact between business stakeholders and the development team.
• Translate business requirements into clear data models, mappings, and functional documentation for Data Engineers.
• Design and document data ingestion flows from existing and new data sources.
• Collaborate with the Principal Data Designer on solution design and data modeling decisions.
• Ensure designs meet business needs, follow data design principles, and are delivered accurately and on time.
• Maintain and improve documentation standards, templates, and design processes.
• Review colleagues’ designs and provide constructive feedback.
• Support cross-team collaboration and help other workstreams when needed.

Kenntnisse

Data modeling

Enterprise DW design

Requirements gathering

Stakeholder communication

Documentation

Tools

SQL

Python

Jobbeschreibung

Position overview

Accountable for creating high-quality Enterprise Data Warehouse data designs. This involves understanding and documenting the details on where to source data, how the source data will be ingested into the data platform, data mappings and data modelling. The data designs include defining the details of any required data harmonization, calculations, derivations, and transformation logic.The role involves occasional business trips to the office in Krakow, typically once a month or once a quarter, depending on team needs.

Responsibilities

• Gather and analyze business requirements related to data warehousing.
• Act as the main point of contact between business stakeholders and the development team.
• Translate business requirements into clear data models, mappings, and functional documentation for Data Engineers.
• Design and document data ingestion flows from existing and new data sources.
• Collaborate with the Principal Data Designer on solution design and data modeling decisions.
• Ensure designs meet business needs, follow data design principles, and are delivered accurately and on time.
• Maintain and improve documentation standards, templates, and design processes.
• Review colleagues’ designs and provide constructive feedback.
• Support cross-team collaboration and help other workstreams when needed.

Requirements

• Strong experience in data modeling for enterprise Data Warehouses.
• Good understanding of data warehousing concepts, data structures, and source-to-target mappings.
• Experience working as a bridge between business stakeholders and technical teams.
• Strong analytical skills with the ability to translate business needs into clear technical documentation.
• Experience preparing functional specifications, mappings, and design documents for development teams.
• Ability to work collaboratively in an Agile environment.
• Strong communication skills and confidence when working with stakeholders across different teams.
• High attention to detail and strong ownership of deliverables.
• Ability to challenge decisions constructively and contribute to design improvements.
• Proactive approach to learning and continuous improvement.

Nice to have

• Querying and transforming data using SQL, Python / PySpark.
• Conducting detailed data profiling and analysis.
• Modelling data into complex facts and dimensions, identifying suitable mappings, aggregations and snapshot tables where appropriate.
• Identifying complex data quality rules, considering alternative sources and volumetric analysis.