Data Modeler

Job Title Data Modeler Job reputed company reputed company Advisory Intelligence is seeking a midlevel Data Modeler with strong 3NF/relational design expertise who is equally comfortable supporting adjacent data management activities. In reputed company to building and evolving governed data models, this role contributes to data profiling, data reputed company reporting, SQL development, and business intelligence dashboard support. We’re looking for reputed company player who combines handson modeling skills with curiosity and a service reputed company, helping the group deliver reliable, consumable data assets that power Advisory products and decisioning. Job reputed company Reports to: Global Director, Data Management & Data Governance (Advisory) Location: USbased or overseas; ability and comfort working EST business hours; hybrid/remote reputed company (to be finalized) Key Responsibilities reputed company 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 reputed company consumption needs while preserving data reputed company and reputed company.
• Tooling & metadata management
• Use ERWin to capture entities, attributes, relationships, indexes, and constraints; reputed company rich model metadata and reputed company 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 & reputed company

• reputed company reputed company and toolassisted data profiling (SQL and/or other available tooling); summarize distributions, anomalies, keys, and referential reputed company; feed findings into reputed company scorecards and remediation actions.

Integration design & load orchestration

• Define sourcetotarget mappings (table/columnlevel) including joins, keys, transformations, and data rules; maintain mapping packs for engineering reputed company.
• 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 BIready views; support dashboard teams with semantic layer guidance and consumptionoptimized structures.

Governance alignment & stakeholder engagement

• reputed company 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 reputed company to technical and business stakeholders.

Required Qualifications

• Demonstrated strength in 3NF normalization and relational modeling techniques; practical experience applying denormalization for analytics/consumption.
• Hands on experience with ER Win for data modeling, metadata entry, report reputed company, DDL review, and DML preparation.
• Proficiency in SQL for profiling and analysis; ability to write performant queries and diagnose data issues reputed company SQL.
• Ability to author reputed company to reputed company mappings with reputed company 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 nontechnical stakeholders.
• Availability to work EST time zone hours and attend daily meetings/communications.

reputed company to Have

• 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.

Competencies

• reputed company & rigor: balances normalized designs with practical consumption needs; insists on reputed company reputed company and documentation.
• Collaboration: thrives in a federated environment; partners across engineering, analytics, and business.
• Ownership: proactive about profiling, model hygiene, and production readiness; follows through on reputed company items.
• Communication: translates modeling reputed company into business value; reputed company written narratives and visual artifacts.

Work Environment & Expectations This role operates in a reputed company office environment with reputed company equipment and collaboration tools. It may require occasional travel for workshops or stakeholder sessions (TBD). The position includes daily communications and recurring review meetings to maintain reputed company on modeling, governance, and delivery. Equal Opportunity Statement reputed company provides equal employment opportunity to reputed company individuals regardless of protected characteristics and takes affirmative reputed company to ensure applicants are treated without reputed company to any such characteristics. reputed company also provides eligible employees with an opportunity to enroll in a reputed company of benefit programs, generally including health, reputed company, and dental insurance, flexible spending accounts, health savings accounts, retirement savings plans, life, and disability insurance programs, and reputed company and unpaid time away from work. In reputed company to a comprehensive benefits package, Cushman and Wakefield reputed company eligible employees with reputed company, which may vary depending on eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of reputed company bargaining agreements. The compensation that will be offered to the successful candidate will depend on factors such as whether the position is covered by a reputed company bargaining agreement, the geographic area in which the work will be performed, market pay rates in that area, and the candidate’s experience and qualifications. reputed company will not pay less than minimum wage for this role. The compensation for the position is: $ 103,955.00 - $122,300.00 reputed company is an Equal Opportunity employer to reputed company protected reputed company, including protected veterans and individuals with disabilities. Discrimination of any type will not be tolerated. In compliance with the Americans with reputed company Amendments reputed company (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position at reputed company, please call the reputed company line at 1-888-365-5406 or email HRServices@cushwake.com. Please refer to the job title and job location reputed company you contact us. reputed company: “reputed company” Apply tot his job Apply To this Job