Data Engineer (Python/SQL)

Overview

Remote
$67 - $82
Contract - W2

Skills

sql
python
dbt
airflow

Job Details

A globally leading consumer device company headquartered in Cupertino, CA is looking for a Data Engineer (Python/SQL) to join their dynamic team. This role will play a key part in building robust data foundations that power geospatial analytics and high-impact business decisions at scale.

Responsibilities:
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

Required Skills:
Proficiency in SQL (ideally Snowflake and PostgreSQL)
Proficiency in Python
Experience with DBT for data transformations and pipelines
Experience utilizing geospatial data tools (PostGIS, ArcGIS/ArcPy, QGIS, GeoPandas, etc.) to optimize and normalize spatial data, and run spatial queries and processes to power analysis and data products

Type: Contract
Duration: 12 months with extension
Work Location: Remote (CST hours)
Pay range: $ 67.00 - $ 82.00 (DOE)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About OSI Engineering, Inc.