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.

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.
• Collaborate closely with the App Developer to expose clean, well-documented data interfaces that power goal submission, approval, calibration, and reporting workflows.
• Partner with Legal and IT to confirm Snowflake qualifies as the system of record for performance data and that all data governance requirements are met.

What You'll Bring

• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related technical field, plus 2+ years of relevant experience; or a Master’s degree with 6+ months of relevant experience in a corresponding domain.
• Strong SQL skills including query optimization, indexing, and building production tables and views in Snowflake; experience with Snowflake-specific features such as dynamic data masking, row access policies, and time travel.
• Hands-on experience designing and implementing RBAC in Snowflake, including role hierarchies, row-level security, and access policy governance.
• Proven ability to build and maintain data pipelines and ETL/ELT jobs; experience with tools such as dbt, Airflow, Fivetran, or custom Python-based pipelines.
• Experience integrating with HRIS platforms (e.g., UKG/UltiPro, Workday, or similar) via API or SFTP feeds to sync organizational data.
• Familiarity with data governance and compliance requirements, including GDPR/CCPA data anonymization, audit logging, and right-to-be-forgotten patterns.
• Strong data modeling skills; ability to design normalized schemas appropriate for goal-tracking, rating workflows, and calibration history.
• Knowledge of software engineering best practices for analytics: version control (Git), code review, testing, and documentation.
• Interpersonal and communication skills; ability to collaborate effectively with non-technical HR and People Operations stakeholders to translate business requirements into data assets.

Nice To Have:

• Experience supporting HR, performance management, or workforce analytics data products at a similar scale (~1,000–2,000 employees).
• Familiarity with Streamlit in Snowflake or similar lightweight app frameworks, enabling effective collaboration with the App Developer on data interface design.
• Experience with BI tools such as Tableau, Looker, or equivalent that may be used for supplemental HRBP or ELT reporting.
• Exposure to Snowflake cost governance and compute management, including virtual warehouse sizing and credit optimization for seasonal workloads.
• Prior work in a fast-moving tech or media company with iterative, agile delivery and cross-functional stakeholder engagement.

How we Reward you:

Realtor.com is committed to investing in the health and well-being of our employees and their families. Our benefits programs include, but are not limited to:

• Inclusive and Competitive medical, Rx, dental, and vision coverage
• Family forming benefits
• 13 Paid Holidays
• Flexible Time Off
• 8 hours of paid Volunteer Time off
• Immediate eligibility into Company 401(k) plan with 3.5% company match
• Tuition Reimbursement program for degreed and non-degreed programs
• 1:1 personalized Financial Planning Sessions
• Student Debt Retirement Savings Match program
• Free snacks and refreshments in each office location