Data Engineer

Dig Map   Irvine, CA   Full-time     Engineering
Posted on March 15, 2020
Data Engineer Dsgn&build data extracts, transformation & load ETL & data pipelines w/SQL Server 2012, MYSQL & Python Libraries; Dsgn & dvlp data matching engine to link parcel data, assessor data, sales transactions & other datasets w/Dynamic TSQL, Stored Procedures, functions, triggers, cursors, views, joins, subqueries & table partitioning. Prfm SQL query tuning w/SQL Profiler, anlyzg execution plans, build indexes & define appropriate Isolation levels to prevent deadlocks & slow query; Dsgn & dvlp tools to streamline geospatial data anlys, data storage & data display w/ESRI ArcGIS sftwr; Prfm Entity Relationship Model & data modelling for new data sets w/Lucid chart, Erwin Data Modeler & different normalizing tech. Req: MS in CS. Job in Irvine, CA. Res: Diane Rettew,