15966BR

Senior Lead Engineer, Data Engineering

Madison

New Jersey

Job Description

Join us as we build a next-generation Enterprise Data Warehouse Platform to reengineer a real estate enterprise! As a Sr. Manager, you will join our Cloud Data Warehouse Team to build an Enterprise Data Warehouse serving agents, brokers, home buyers, and sellers!

What we’re looking for:

You’re a dedicated, creative, and motivated manager & architect who loves to craft/build Data Warehouses Platform and is ready to lead a team of individuals who share your passion. With a related degree under your belt—and relevant experience—you’re ready to take your Data Warehousing knowledge to the next level. You enjoy designing and implementing Data Warehouses, Enterprise Dimensions, Facts, and Reports within the Snowflake Cloud Data Platform. With your unwavering dedication to Data Quality, dimension modeling skills, and collaborative work ethic, you’ll do great things here at Anywhere.

What you’ll do:

• Lead Snowflake Cloud Data Warehouse Operations (Cost optimization, Role-based Data Access, Data Privacy, Security, Compliance, and Governance).

• You’ll lead a team of data engineers to improve & maintain Cloud Data Products such as Affiliate Insight, SpendCube, Product Metrics, and Listing Analytics.

• You’ll co-lead the warehouse design for legacy migration and green field projects such as Dash EDW Migration & MARS (Dimension modeling & Warehouse Design).

• You’ll mentor/manage a team to develop ELTs for Facts & Dimensions of new DataMarts.

• You’ll be responsible for ensuring data quality and data integrity in the Cloud Data Products.

• You’ll be responsible for crafting CI/CD for the Cloud Data Products using Snowflake and PowerBI/ThoughtSpot.

• You’ll manage/own Snowflake’s Vendor relations.

EDUCATION AND EXPERIENCE/SPECIAL SKILLS/TECHNOLOGIES/TOOLS REQUIREMENTS

• Bachelor’s in Computer Science, Engineering, or related technical field or equivalent combination of training and experience.

• 3+ Years of experience leading & developing teams.

• 5+ Years of experience using Snowflake Cloud Data Warehouse Platform.

• 5+ Years of experience with Airflow, Snow SQL, and Python.

• 5+ Years of experience with Data Quality.

• 7+ Years of experience in crafting, developing, and implementing ETL pipelines to load data to a Data Warehouse. Performance tuning of queries by maintaining aggregates, compression, partition, query plans for ETLs, and Reporting SQL Queries.

• 7+ Years of experience developing Enterprise Data Models with at least one enterprise modeling tool and data integration platform (Erwin, Embarcadero, Informatica, Talend, SSIS, DataStage, Pentaho). Embarcadero is helpful.

• 10+ Years of experience in designing, developing, and implementing Enterprise Data Warehouses and Dimension Modeling.

• Excellent collaboration skills and a great teammate.

• Excellent in system analysis, documentation, and designing technical specifications of processes.

• Excellent written and verbal communication skills in English

#LI-DH2

#LI-Remote

#Dice

#AnywhereEngineers

Employment Type

Full-time

Company

Anywhere Real Estate Inc

About Us

Anywhere Real Estate Inc. (http://www.anywhere.re/) (NYSE: HOUS) is on a mission to empower everyone’s next move. Home to some of the most recognized brands in real estate Better Homes and Gardens® Real Estate (https://www.bhgre.com/) , Century 21® (https://www.century21.com/) , Coldwell Banker® (https://www.coldwellbanker.com/) , Coldwell Banker Commercial® (https://www.cbcworldwide.com/) , Corcoran® (https://www.corcoran.com/) , ERA® (https://www.era.com/) , and Sotheby's International Realty® (https://www.sothebysrealty.com/eng)

The Anywhere portfolio includes franchise and brokerage operations as well as national title, settlement, and relocation companies and nationally scaled mortgage origination and underwriting joint ventures. Supporting approximately 1.5 million home transactions in 2021, Anywhere is focused on simplifying, digitizing and integrating the real estate transaction for all consumers, no matter where they may be in their home buying and selling journey. With innovative products and technology, Anywhere fuels the productivity of its approximately 196,200 independent sales agents in the US and approximately 136,400 independent sales agents in 118 other countries and territories. Recognized for twelve consecutive years as one of the World’s Most Ethical Companies, Anywhere has also been designated a Great Place to Work four years in a row, named one of LinkedIn’s 2022 Top Companies in the U.S., and honored by Forbes as one of the World’s Best Employers 2022.

At Anywhere, diversity fuels success – for our company and for our employees. We strive to be the preferred company for diverse talent, committed to creating an inclusive environment that encourages everyone to succeed. We pursue talent – strategic thinkers who are eager to innovate, focused on execution and accountable for results. We value diversity – respecting backgrounds, cultures, perspectives.

You’ll find our commitment to diversity reflected in our achievements:

• Forbes 2022 Best Employers for Diversity.

• Forbes 2022 World’s Top Female Friendly Companies.

• Recognized on the 2020 Human Rights Campaign Corporate Equality Index.

• Recognized for gender diversity on our board of directors by Executive Women of New Jersey and Women’s Forum of New York.

With diversity, we succeed together. We hope you’ll join us.

EEO Statement

EOE AA M/F/Vet/Disability