Database Developer - Portland, Oregon


Windsor Solutions, Inc. is one of the nation’s leading consultancies specializing in developing Environmental Information Systems. Windsor is an energetic company providing progressive organizations with talented, professional, information technology teams to help solve business problems and gain efficiencies through use of proven information technology. Windsor has built a national reputation with its clients for quality and customer service.

We have a need for a skilled database analyst/developer to support implementation of our industry leading software solutions. In this position you will work with users and legacy system IT staff to understand new database requirements and existing database structure and content. You will perform gap analysis to identify legacy data migration issues, from both practical (physical) and policy (business requirement) perspective, and will develop database procedures to extract, transform and load data into new, target database systems.

As an ideal candidate:

You have experience working with customers to understand complex business processes, and how they are realized through their data structures and data content.  You have extensive experience extracting, massaging, scrubbing, and transforming data between databases, and understand how to correlate data structures and business rules between source and target systems.

You are experienced in the analysis of data needs, data mapping and the manipulation of complex data. You can think through complex database reconciliation issues, identify alternative solutions, and facilitate their resolution via clear documentation and communication. This position will work extensively with line of business stakeholders to design and test the data migration solutions developed. 

You will be independently responsible for creating client-readable specification documents such as flow mapping spreadsheets and communicating them to the client. You will be responsible for gathering input from the customer and translating this into the specifications and ultimately data transformation/migration routines.

You should have advanced skills with SQL, ideally with T-SQL, PL-SQL a plus.

You are self-directed but also able to interact well with client staff and teammates. You have experience taking the lead in projects and seeing them to completion.

You are able to complete tough assignments within agreed timeframes.

You are innately curious as to how things work and are not afraid to get your hands dirty.  You welcome the opportunity to look under the hood and help troubleshoot issues and improve the product. You are continually seeking to increase your technical and business analysis proficiency.

You have excellent communication and organizational abilities. Your interpersonal skills allow you to work with a diverse group of clients and colleagues and you are able to successfully complete assignments within deadlines. You are self-motivated / directed and have strong desires to expand upon your knowledge and gain additional responsibility.

Experience implementing government environmental information systems is desirable. You are willing and able to travel to client locations on a limited basis.

We at Windsor are proud of the tenacity, dedication, and perseverance of our staff. The work we do is challenging but fun, interesting and rewarding. The candidate for this position will ideally possess an innate interest and passion for both the environmental business area and modern software systems. For those with the motivation and skills, a career at Windsor will offer an exciting path for advancement into higher responsibility roles as we continue expand our industry reach and grow our team.

Windsor's offices are conveniently located close to several mass-transit options near the South Waterfront district, or bike to work!

If you think you would be a good match for this position, we'd like to discuss the possibilities with you. For further details/apply online, please visit the careers section http://www.windsorsolutions.com.

* - Mandatory skills

General Skills
  • Good written and verbal communications skills *
  • Excellent interpersonal skills *
  • Experience working effectively in a team environment *
  • Product system implementations
  • Practical consulting experience
  • Experience working with government agencies
  • Experience working with regulatory environmental agencies
  • Experience using JIRA
  • Agile/Scrum
Analytical Skills
  •   * Relational Data modeling
  •   * Data analysis
  •   * SQL (T-SQL and / or PL/SQL)
  •   * Requirements gathering

Technical Skills

  •   Databases
    • * MS SQL Server,
    • Oracle
    • DB2
    • mySQL
  • *Stored Procedures
  • *Views
  • *Functions
  • SSIS

 

 

 

Apply for this job

“I really enjoy working here. Not only does everybody care about what they do, they excel at what they do. I came to Windsor expecting to work with the best, and I haven't been disappointed.”

Scott Remick

Senior Consultant
Windsor Solutions, Inc.