Job Description

We are seeking an accomplished Senior Data Engineer to join our Data Engineering & Data Warehouse team. As a Senior Data Engineer, you will be a key contributor to our data ecosystem, ensuring efficient data processing, robust pipelines, and seamless integration. Your expertise in Snowflake, IDMC, Airflow, Python, and extensive knowledge of Snowflake stored procedures will be invaluable.

Responsibilities:

• Design and Develop Data Pipelines:

• Collaborate with cross-functional teams to understand data requirements and architect scalable, reliable data pipelines.

• Implement ETL processes for data warehousing and analytics.

• Optimize data ingestion, transformation, and loading workflows.

• Snowflake Expertise:

• Configure and manage Snowflake accounts, warehouses, and databases.

• Design and implement Snowflake schemas (e.g., star schema, snowflake schema) for efficient querying.

• Leverage your years of experience with Snowflake stored procedures to enhance data processing and performance.

• IDMC (Integrated Data Management Console):

• Utilize IDMC for monitoring, managing, and troubleshooting data pipelines.

• Set up alerts, track job execution, and optimize resource utilization.

• Airflow Workflow Orchestration:

• Develop and maintain Airflow DAGs for scheduling and orchestrating ETL tasks.

• Monitor task execution, handle retries, and manage dependencies.

• Python Development:

• Write clean, efficient Python code for data processing, transformation, and automation.

• Leverage Python libraries (e.g., Pandas, NumPy) to manipulate data effectively.

• Nice-to-Have: SQL Server:

• Familiarity with SQL Server for legacy systems or hybrid environments.

• Ability to optimize SQL queries and troubleshoot performance issues.

Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or a related field.

• Minimum 5 years of experience as a Data Engineer, with a focus on Snowflake, IDMC, and Airflow.

• Proven expertise in Snowflake stored procedures.

• Strong understanding of data modeling, ETL principles, and data warehousing concepts.

• Excellent problem-solving skills and attention to detail.

• Effective communication and collaboration skills.

If you are passionate about data engineering, thrive in a fast-paced environment, and enjoy solving complex data challenges, we encourage you to apply!

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.

At Anywhere Real Estate, diversity fuels success – for our company, for our employees, and for our industry. We strive to be a top destination for diverse talent, committed to creating a culture of belonging that empowers everyone’s next move. We pursue talent – strategic thinkers who are eager to always find a better way, relentlessly focus on talent, obsess about growth, and achieve exceptional results. We value diversity – respecting backgrounds, cultures, perspectives, and beliefs. We develop our diverse talent base – through increasing representation in executive key leadership roles with actions including mentorship programs and partnerships with real estate associations that promote diversity and inclusion. Read more about our company’s diversity, equity, and inclusion efforts in our annual Corporate Social Responsibility Report (https://assets.website-files.com/633f08923c4c519693723aa5/63f7690462db639dcd8b18de_Anywhere%20CSR%20Report%202022.pdf) .

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

• Recognized as one of the World’s Most Ethical Companies since 2011.

• Anywhere has also been designated a Great Place to Work since 2019.

• Recognized by Fortune as one of America’s Most Innovative Companies.

• Honored by Forbes as one of the World’s Best Employers for Diversity and Top Female Friendly Companies.

With a diverse employee population, we know we will succeed together and move real estate to what’s next. We hope you’ll join us.