Cushman & Wakefield
We will never settle for the world that’s been built, but relentlessly drive it forward. #BetterNeverSettles
Data Modeler
Location
United States
Posted
4 days ago
Salary
Not specified
No structured requirement data.
Job Description
Advisory Intelligence is seeking a midlevel Data Modeler with strong 3NF/relational design expertise who is equally comfortable supporting adjacent data management activities. In addition to building and evolving governed data models, this role contributes to data profiling, data quality reporting, SQL development, and business intelligence dashboard support.
Enterprise data modeling
Design, maintain, and version conceptual/logical/physical models using 3NF normalization; document naming conventions and standards.
Apply denormalization patterns selectively for analytics and downstream consumption needs while preserving data quality and lineage.
Tooling & metadata management
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 created by ERWin; prepare DML scripts for reference data.
Data profiling & quality
Perform manual and tool-assisted data profiling (SQL and/or other available tooling); summarize distributions, anomalies, keys, and referential integrity; feed findings into quality scorecards and remediation actions.
Integration design & load orchestration
Define source-to-target mappings (table/column-level) including joins, keys, transformations, and data rules; maintain mapping packs for engineering handoff.
Determine load sequences for master/reference data across normalized structures; author and review insert/update sequences for batch jobs.
Analytics & BI support
Partner with product and analytics teams to translate modeled data into BI-ready views; support dashboard teams with semantic layer guidance and consumption-optimized structures.
Governance alignment & stakeholder engagement
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.
Job Requirements
- Demonstrated strength in 3NF normalization and relational modeling techniques; practical experience applying denormalization for analytics/consumption.
- Hands-on experience with ERWin for data 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 via SQL.
- 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/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/communications.
- Familiarity with data governance frameworks and artifacts (data standards, naming conventions, data dictionary) and collaboration with data stewards/architects.
- Experience supporting business intelligence dashboards and semantic layer design; comfort collaborating with product/analytics teams.
Benefits
- Equal Opportunity Statement: 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.
- Cushman & Wakefield also provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health, vision, and dental insurance, flexible spending accounts, health savings accounts, retirement savings plans, life, and disability insurance programs, and paid and unpaid time away from work.
- In addition to a comprehensive benefits package, Cushman and Wakefield provide eligible employees with competitive pay, which may vary depending on eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of collective bargaining agreements.
- The compensation for the position is: $103,955.00 - $122,300.00
