Data Migration Analyst II/III (Mid-to-Senior)

Windsor Solutions

Portland, OR, USA

Published: 6/14/2022

Technology

Full Time

Job Description

Job DescriptionLocation: 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 II or III, you’ll play a key role in designing and implementing complex data migrations for our government clients. You’ll work independently and in teams to develop and optimize ETL routines using Microsoft SQL Server and T-SQL. At Level III, you'll also take on leadership responsibilities, guide junior analysts, and help define data architecture standards and best practices.

You’ll be part of a collaborative, mission-driven team where your technical skill and ability to communicate clearly with stakeholders will directly impact project success.

What You'll Do

Design and develop custom-coded ETL routines for large-scale data migrations
Optimize performance and troubleshoot logic within SQL Server stored procedures
Gather and interpret business and data requirements and translate them into architecture
Communicate clearly with non-technical stakeholders and explain technical decisions
Collaborate closely with Systems Analysts, developers, and project teams
Document decisions and contribute to improving internal processes
(Level III) Mentor junior team members and provide code reviews and technical guidance
(Level III) Lead discussions around database design and ETL strategy for client projects

What You Bring

Bachelor’s degree in Computer Science, IT, Environmental Science, or related field
3+ years (Level II) or 5+ years (Level III) of hands-on SQL Server development experience
Strong experience building ETL routines and working with complex data transformations
Solid understanding of relational data models and architecture
Proficiency in PowerShell scripting and data conversion workflows
Ability to balance independent execution with effective collaboration
(Level III) Demonstrated leadership, mentoring, or process ownership experience
Commitment to delivering quality work and a desire to contribute to Windsor’s long-term success

xlPQFOSmbq