Job Title: Data Engineer
Location: Fully remote (must work CST hours)
Duration: 12 Months
 
Job Summary:
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.
 
Responsibilities:

• 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 systems.
• 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.

Qualifications:
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 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 80.00/hr.