About Streams Tech:

Streams Tech, Inc. is an engineering and technology firm based in Leesburg, VA, specializing in environmental modeling, GIS, and enterprise software development for government and private-sector clients.

The Role:
We are seeking a skilled ETL Developer to design, build and maintain scalable data extraction and integration pipelines for enterprise asset management systems. You will work with diverse data sources, from PDF inspection reports and geodatabases to ERP financial data, ensuring high-quality, geospatially enabled data flows into PostgreSQL and enterprise GIS platforms. You will collaborate directly with client asset management teams, GIS architects and IT stakeholders in a fast-paced, mission-driven environment. This role is primarily remote (US-based) and you need to occasional travel to Leesburg, VA and client sites in the USA.

• Design, develop and maintain robust ETL/ELT pipelines to extract, transform and load data from PDFs, Excel, CADD files, geodatabases and ERP systems into PostgreSQL/PostGIS and ArcGIS environments.
• Write clean, reusable Python scripts to automate data extraction, parsing, cleansing, and quality assurance workflows.
• Engineer repeatable, scheduled processes for updating enterprise geodatabases and relational data stores with full audit trails and error handling.
• Partner with GIS architect and client IT teams to align logical and physical data models, ensuring seamless integration with ESRI platforms.
• Maintain all source code, workflow documentation and version control in GitHub with clear technical specifications and end-user guides.
• Lead data validation, QA/QC and troubleshooting efforts to ensure accuracy, granularity and parent-child referential integrity across asset inventories.

Bachelor's in Computer Science, Data Engineering, GIS, Information Technology or a related field.

5+ years of hands-on ETL development, data engineering or backend integration experience.

• Strong Python programming for data automation, extraction and transformation.
• Deep expertise with PostgreSQL/PostGIS, relational database design and complex SQL.
• Proven track record parsing unstructured and semi-structured data sources, including PDF, Excel/CSV and working with geospatial formats such as shapefiles and file geodatabases.
• Proficiency with Git, collaborative software development workflows and technical writing.
• Experience with Microsoft Dynamics 365, Power Platform, Azure Data Services, or similar cloud data platforms is preferred.
• Experience with ArcPy, FME (Safe Software), or other spatial ETL and geoprocessing tools is preferred.
• Having experience with data modeling, data dictionary development and familiarity with data lake or warehouse architectures will be a plus.
• Exposure to infrastructure asset management, linear referencing systems, or transit data domains will be added advantage.

Competitive - Commensurate with Experience

Ownership of architecture decisions and direct client collaboration

Exposure to enterprise-scale geospatial systems and multi-agency coordination

• Technical excellence is table stakes; integrity is the differentiator.
• Client missions become our missions.
• Growth is mutual.

The date of commencement depends exclusively on the client's requirements.

Only shortlisted candidates will be contacted.