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, drettew@digmap.com.