Senior Analytics Engineer - Must have 10 years Microsoft SSMS, SSRS, SSIS, SQL Reporting Services in Plano, TX at Johnson Service Group

Date Posted: 10/12/2021

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Plano, TX
  • Job Type:
  • Experience:
    At least 10 year(s)
  • Date Posted:
    10/12/2021

Job Description

JobID: 386781

Johnson Service Group is seeking a Sr. Data Analyst/Sr. Analytics Engineer for a 1-year Contract role - 340B Experience a huge plus!

This position will be responsible for analyzing our customers 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.
  • 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.
  • Work involves Script Development, performing Peer Reviews and Post Implementation Testing of Changes deployed in Production

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. This 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.

#D800




Not Ready To Apply?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.

Never miss out on a job opportunity again by signing up for our Talent Network to receive job alerts that match your interests and experience.

Connect With Us