Omnicell, Inc. Data Analyst III ( ETL) in Raleigh, North Carolina
Data Analyst III ( ETL)
Data Analyst III
Omnicell is seeking a senior Database Analyst to join our data team. The Database Analyst position will have a multitude of responsibilities and growth opportunities. Documents and communicates database design. The position will manage data in new and sustaining environments in a Postgres RBDMs within the Healthcare space. The team environment combines knowledge from relational databases, ETL process and software, Data Cleansing, and Performance enhancements that can be gained in the way data is stored and prepared. Beyond a core foundation of OLTP SQL skills, there will be expectations and opportunities to develop reports, to work with cross-functional and cross-departmental teams, assist on data modeling with the data architects, create and maintain ETLs, create and maintain documentation, and assist in the assessment of new technologies as they present themselves. There may also be opportunities to develop some enhancements to our ETL tool using Java..
Perform and participate in all aspects of data development requirements gathering, coding, unit testing, load and performance testing, and the development of operations and implementation tools with various cross functional teams in an agile/SCRUM based software development model.
Develop logical and physical models to support not only new functionality, but the support and implementation of that functionality across clients.
Will be responsible for data tasks accepted either individually or within the scope of a team.
Regular tasks include ETLs, data cleansing, developing persistent data structures (tables and materialized views), documenting processes, and training operations and implementation.
Required Knowledge and Skills:
Strong SQL skills with an emphasis on being able to review and understand data via ER Diagrams and exploratory queries.
Strong analytical, design and problem solving skills. Proactively solve problems and suggest improvements to data architecture.
Excellent communication skills, experience of working with cross-functional teams representing the group.
Strong knowledge of Relational Database Management implementing a medium to large scale data solution.
Demonstrated expertise with enterprise level RDBMs (Relational Database Management Systems) like PostgreSQL, Sybase, Oracle, DB2, SQL Server
Demonstrated knowledge of ETL processing within a production system
Database or scripting experience within a UNIX/Linux environment
Familiarity with data driven applications.
6+ years of demonstrated work experience in database development
Deep knowledge of database development with PostgreSQL.
Experience with ETL tools such as RedPoint, SSIS, Informatica, Talend, etc.
Java Programming experience.
Hadoop experience, including (but not limited to) Spark.
Healthcare industry experience in the area of hospital and retail pharmacy.
Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.
All qualified applicants will receive consideration for employment without regard to race, sex, color, religion, sexual orientation, gender identity, national origin, protected veteran status, or on the basis of disability.
Omnicell will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.