Analytics Engineer

Recognized as the No. 1 site trusted by real estate professionals, Realtor.com® has been at the forefront of online real estate for over 25 years, connecting buyers, sellers, and renters with trusted insights and expert guidance to find their perfect home. Through its robust suite of tools, Realtor.com® not only makes a significant impact on the real estate industry at large, but for consumers, navigating the biggest purchase they will make in their life, by providing a user experience that is easy to use, easy to understand, and most of all, easy to make decisions.

Join us on our mission to empower more people to find their way home by breaking barriers to entry, making the right connections, and building confidence through expert guidance.

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:

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

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

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

• 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

Do the best work of your life at Realtor.com®

Here, you’ll partner with a diverse team of experts as you use leading-edge tech to empower everyone to meet a crucial goal: finding their way home. And you’ll find your way home too. At Realtor.com®, you’ll bring your full self to work as you innovate with speed, serve our consumers, and champion your teammates. In return, we’ll provide you with a warm, welcoming, and inclusive culture; intellectual challenges; and the development opportunities you need to grow.

Diversity is important to us, therefore, Realtor.com® is an Equal Opportunity Employer regardless of age, color, national origin, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, marital status, status as a disabled veteran and/or veteran of the Vietnam Era or any other characteristic protected by federal, state or local law. In addition, Realtor.com® will provide reasonable accommodations for otherwise qualified disabled individuals.