Sr. Data and Analytics Engineer

Rexford Industrial Realty, Inc. (NYSE: REXR) is a high-growth, dynamic organization with an enterprise value of more than $13BN located in Los Angeles, CA. We are looking for a motivated expert-level data engineer to help us further our business growth thought the power of data.

This is a “from the ground up” initiative with us engineering a new infrastructure, integration, and analytics platforms to enable impactful Analytics and Business Intelligence capabilities for our org. We are looking for an experienced Sr Data Engineer who will help design, develop, and deliver technology solutions to support these goals.

The ideal candidate must have a proven track record of gathering detailed business requirements, understanding internal and 3rd party data sources, and building effective data engineering solutions (ETL/ELT, data models, data repositories, data marts/data warehouse, ad-hoc result sets).

Key requirements for this role are:

• Expert knowledge of working with SQL/Azure SQL/T-SQL
• Expert at connecting to and combining data from SaaS-based data sources and ERP/CRM systems
• Expert at using various Data Integration techniques and approaches including: ETL/ELT, API and iPaaS
• Expert at setting up data integrations across various environments and data sources and repositories
• Experience with task automation, configuration, and alerts via PowerShell, Azure Data Factory, Databricks, SQL Agent, Data Pipelines
• Working knowledge of Python and/or Spark (preferred but not required)
• Expert with data modeling and aptitude for interpreting data outputs and articulating findings to users. The candidate should be comfortable telling stories with data and helping stakeholders understand what matters and what steps they can take to help their business
• Advanced knowledge of performance monitoring and optimization. Be able to analyze system resource utilization, bottlenecks, and plan platform capacity sizing (activity monitors, traces, query tuning, optimizers, etc)
• Strong communication skills
• Ability to come up to speed quickly on new projects
• AI or ML experience (preferred, but not required)
• Knowledge of either Tableau (preferred) or Power BI

Some of the systems we work with are: Yardi (multiple modules including Voyager, Deal Manager), SQL databases and DW, Smartsheet, HubSpot, DealCloud, various 3rd party data sources.