Organizational Intelligence is a developer of Decision Support Systems for the healthcare industry. Our systems represent the next generation of Business Intelligence, using a web-based application backed by Microsoft SQL Server. We specialize in integrating disparate source systems seamlessly into a comprehensive analysis and reporting system with innovative features and advanced technology to provide hospitals with the tools they need to improve financial performance and processes. Organizational Intelligence is privately held and is based in Portland, Oregon.

Organizational Intelligence offers an exciting and challenging career in an innovative and dynamic employment environment. We are always interested in speaking with individuals who are interested in joining our growing team. Please direct inquiries to:

careers@oihealth.com

OPEN POSITIONS

Position Title: Database/ETL Developer

Position Summary

As a Database/ETL Developer, you will design, develop, implement and deploy portions of Organizational Intelligence’s web application suite. You will be a member of a team that makes enhancements to the existing software and develops new functionality and modules for the system. You will focus on the implementation of database systems and ETL processes. You will also create and maintain project documentation.

Essential Functions

• Strong knowledge of and experience with Microsoft SQL Server 2005
• Knowledgeable of RDBMS design best practices, especially as it pertains to DW/BI
• Very strong experience working with Integration Services
• Knowledge of the Integration Services object model
• Experience with Reporting Services, especially working with Report Builder for ad-hoc reporting
• Knowledge of Analysis Services a plus (but not required)
• Very strong knowledge of Transact-SQL, stored procedures, user-defined functions, etc.
• Experience with SQLCLR and writing custom assemblies in C# for SQL Server is a plus
• SQL Server database administration experience

Essential Qualifications

• Two or more years database design and implementation experience, preferably with SQL 2005
• Good analytical and design skills
• Strong written and verbal communication skills
• Be able to demonstrate past work including T-SQL examples and table designs
• Self motivated, a quick learner, and high attention to detail

Essential Skills

Skill	Level	Skill	Level
SQL Server 2005	Advanced	Relational Database Design Theory	Advanced
SQL Server Integration Services	Advanced	ETL Theory and Best Practices	Advanced
SQL Server Reporting Services	Intermediate	T-SQL	Advanced
SQL Server Analysis Services	None to Beginner	SQL Server Assemblies	Recommended
SQL Server Agent	Intermediate	C#	Recommended
Database Administration	Intermediate	VBA (for SSIS)	Intermediate