Perkins&Will Benefits Overview

Designs, develops, and maintains ETL workflows and data integration solutions using SSIS, SQL Server, C#, and Python. Integrates data from databases, APIs, and structured files; develops queries, procedures, data models, and Power BI datasets; and ensures data quality through validation and cleansing. Monitors and optimizes integration workflows and SQL Agent jobs while collaborating with cross-functional teams on financial systems, reporting, budgets, and business requirements.

Leads the strategic design, administration, compliance, communication, and continuous improvement of firmwide benefits, retirement, leave, wellness, and total rewards programs. Supports compensation through market benchmarking, workforce analytics, pay equity analysis, salary reviews, and bonus administration. Oversees vendors, renewals, enrollment, HRIS integrations, regulatory compliance, employee communications, and benefits technology. Partners with senior leadership, Finance, Legal, Talent, and external advisors while leading the benefits team and supporting acquisitions and integrations.

Lead the creative development and execution of branded environments, integrating environmental graphics, signage, wayfinding, brand identity, storytelling, and architectural elements. Guide projects from research and concept development through documentation and implementation; present to clients, coordinate with multidisciplinary teams, vendors, and contractors, oversee technical production, and mentor designers. Support site analysis, material research, specifications, construction documentation, and compliance with codes and accessibility requirements.