Data Modeler - Analytical Solutions

ITRANSITION, INC.
United States
3 months ago
Apply on itransition.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Business Logic Information Engineering Data Integrity Data Profiling Data Vault Modeling Python (Programming Language) SQL Databases Data Strategy Semi-structured Data Data Lineage Data Management Databricks

Job description

We are seeking a talented Senior Data Modeler - Analytical Solutions to lead the design of enterprise-scale analytical Data Vault 2.0 models for a data platform built on Databricks. We are looking for a candidate whose expertise is rooted in foundational data modelling principles rather than a single vendor. In this role, you will define shared analytical models and standards that ensure consistency, reusability, and trust across the enterprise. This position offers a unique opportunity to lead the architectural transformation of a complex legacy environment into a streamlined, future-ready data asset, while building a versatile profile to drive data strategy across any modern cloud environment. office remoteEuropean UnionPoland, * Model enterprise-level analytical Data Vault 2.0 structures on Databricks, handling both structured and semi-structured data

  • Create and maintain data mapping artifacts to support analytics, integration, and migration initiatives
  • Establish modeling patterns suitable for lakehouse, medallion, and semantic-layer architectures
  • Ensure alignment between physical analytical models and enterprise semantic definitions
  • Act as the primary interface between business stakeholders and data engineering, focusing strictly on data modeling rather than hands-on engineering
  • Translate complex business logic into high-quality documentation, data lineage, and precise models for engineering implementation
  • Conduct deep-dive sessions to audit and remediate complex or poorly structured data assets in the current environment
  • Establish enterprise data modeling standards that prioritize data integrity, portability, and long-term flexibility
  • Lead data profiling activities to ensure physical implementations align with defined data models

Requirements

  • 5+ years of dedicated experience in data modelling (not deep hands-on engineering)
  • Hands-on experience with modern cloud data platforms (Databricks)
  • Strong experience with SQL. Familiarity with Python/PySpark is a plus
  • Deep knowledge of modeling approaches such as Kimball, Inmon, and Data Vault 2.0, with the ability to select the most appropriate methodology to address specific business challenges
  • Experience with enterprise-grade modelling tools (e.g., ER/Studio, Erwin, or Sparx EA)
  • Strong soft skills and non-confrontational behavior

Benefits & conditions

  • Projects for such clients as PayPal, Wargaming, Xerox, Philips, Adidas and Toyota
  • Competitive compensation that depends on your qualification and skills
  • Career development system with clear skill qualifications
  • Flexible working hours aligned to your schedule
  • Corporate medical insurance covering services of private and public medical centers
  • Corporate parties and events for employees and their children
  • Internal conferences, workshops and meetups for learning and experience sharing
  • Gym membership compensation
  • 5 days of paid sick leave per year with no obligation to submit a sick-leave certificate

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on itransition.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · World Congress 2024

9:51 min

Live demonstration of dynamic data redaction plugins

Tom Kaltofen Tom Kaltofen +1 · Europe 2026 Virtual

2:27 min

Managing traffic and tracking costs with Databricks Unity Catalog

Viktoria Semaan Viktoria Semaan · World Congress 2026 Europe

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

1:36 min

Evolution from key-value stores to distributed SQL

Wei Hu Wei Hu · World Congress 2025

Videos

See all

Related articles

See all