Cushman & Wakefield Global, Inc is seeking a mid-level Data Modeler to support our data management activities. In this role, you will apply your strong 3NF/relational design expertise to build and evolve governed data models that balance normalized structures with analytics consumption needs.
What You'll Do
- Design, maintain, and version conceptual, logical, and physical models using 3NF normalization; document naming conventions and standards.
- Apply denormalization patterns selectively for analytics and downstream consumption while preserving data quality and lineage.
- Use ERWin to capture entities, attributes, relationships, indexes, and constraints; enter rich model metadata and steward the model repository.
- Generate stakeholder review reports and publish model documentation from ERWin; create and review DDL; prepare DML scripts for reference data.
- Perform manual and tool-assisted data profiling using SQL; summarize distributions, anomalies, keys, and referential integrity; feed findings into quality scorecards.
- Define source-to-target mappings including joins, keys, transformations, and data rules; maintain mapping packs for engineering handoff.
- Determine load sequences for master and reference data across normalized structures; author and review insert/update sequences for batch jobs.
- Partner with product and analytics teams to translate modeled data into BI-ready views; support dashboard teams with semantic layer guidance.
- Align models to data governance policies, standards, and business rules; participate in model reviews and change control forums.
- Facilitate daily communications and meetings; present findings and recommendations clearly to technical and business stakeholders.
What We're Looking For
- Demonstrated strength in 3NF normalization and relational modeling techniques; practical experience applying denormalization for analytics.
- Hands-on experience with ERWin for modeling, metadata entry, report generation, DDL review, and DML preparation.
- Proficiency in SQL for profiling and analysis; ability to write performant queries and diagnose data issues.
- Ability to author source-to-target mappings with clear join logic, keys, and transformation rules; meticulous documentation habits.
- Experience defining insert/update sequences for master and reference data loads across normalized objects.
- Strong oral and written communication skills; comfortable presenting technical topics to non-technical stakeholders.
- Availability to work EST time zone hours and attend daily meetings.
Nice to Have
- Familiarity with data governance frameworks and artifacts and collaboration with data stewards and architects.
- Experience supporting business intelligence dashboards and semantic layer design; comfort collaborating with product and analytics teams.
Technical Stack
- ERWin
- SQL
Team & Environment
You will report to the Global Director, Data Management & Data Governance (Advisory).
Benefits & Compensation
- Compensation range: $103,955.00 - $122,300.00
- Health, vision, and dental insurance
- Flexible spending accounts and health savings accounts
- Retirement savings plans
- Life and disability insurance programs
- Paid and unpaid time away from work
Work Mode
This is a hybrid role open to candidates based in the US or overseas.
Cushman & Wakefield provides equal employment opportunity to all individuals regardless of protected characteristics and takes affirmative action to ensure applicants are treated without regard to any such characteristics.
