IT Developer

Transform raw municipal data into actionable insights in this 6-month SSIS developer role. Utilize your SQL Server and ETL expertise to design and optimize data pipelines that will power critical city operations. This position offers hands-on experience with enterprise-level data warehousing in the public sector, providing exposure to diverse municipal systems while making a tangible impact on local government efficiency. Ideal for data integration specialists looking to apply their technical skills to meaningful public service projects in a collaborative team environment.

A Day in the Life: ETL Developer

• Check ETL job logs and troubleshoot failed data transfers
• Attend team meetings to coordinate with Database Administrators
• Optimize existing SSIS packages to improve performance
• Meet with department stakeholders to gather data pipeline requirements
• Create SQL queries and design transformation logic
• Build new ETL processes with error handling and validation
• Test data integration workflows using sample datasets
• Monitor warehouse performance and implement efficiency improvements
• Update technical documentation for data flows
• Verify data quality through reconciliation reports

Throughout your day, you'll leverage SQL and SSIS expertise to ensure critical city data flows seamlessly between systems while maintaining integrity across the enterprise.

• Bachelor's degree in Computer Science, Information Systems, or related field
• Minimum 3 years of hands-on experience developing ETL solutions using SSIS
• Strong proficiency in SQL Server and T-SQL query development
• Experience implementing and supporting data warehouse architectures
• Knowledge of data modeling best practices for dimensional data warehouses
• Familiarity with data validation techniques and error handling protocols
• Background in enterprise-level database environments
• Understanding of performance tuning for database and ETL processes
• Experience creating technical documentation for data integration workflows
• Ability to collaborate effectively with business stakeholders and technical teams

Preferred:

• Microsoft certifications (MCSA: SQL Server, Azure Data Engineer)
• Experience with Azure Data Factory, SSRS, or Power BI
• Previous work in government or public sector environments

Most Desirable Skills for ETL Developer

• ETL Development
• SQL Programming
• Data Warehousing
• Technical Problem Solving
• Database Performance Tuning
• Requirements Gathering
• Documentation
• Team Collaboration
• Analytical Thinking
• Communication
• Time Management
• Attention to Detail
• Process Optimization
• Data Quality Management
• Stakeholder Engagement
• Self-Direction
• Adaptability
• Technical Troubleshooting
• Project Planning
• Systems Integration

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

This posting is open for thirty (30) days.


It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.