Data Engineer III
Position: Data Engineer III
Location: fully remote – MUST work CST hours
Duration: 1 year
Job Description:
SQL, Python, DBT, utilize geospatial data tools (PostGIS, ArcGIS/ArcPy, QGIS, GeoPandas, etc.) to optimize and normalize spatial data storage, run spatial queries and processes to power analysis and data products
Design, create, refine, and maintain data processes and pipelines used for modeling, analysis, and reporting using SQL (ideally Snowflake and PostgreSQL), Python and pipeline and transformation tools like Airflow and dbt
Conduct detailed data research on internal and external geospatial data (POI, geocoding, map layers, geometrics shapes), identify changes over time and maintain geospatial data (shape files, polygons and metadata)
Operationalize data products with detailed documentation, automated data quality checks and change alerts
Support data access through various sharing platforms, including dashboard tools
Troubleshoot failures in data processes, pipelines, and products
Communicate and educate consumers on data access and usage, managing transparency in metric and logic definitions
Collaborate with other data scientists, analysts, and engineers to build full-service data solutions
Develop and communicate architecture, code patterns and data structure design choices to team of data scientists, analysts and engineers laying out tradeoffs
Optimize query and database performance through designing, creating, refining, and maintaining performance management system
Work with cross-functional business partners and vendors to acquire and transform raw data sources
Design, create, refine, and maintain data ingestion process
Provide frequent updates to the team on progress and status of planned work.