ETL Developer

• Bachelor's degree in Computer Science, Software Engineering, Information Systems, Geographic Information Systems (GIS), or a related field. Master's degree is a plus.
• Minimum of 4 years as ETL Developer, Data Engineer, or similar role, with a focus on geographic data.
• Proficiency in T-SQL and PL/SQL with experience working with Microsoft SQL Server, Oracle, and PostgreSQL databases.
• Familiarity with SSRS, SSAS, SSIS and data warehousing concepts like ETL, Dimensions, Facts, Cubes.
• Demonstrated knowledge of designing, developing and integrating databases, data warehouses and multidimensional databases in MS-SQL Server.
• Knowledge of data integration patterns, database design, and data modeling principles.
• Strong programming skills in Python, C#, or other relevant languages for ETL and API development.
• Experience with API frameworks (e.g., Flask, FastAPI, or Django REST Framework).
• Experience with geographic data formats (e.g., shapefiles, GeoJSON) and geospatial tools (e.g., ArcGIS, QGIS).
• Experience with cloud platforms (e.g., AWS, Azure, Google Cloud Platform) and related data services.
• Familiarity with ETL tools like Talend, Apache Nifi, or Informatica.
• Ability to write and optimize complex SQL queries, stored procedures, triggers, and functions.
• Experience in code migration, database change management and data management through the various stages of the development life cycle.
• Familiarity with application lifecycle management (ALM) tools such as Azure DevOps and GitHub.
• Experience with version control and release management practices.
• Excellent problem-solving, collaboration, and communication skills.
• Experience with MS-SQL Server, PostgreSQL, Oracle, and/or other geospatial databases.
• Ability to collaborate effectively within a team environment.
• Strong knowledge of software architecture principles, design patterns, and best practices.
• Familiarity with DevOps practices and tools for continuous integration and delivery.
• Experience with version control using Git and GitHub and release management practices.
• Excellent problem-solving skills and ability to work effectively in a collaborative team environment.
• Strong communication skills, both written and verbal.
• ETL certifications on Microsoft SQL Server or Oracle will be a plus.

Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing.

Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.