Business Analyst (Temporary)

Job Description:

Temporary Business Analyst

As Omnicell strives to position itself as a premier digital healthcare company, Omnicell’s 340B Data Acquisitions team is looking for a Business Analyst who will thrive in a fast-paced environment, have strong business analytics and communication skills with an eye for detail. Under the direction of a Professional Services leader, the Business Analyst will support analyzing 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 troubleshooting business data such as pharmacies and claim data.

Responsibilities:

• Primary responsibility includes understanding the scope, collecting, analyzing, defining, and documenting requirements
• Utilize Microsoft SQL or equivalent tool set to analyze data and troubleshoot issues
• Must have the ability to communicate with client business and technology representatives concerning data format and transfer requirements to derive a technological solution that would meet a given business requirement
• Must be able to develop QA test cases for requirements and participate in QA testing as needed
• Ability to walk end users through fixes to showcase how the solution would work in production
• Negotiate with stakeholders on timelines and ensure delivery as committed by prioritizing tasks to balance the immediate and long-term needs of the business
• Support Project Portfolio administrative functions as needed using Smartsheet, Salesforce, Azure Dev and change management applications
• Ability to review business rules in existing applications
• Understand pharmacy claim data and transform data from disparate sources for use within the organization
• Assist in other technical projects as needed

Required Skills:

• High level of proficiency in Microsoft Word, Excel, and Visio
• Experience with data analysis using SQL, data mapping, data entry, and reporting
• Experience documenting ETL processes and writing Business and functional/non-functional requirements along with test scenarios.
• 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

Basic Qualifications:

• Bachelor’s degree or 3 years’ experience as a Business Analyst and CBAP certification
• 3 years’ experience utilizing Microsoft SSMS, SQL Reporting Services or equivalent tool set for importing and transforming data using T-SQL scripting

Preferred Qualifications:

• 3+ years related experience in 340B, PBM, hospital, or retail pharmacy environment, working with pharmacy data, 340B drug pricing program, and in-depth understanding of prescription claims adjudication and claims platforms
• 5+ years’ experience utilizing Microsoft SSMS, SQL Reporting Services or equivalent tool set for importing and transforming data using T-SQL scripting
• Experience with data interchange files. ASC X12 Electronic Document Interchange (EDI) standards, HL7, NCPDP
• Experience with EMR systems (EPIC, Centricity, Meditech)
• Experience in project management tools such as Smartsheet or Microsoft Project
• Experience in documentation repository tools such Confluence or Sharepoint.
• Experience with working with SSIS packages
• Prior work experience with change control and project management

Work Conditions:

• Onshore/Remote environment.

Ability to travel 10% of the time

Supporting developers that will work with SQl how to map source/file data and articulate in mapping documents, Visio if needed. Basic BA skillset for a project that the requirements have been established. Needs to be self-sufficient needs to pick up in 3-4 weeks

Work with developers and cross functional l teams and analyzing existing sql procedures gather requirements gather data, documentation needs Visio workflow documents. Technical expertise to run queries. If i am getting data what to I need to know about this data file format basic BA skills. ability to articulate business and technical