Data Engineer

City
Irvine

State
California

Job Location
Irvine Regional Office (Derian)

Position Type
Regular

About Us
The Data Platform team is a tight group of technologists and data scientists whose mission is to spread insight, information, and data driven solutions throughout the organization. We have complex data pipelines, large macroeconomic and market-based data sets, as well as our proprietary in-house data to develop with.

Role Description
We are seeking a highly skilled and experienced Data Engineer to join our growing team. You will be responsible for designing, developing, and maintaining our data infrastructure and architecture. You will work closely with our data architect, data engineers and data analysts to ensure the availability and reliability of our data pipelines and systems. The ideal candidate has a strong background in data engineering and is passionate about leveraging data to drive business insights and decisions. Please note that this job position entails in-person office requirements for a minimum of 3 days per week: Mondays, Tuesdays, and Wednesdays, located at Essex's corporate offices in Irvine, Woodland Hills, San Mateo, and Bellevue.

Responsibilities

1. Design, build, and maintain scalable and high-performance data pipelines and infrastructure.
2. Collaborate with stakeholders to understand requirements and develop efficient data assets.
3. Implement data integration, transformation, and cleanse pipelines using industry best practices.
4. Design and implement data models and schemas to support business reporting and analytics.
5. Identifying and resolving performance bottlenecks and data quality issues.
6. Managing and monitoring data storage, backup, and recovery systems.
7. Performing data validation, testing, and ongoing data quality assurance.

Qualification And Work Experience Requirements

1. Bachelor's degree in computer science, engineering, or related field.
2. 2 - 5 years of demonstrable professional experience working as a Data Engineer.
3. Expert knowledge of data processing and transformation techniques.
4. In-depth understanding of data warehousing concepts and technologies.
5. Strong programming skills in Python and SQL.
6. Experience with cloud-based data platforms such as AWS, Google Cloud or Azure.
7. Proficiency in designing and implementing data models and schemas.
8. Knowledge of working with SSAS cubes using MDX and SSRS.
9. Familiarity with data integration and ETL tools such as Informatica, dbt, Matillion or Talend.
10. Practical knowledge of DevOps best practices.
11. Strong problem-solving skills and attention to detail.
12. Excellent communication and collaboration skills.
13. Ability to work effectively in a fast-paced and dynamic environment.
14. Prior multi-family real estate experience a plus.

Preferred Experience

1. Experience building data models
2. Experience with Azure SQL or SQL Server
3. Experience with Snowflake
4. Experience with dbt
5. Experience with Matillion
6. Knowledge of Yardi

All full-time regular associates are offered competitive salaries, experience career growth, and are eligible for benefit packages that include medical, dental, vision, paid parental leave, 401k employer match, excellence rewards, wellness programs, and much more. With our Sunday property operations office closures, 10 paid holidays, and 15 PTO days, work/life balance is a priority! Additionally, most positions are eligible for a housing discount of 20%.

Essex provides great communities in which to live, work and invest. We are a purpose-driven company, and we pride ourselves on promoting an internal culture of growth and opportunity by engaging, enabling, and empowering our teams. Working at Essex is not a destination. It is a journey where you can confidently build your career.

The salary range for this position is $101,000.00 - $151,000.00 per year. New hires generally start between $101,000.00 - $127,000.00 per year. The final salary offer will be determined after reviewing relevant factors, including but not limited to skill sets; relevant experience; internal equity; and other business and organizational needs.

This role is also eligible to participate in Essex’s discretionary Annual Bonus program that is commensurate with the level of the position.