2707 Business Systems Analyst/SQL Developer

Location: Portland, OR

If you’re a Business Systems Analyst and have strong SQL experience, we are definitely interested in talking with you. Our client is a mature, laid-back organization custom software development company that is small, nimble, flat, and a great place to work overall. If you are interested to know more, please submit your resume to Further, we value diversity in the workplace and encourage women, minorities, and veterans to apply. Thank you!

Job Type: Contract to Hire

Additional Information:
We have a need for a skilled BSA/SQL 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 write SQL code 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.

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. You are willing and able to travel to client locations on a limited basis.

We 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 with us will offer an exciting path for advancement into higher responsibility roles as we continue expand our industry reach and grow our team.

* - 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

Technical/Analytical Skills
* Data analysis
* SQL programming
* Requirements gathering