Job Opening

BI Developer

Role Summary

The BI Developer will play a significant role in the technical development and maintenance of the data warehouse systems. The BI Developer is responsible for working with product management, engineering, and technology operations to share in responsibilities for database design and development, database standards, and meeting product service levels. Their purpose is to create a high level of customer satisfaction by assuring the quality, stability, and performance of the Clinicient software product infrastructure and offerings.

The position will interface primarily with internal staff and will have a high level of impact on customer satisfaction based on customers’ experience with Clinicient’s product, the release process, and customer service levels. The nature of the position entails frequent new and varied work situations with a high degree of complexity. There are some established procedures, but the individual will be expected to operate with little direct supervision.

Essential Responsibilities

  • Interface with internal teams to understand requirements for data capture and processing.
  • Propose, design, and build database packages, processes and data structures observing best practices for performance, data integrity, and security.
  • Ability to understand and foreseen challenges and tasks necessary to move from single to multi-tenancy systems.
  • Determine best solutions to meet corporate data management needs, including batch data exports and other data services.
  • Support enterprise-wide data initiatives. Grasp the strategic significance of activities performed, and is motivated by accomplishing these objectives.

Knowledge, Skills and Abilities

  • Must be a role model of Clinicient’s Core Values: People; Client Focused; Trust; Innovation; Fun; Excellence and Teamwork.
  • Strong motivation to create customer satisfaction through the delivery of high-quality end-user applications and by solving real problems for real users.
  • Self-starter able to work with little supervision.
  • Ability to handle difficult situations with diplomacy and tact.
  • Proven analytical and problem-solving abilities.
  • Ability to diagnose and solve problems creatively.
  • Ability to communicate clearly to varied audiences in writing, by phone, and in person.
  • Must work well in fast-paced, constantly changing environment.

Education and Experience

  • Minimum 7 years progressive experience working with Microsoft SQL server, with particular experience in versions 2014 or higher. SQL Server Version 2017 experience is desired.
  • Significant working knowledge of ETL, ELT, data warehouse, operational data store, bulk data operations and performance analysis with billions of rows
  • Significant experience in SSIS, SSAS, SSRS and Power BI.
  • Ability to write and understand complex SQL Server programmable objects such as stored procedures with Dynamic SQL.
  • Significant experience in MDX, DAX, DML, and Power BI, Data Gateway, Power BI Desktop, SSRS Administration, Power BI Report Server and/or
  • Working understanding of SQL Server transactions, locking, and isolation levels.
  • Significant working knowledge with analytical data modeling and development of OLAP data schema to support tabular model aggregation techniques.
  • Familiarity with performance optimization techniques, including understanding of algorithms and data structures.
  • Strong written and oral communication skills.
  • Healthcare industry experience desirable.

About Clinicient

Our Vision

Clinicient’s vision is to improve 20 million lives by 2025. This is our higher purpose and what drives us to help therapists and clinics thrive in all aspects of their business.  Get inspired by how therapists are improving lives every day.

Our Mission

Our mission is a noble one: to reward great care through partnerships with the clinicians we serve. We do this by combining the clinical tools that allow our clients to efficiently deliver and document care and the financial tools to maximize reimbursements.

Benefits and Perks

Clinicient offers comprehensive and affordable medical, dental and vision plans, flexible spending accounts, $100.00 monthly transportation reimbursement, 401k plan, wellness program, and paid time-off. We are in the heart of Downtown, Portland, Oregon and offer a flexible and creative workplace that includes a game room, fully stocked fridge, local microbrews, and many fun events throughout the year.

Clinicient is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.