Data Migration Analyst I (Junior)

Job Description

Location: Portland, OR or Northampton, MA Hybrid Considered

About WindsorWindsor Solutions is an agile and growing company driven by talented, mission-focused people who share a passion for protecting the environment. Since 1998, we’ve partnered with government agencies to develop systems and streamline processes that improve the protection of water, air, land, and public health. We support continuous learning and growth at every level and shape roles around the strengths and goals of each individual, because we know that great ideas and real impact come from empowering people to do their best work.

The Role

As a Data Migration Analyst I, you’ll support projects that help environmental agencies transform their data into actionable insights. You’ll work closely with senior team members to help build and refine data migration routines using Microsoft SQL Server and T-SQL. This is a learning-focused role where curiosity, attention to detail, and clear communication are just as important as technical experience.

You’ll be supported and coached by experienced developers and analysts and will gradually grow into leading your own components of client projects.

What You'll Do

Assist with building ETL (Extract, Transform, Load) routines using SQL Server and T-SQL

Work with structured data from legacy systems, file exports, and databases

Support requirements gathering and assist with documenting data needs

Collaborate with Systems Analysts, clients, and developers to meet project goals

Learn and apply best practices for code structure, performance, and troubleshooting

Participate in code reviews and knowledge-sharing opportunities

What You Bring

Bachelor’s degree in Computer Science, IT, Environmental Science, or related field (or equivalent experience)

0–2 years of professional experience with SQL or data transformation

Basic knowledge of relational databases and comfort writing queries

Strong written and verbal communication skills

Eagerness to learn, take feedback, and grow into more responsibility

A collaborative mindset and interest in mission-driven work

Powered by JazzHR

ZSun2ITJeD

Full-time