*This position is fully remote only for employment in Bulgaria. However, people can also work in one of our offices in Sofia or Varna if they prefer to.
About DataArt
DataArt is a global software engineering firm and a trusted technology partner for market leaders and visionaries. Our world-class team designs and engineers data-driven, cloud-native solutions to deliver immediate and enduring business value.
We promote a culture of radical respect, prioritizing your personal well-being as much as your expertise. We stand firmly against prejudice and inequality, valuing each of our employees equally.
We respect the autonomy of others before all else, offering remote, onsite, and hybrid work options. Our Learning and development centers, R&D labs, and mentorship programs encourage professional growth.
Our long-term approach to collaboration with clients and colleagues alike focuses on building partnerships that extend beyond one-off projects. We provide the ability to switch between projects and technology stacks, creating opportunities for exploration through our learning and networking systems to advance your career.
Position Overview
Our client is a large retail company that sells home improvement and DIY products like tools, paint, garden supplies, and kitchen/bathroom items. This project focuses on building and enhancing an enterprise data warehouse platform that supports data driven decision making across complex business domains. The work involves designing scalable data models, ingestion pipelines, and transformation logic to ensure high quality and consistent data.
Technology stack
Core: SQL, dimensional/Kimball data modelling, enterprise data warehouse tools, cloud data platforms
Additional technologies used within the project: Python, PySpark, data profiling tooling
Responsibilities
Design and document Enterprise Data Warehouse objects: data models, source-to-target mappings, model diagrams, and supporting design documentation that engineers deliver from
Work with stakeholders and source-system SMEs to onboard new data sources and adapt designs to what each source provides
Clarify the intent behind requirements before designing: why the stakeholder needs it and whether existing structures already cover it
Profile and analyze source data to validate design assumptions
Define data quality rules as part of designs for downstream teams to implement
Investigate reported data issues, identify root causes, and propose design-level fixes
Take designs through peer and design review; give and take constructive challenge
Keep stakeholders informed: raise issues early, ask instead of assuming, follow up until unblocked
Requirements
Strong practical foundations of dimensional modeling — able to design warehouse models from raw source data and explain the reasoning behind design choices