A large-scale data modernization initiative focused on redesigning and integrating complex data systems requires an ETL Developer to support the effort.
Requirements
- Proficiency with T-SQL, PL/SQL, and hands-on experience with SQL Server, Oracle, and PostgreSQL.
- Experience with SSIS, SSRS, SSAS, and data warehousing concepts (ETL, dimensions, facts, cubes).
- Experience designing and integrating databases, data warehouses, and multidimensional data structures in SQL Server.
- Strong programming skills in Python, C-Sharp, or similar languages for ETL and API development.
- Experience with API frameworks such as Flask, FastAPI, or Django REST Framework.
- Experience with shapefiles, GeoJSON, and geospatial tools (ArcGIS, QGIS).
- Experience with cloud platforms (AWS, Azure, or GCP) and related data services.
Responsibilities
- Extract, transform, and load geographic and non-geographic data from Oracle and SQL Server databases.
- Transform raw data into structured, analytics-ready formats.
- Design and implement efficient, scalable data pipelines for large datasets.
- Automate integrations using SSIS.
- Develop, test, and maintain ETL workflows and scripts for automated data processing.
- Monitor ETL performance to ensure reliability and scalability.
- Troubleshoot and resolve complex data issues quickly.
Other
- Minimum 4 years of experience as an ETL Developer, Data Engineer, or similar role.
- Strong experience with geographic data and geospatial workflows.
- Excellent communication, collaboration, and problem-solving skills.
- Proven ability to work effectively with both technical and non-technical staff.
- Work closely with GIS analysts, developers, and stakeholders to understand data and business requirements.
