Data Warehouse Engineer

General Summary

The Data Warehouse (DWH) Engineer is part of the Reporting and Analytics team. This position is primarily responsible for the planning, execution, and maintenance of naviHealth Insights Data Warehouse, while supporting a senior engineer. The person should be able to move, integrate and transform data into business defined needs using Oracle based technology/tools, like SQL/PLSQL routines, in an agile development environment. Knowledge of Jasper is a big plus.

This is a hands-on development role at early to mid-level and the ideal candidate should have a history of building fantastic enterprise-grade products quickly and with quality. We have a culture where people do well based on their merits and their ability to contribute to the success of the larger team. The right candidate will have a key role in our challenging and fun mission that values a work-hard/play-hard model.

Principal Duties and Responsibilities

  • Creation of Oracle PL/SQL packages, complex stored procedures, partitioned tables, ad-hoc queries to support analysis, reporting, or user needs.
  • Assist the Senior Data Warehouse Engineer on their day to day activities, including development of business intelligence reporting and analytic solutions.
  • Collaborate with BI developers and product managers on delivery of reporting initiatives.
  • Perform query tuning and assist reporting engineers in designing and performance tuning their queries.
  • Troubleshoot production support issues in the reporting environment.
  • Extract data from disparate sources and transform into internal formats for loading into our platform.
  • Perform technical analysis and requirements definition with our partners on service integrations.
  • Work as a part of an Agile team to implement product enhancements.

Qualifications:

Education:

  • Bachelor's degree in computer science or related field.

Technical Skills:

  • 3+ years of experience with ETL Design & development in data warehouse setting using traditional SQL databases like Oracle.
  • 3+ years of experience in Data Warehouse, Data Modelling, and Star Schemas.
  • Must have expertise in SQL.
  • Experience with Jasper solution development and integration with existing architecture is a plus.
  • Familiarity with database design and architecture for data warehouse is a plus.
  • Experience with architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems is a big plus.
  • Understanding of quality assurance and data quality principals as applied to an ETL architecture is a plus.

Soft Skills:

  • Critical thinking abilities to take complex, ambiguous, abstract requirements and break them into smaller components, patterns, views and features.
  • Strong ability to communicate technical and data concepts to non-technical audiences, and business concepts to technical audiences.
  • Strong analytical, organizational, verbal communication and business writing skills.

About naviHealth

NaviHealth partners with health plans, health systems and post-acute providers to manage the entire continuum of post-acute care. We utilize evidence-based protocols to optimize care and bundled payment methodologies to align all stakeholders. The result: optimized care and outcomes, reduced inpatient days, reduced hospital readmissions, and increased patient satisfaction.

naviHealth Values

We care about the people we serve.

We care about each other.

We care about our communities.

We embrace innovation.

We like simple.

naviHealth ™ is proud to be an equal opportunity/affirmative action employer. We are committed to attracting, retaining and maximizing the performance of a diverse and inclusive workforce.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.