Would you enjoy a career where you make a positive difference to the environment?

As a Windsor Data Analyst located in the Portland, OR area, you are a critical member of a product implementation team that serves our many clients. You enjoy helping our environmental agencies transform data so that they can more efficiently and effectively take the needed actions to improve the environment. During each work day, you thrive as you work independently while contributing as an active team member.

Specific responsibilities will include:

o Developing ETL (extract/transform/load) routines to migrate data from an existing client’s system(s) into Windsor-developed products.

o Supporting existing clients by troubleshooting and correcting issues in database objects (procedures, functions, triggers).

o Developing new database objects to support enhanced product functionality.

This position requires a high level of proficiency of Microsoft SQL Server’s core platform and T-SQL coding, debugging, and performance tuning.

Your communication skills are also critical: you provide effective collaboration with all stakeholders such as Windsor business analysts, the client, and other team members. As part of your job, you convey technical concepts to non-technical individuals and communicate business requirements and specifications. Once gathered, a major part of your role is to merge these requirements into the project architecture.

You are motivated towards building a long-term future with us and, like all team members, we are motivated to invest in you. Your role over time may shift and grow as you develop skills and seek new responsibilities.

About Windsor

Headquartered in Portland, Oregon, we are an agile, smaller-sized company made up of motivated and talented team members who share a passion for the environment. Since 1998, we have been developing systems and streamlining processes so our governmental agency clients can do their jobs better; protecting and improving water, air, land, natural resources, or health exposures.

We know that good ideas can come from anyone at Windsor and our core culture is about valuing everyone’s input, no matter the position. Continuous learning and growth are also encouraged. We are team players and pragmatic innovators. We love our work and maybe it’s because we fit each job, as much as we can, around the person, versus each person around the job.

Skills Required

Data Analyst Capabilities

· Microsoft SQL Server development (stored procedures, SQL queries, performance tuning)

· Expert knowledge Extract, Transform, Load (ETL) processes and tools

· Knowledge of how to retrieve, process, and migrate data from disparate client source systems which are stored in a variety of file formats, DBMSs, and file systems

· Ability to move and transform that data into the Windsor target proprietary platform

Experience

· Minimum 3 years experiences as a data analyst

· Computer science or equivalent degree preferred

Technical Skills

· Develop code using PowerShell and T-SQL

· Communicate technical details with the team and client

· Have an understanding of data models which may include relational, dimensional, entity-relationship, logical and physical and the conversion between logical to physical.

· Bring SQL Server operational experience – not necessarily at DBA level but at a functional level. This experience includes basic administrative knowledge such as backup, recovery, moving, partitioning, and both logic and performance enhancements.

Communication Skills

· Experience in requirements gathering with diverse stakeholders, documenting decisions and providing status updates as needed.

· Be able to translate technical concepts and findings into clear and actionable insights for non-technical audiences.

· Work closely with product owners and developers to implement product improvements at the database level.

· Demonstrate resourcefulness in problem-solving and balance independence with escalation when needed.

Summary

You are good fit at Windsor if you know how to:

· Target business process functions

· Relate to the underlying data model(s)

· Work with the big picture

· Get into the precise details of a problem

· Process and operate on existing data

· If needed, transform and load that data into a client’s existing system

· Troubleshoot logic and performance with SQL Server stored procedures

· Communicate to clients with an end result and client satisfaction in mind

· You need to work independently on your own but also enjoy being a team player.

Windsor Solutions jobs

Data Analyst

Data Analyst