Sr. Analytics Engineer

Sr. Analytics Engineer (340B)

 

This position will be responsible for analyzing Omnicell 340B business functions, processes, and activities to improve computer-based business applications for the most effective use of money, materials, equipment, and people.

An extensive working knowledge of SQL Server using T-SQL is required for analysis and troubleshoot business data such as pharmacies and claim data.

Responsibilities:

• Utilize Microsoft SSMS, SQL Reporting Services or equivalent tool set to analyze stored procedures and troubleshoot issues.
• Collaborate with clients, vendors, account management and pharmacy consultants to fix operational system issues including reports using Microsoft SSMS.
• Review business rules in existing applications
• Must have the ability to communicate with client business and technology representatives concerning data format and transfer requirements.
• Application Testing
• Documentation of applications and change tracking.
• Work with internal partners to improve and expand on existing analytical capabilities.
• Understand pharmacy claim data and transform data from disparate sources for use within the organization.
• Assist in other technical projects as needed.
• Working assigned tickets and managing competing priorities.  Process includes research, troubleshooting and applying data changes.  No programming code changes will be needed but will involve researching code to identify root cause.
• Lead the 2-member Alerts Team and provide technical consultation for day to day issues.  

Required Knowledge and Skills:

• Experience developing solutions that leverage Microsoft Office products.
• Proficient in Microsoft Office, with extensive experience working with Excel.
• Detail-oriented
• Solid, independent worker (this position will likely be based in the applicant’s home)
• Creativity and flexibility are a must. Omnicell is a dynamic environment and requires a candidate that is comfortable facing new challenges.
• Operational role- fast paced

Basic Qualifications:

• Bachelor’s degree 
• Must have 10+ years’ experience utilizing Microsoft SSMS, SSRS, SSIS, SQL Reporting Services or equivalent tool set for importing and transforming data using T-SQL scripting.

Preferred Qualifications:

• Knowledge of the pharmacy industry and pharmacy data, 340B drug pricing program experience is a plus.
• Preferred background of 3-5 years working with pharmacy data and in-depth understanding of prescription claims adjudication and PBM platforms.
• Experience with data interchange files. X12, HL7, NCPDP preferred.
• Experience with EMR systems (EPIC, Centricity, Meditech) is a plus

Work Conditions:

• Remote position. Typical working hours will be CT .

 

Since 1992, Omnicell has been committed to transforming pharmacy care through outcomes-centric innovation designed to optimize clinical and business outcomes across all settings of care. We strive to be the healthcare provider’s most trusted partner by our guiding promise of “Outcomes. Defined and Delivered.”    Our comprehensive portfolio of robotics, smart devices, intelligent software, and expert services is helping healthcare facilities worldwide to improve business and clinical outcomes as they move closer to the industry vision of the Autonomous Pharmacy.  Our guiding principles inform everything we do: 

• As Passionate Transformers, we find a better way to innovate relentlessly. 
• Being Mission Driven, we consistently deliver on our promises. 
• Our Entrepreneurial spirit makes the most of EVERY opportunity for innovation. 
• Understanding that Relationships Matter creates synergies that yield the greatest benefits for all.
• Intellectually Curious, eager to think deeper to learn and improve.
• In Doing the Right Thing, we lead by example in ALL we do. 

We are deeply committed to Environmental, Social, and Governance (ESG) initiatives. Our ESG efforts focus on creating an inclusive culture and a healthier world. This includes our Employee Impact Groups, which foster diversity and inclusion, as well as our learning and well-being programs that support personal and professional growth. We al