Data Engineer - ONLY W2

Role: Data Engineer Location: Remote Duration: 12 Months Job description: 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 architectures, 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