Senior Data Engineer
Irvine, CA
City
IrvineState
CaliforniaJob Location
Irvine Regional Office (Derian)Position Type
RegularAbout 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 Senior 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
Design, build, and maintain scalable and high-performance data pipelines and infrastructure.
Collaborate with stakeholders to understand requirements and develop efficient data assets.
Implement data integration, transformation, and cleanse pipelines using industry best practices.
Design and implement data models and schemas to support business reporting and analytics.
Identifying and resolving performance bottlenecks and data quality issues.
Managing and monitoring data storage, backup, and recovery systems.
Performing data validation, testing, and ongoing data quality assurance.
Qualification and Work Experience Requirements
Bachelor's degree in computer science, engineering, or related field.
5+ years of demonstrable professional experience working as a Data Engineer.
Expert knowledge of data processing and transformation techniques.
In-depth understanding of data warehousing concepts and technologies.
Strong programming skills in Python and SQL.
Experience with cloud-based data platforms such as AWS, Google Cloud or Azure.
Proficiency in designing and implementing data models and schemas.
Knowledge of working with SSAS cubes using MDX and SSRS.
Familiarity with data integration and ETL tools such as Informatica, dbt, Matillion or Talend.
Practical knowledge of DevOps best practices.
Strong problem-solving skills and attention to detail.
Excellent communication and collaboration skills.
Ability to work effectively in a fast-paced and dynamic environment.
Effective communication and collaboration abilities.
Prior multi-family real estate experience a plus.
Good meme selection and desire to have fun.
Preferred Experience
Experience building data models
Experience with Azure SQL or SQL Server
Experience with Snowflake
Experience with dbt
Experience with Matillion
Knowledge of Yardi
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 $116,000.00 - $175,000.00 per year. New hires generally start between $116,000.00 - $145,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.