Job Description
The client is seeking a Data Engineer to join their fast‑growing data team and play a critical role in building, maintaining, and scaling a modern AWS‑based data lake house. This individual will focus heavily on ingesting, transforming, and modeling geospatial and tabular data—bringing spatial data such as points, polygons, routes, and raster datasets into production‑grade pipelines and databases rather than working solely within desktop GIS tools. The Data Engineer will design and maintain robust data pipelines, develop spatially aware data models, and partner closely with cross‑functional teams to deliver reliable, scalable data solutions while leading technical initiatives in an Agile environment. The salary range for this position will range between 100-115K+ annually once converted from contract depending on level of experience.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
• 5+ years of experience as a Data Engineer supporting complex, enterprise‑level environments
• Strong experience with PostGIS, including storing and querying spatial data in PostgreSQL using functions such as spatial joins, distance calculations, and containment queries
• Hands‑on experience loading and managing common GIS formats (GeoJSON, Shapefiles, GeoTIFFs) into databases using Python and GDAL‑based tooling
• Proven experience writing DBT models, including models that incorporate spatial SQL logic
• Experience using Dagster to orchestrate data ingestion and transformation pipelines
• Strong Python experience, including writing and maintaining production code using libraries such as geopandas, rasterio, boto3, and related tooling
• Strong SQL skills, including query development, data analysis, and reporting
• Experience working with multiple SQL databases such as PostgreSQL, SQL Server, MySQL, or Oracle
• Server or platform administration experience, including job scheduling, automations, and pipeline maintenance
• Experience working in both Windows and Linux environments
Nice to Have Skills & Experience
• Experience with big data technologies such as Spark
• Familiarity with Microsoft Power Platform
• Proven experience leveraging Generative AI to improve data quality, accessibility, pipeline performance, or operational efficiency
• Experience with machine learning workflows or data preparation for ML use cases
• Proficiency with AWS services such as S3, EC2, RDS, Redshift, and familiarity with comparable Azure services
Strong experience using Pandas for data transformation and analysis
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.