Data Migration Analyst I (Junior)
Location: Portland, OR or Northampton, MA | Hybrid Considered
About Windsor
Windsor 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