Analytics Engineer

At Realtor.com, we have the most comprehensive and accurate coverage of real estate listings and the most engaged users across all the online real estate portals. Our mission is to make buying, selling, renting, and living in homes easier and more rewarding for everyone.

The People team is building a HR Performance & Goal Management (PM/GM) data product. This tool will support ~1,500 employees in managing Performance Measures (PMs) and General Measures (GMs) across mid-year and annual review cycles, aligned to our Real Success Framework (RSF).

We are seeking a Analytics Engineer to own the full data layer of this initiative — from schema design and RBAC architecture to pipeline management and compliance. This is a primary, ongoing responsibility during the build phase (6–9 months at ~75–100% allocation) and at steady-state (∼25–50% allocation post-launch), working in close partnership with the App Developer and People & Talent stakeholders.

Top Reasons to Apply:

1. High Visibility & Executive Impact
   You aren’t just building a dashboard; you are building the system of record for how 1,500+ employees (including our Executive Leadership Team) define success. The "Performance Hub" is a high-stakes, highly visible product where your architecture directly influences performance reviews, calibration, and compensation across the entire organization.
2. Architect the Future (From POC to Metric Store)
   We’ve proven the concept; now we need you to build the legacy. You have a long runway and the creative freedom to evolve a Proof-of-Concept into a robust, automated Metric Store. Beyond simple performance measures, you’ll have the autonomy to integrate proxy metrics, automated forecasting, and attrition models—effectively defining the "North Star" for our workforce analytics.
3. Absolute Ownership of a Modern Stack
   If you thrive in an environment of high ownership and low bureaucracy, this is your playground. You will own the full data layer—from Snowflake RBAC and schema design to dbt modeling and Airflow orchestration. You’ll be partnering with App Developers and People stakeholders to deliver a production-grade data product using the best tools in the industry.

What You'll Do

• Design and implement RBAC architecture in Snowflake supporting five role tiers (Employee, People Leader, HRBP, Admin, ELT), including row-level security policies scoped to org hierarchy and review cycle.
• Build and maintain data models for PM/GM tables, calibration history, audit logs, and the 4-point metric schema that underpins goal tracking and rating workflows.
• Manage the nightly UKG (UltiPro) data feed, handling org changes, leaves of absence (LOAs), and terminations to ensure the application reflects current workforce state.
• Integrate revenue goal data from existing Snowflake sources, enabling real-time goal sync for sales and quota-based populations.
• Build and maintain a comprehensive audit trail for all goal and rating changes, supporting manager workflows, HRBP review, and executive reporting.
• Implement GDPR/CCPA data anonymization logic, including right-to-be-forgotten workflows and compliant data handling for sensitive performance records.
• Enforce Snowflake access policy governance, ensuring that data exposure is strictly scoped to authorized roles and that access controls are auditable.
• Optimize Snowflake queries and warehouse configurations to support responsive HRBP and ELT dashboards, particularly during peak review seasons.
• Maintain a sandbox schema for safe development and testing of new features without impacting production data.&l