TroyRecruiter Since 2001
the smart solution for Troy jobs

Account Manager/Data Analyst

Company: RDS Services
Location: Troy
Posted on: January 9, 2021

Job Description:

Title: RDS Program Account CoordinatorEmployee Type: PermDivision: RDS ServicesManages: NoneReports To: RDS Program ManagerPurpose of RoleThe RDS (Retiree Drug Subsidy Program) Account Manager/Data Analyst should possess strong analytical skills, quantitative and problem-solving abilities and a thorough knowledge of all time-sensitive tasks related to the Retiree Drug Subsidy (RDS) program. This position will require excellent communication skills and the ability to work both independently and collaboratively with data systems team members, vendors and clients. Their additional responsibility is to also serve as the liaison between their RDS clients and vendors. The Account Manager/Data Analyst will work on all time-sensitive tasks related to the RDS program, and understands all aspects relating to the RDS website and RDS database.We are looking for a candidate who has strong administrative skills, multi-task abilities, proficiency in excel. This person must be an expert in time-management, possess strong customer service skills, can create good relationships with clients and vendors, and interaction with the entire RDS team to accomplish the goals of the companyDuties

  • Work with Program Manager/Account Managers to Assess Data Requirements
  • Work with Program Manager/Account Manager during New Client Start-up, RDS Re-Opening Opportunities, RDS Administration and RDS Reconciliations
  • Attend meetings as needed with RDS Program Manager, Database Programmers and Program Analysts to discuss data issues, database application, RDS changes and updates, client deadlines, etc.
  • Analyze complex data systems and document data elements, data flow, relationships and dependencies
  • Requesting of pertinent RDS Reopening membership and claims data from the assigned vendors
  • Verifying whether data from the vendors is both substantial enough and suitable for importing into the internal company database
  • Communicating to the Data Analysts when data is ready for review and maintaining a workflow schedule for follow ups when needed
  • Develop automated and reusable routines for extracting requested information from database
  • Compile detailed reports using data reporting tools such as Excel
  • Work with Program Developers and Management providing input regarding company data standards and practices
  • Work in partnership with Program Manager and Database Developers to build data transactional and warehouse systems
  • Assist with data aggregation projects and application development activities
  • Responsible for prescription and medical claims data integrity, data scrubbing, and ad hoc reporting
  • Analyze and Audit data for quality assurance
  • Facilitate communications with RDS team members
  • Quality control inspection of data and working with a data dictionary
  • Maintain knowledge of RDS policies and procedures
  • Rely upon experience/judgment, in conjunction with applying data Excel/SQL procedures, to solve problems
  • Manage ongoing administration of the RDS program
  • Obtain retiree information from clients, prepare via RDS database, and upload to CMS as needed
  • Upload response, weekly notification, and part D notifications into RDS database
  • Identify and resolve subsidy issues and other administration issues as needed
  • Understand and interpret "Reason Codes", and give guidance to clients on communicating to Medicare eligible retirees
  • Coordinate and complete client applications 90 days prior to each new plan year. Request 30-day extension if necessary
  • Coordinate and complete client reconciliations prior to 15 months after an application plan year
  • Assist in the review of claims data received by carriers (PBMs), make corrections, and submit to CMS for subsidy payment
  • Communicate important RDS program notifications to clients and complete or assist in updating RDS website as neededSkills
    • Strong proficiency in data analysis, manipulation, and ad hoc data analysis reporting Import and export data for analysis
    • Knowledge of relational database architecture Open Database Connectivity (ODBC)
    • Data analysis and interpretation Data manipulation through queries Data mining
    • Data specification documentation
    • Ability to measure data quality and integrity Possess strong analytical and communications skills Detail-oriented with the ability to multi-task Actuarial and Math/Studies are a strong plus
    • Systems Skills: (Novice, Proficient, Expert, Master)
    • MS Access: Proficient
    • MS Excel: Expert
    • MS SQL Server Management Studio (SQL Programming): Proficient MS Word: ProficientEducational / Experience Requirements
      • 2+ years as data analyst , preferred
      • Medicalbilling, PBM or pharmacybackground a plus
      • Bachelor's degree in computer science or information systems, requiredCompany Background/ProductsWe are a "data aggregation" company with expertise in managing CMS's Retiree Drug Subsidy("RDS") for employer groups. We are looking to enhance our team by hiring an experienced data analyst, preferably with a pharmacy or medical billing background, to leverage our existing core competencies and expand our market share in this market segment. Our data aggregation application allows us to explore various RDS servicing opportunities. This includes opportunities under CMS re-opening provisions that enable us to audit prior year applications and potentially secure additional subsidy dollars for clients under the RDS program.We are seeking an energetic, experienced and motivated Data/ Procurement Analyst as we continue forward with the administration of the RDS program in addition to the development and implementation of any other potential subsidy reimbursement opportunities.We offer a challenging and rewarding career opportunity in a high energy, fast paced environment. The importance of time management, organizational skills, attention to detail and teamwork cannot be overstated. Salary range is competitive and is commensurate with experience. Compensation package will also include a performance bonus program. Full range of benefits offered including 401k plan, paid vacation and generous holiday schedule.If interested, please send resume and cover letter with salary requirements to Patty Kanaras at

Keywords: RDS Services, Troy , Account Manager/Data Analyst, Executive , Troy, Michigan

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Executive Jobs

Department Manager
Description: ACTIVELY HIRING DURING COVID-19 This job posting is for a position in a restaurant owned and operated by an independent franchisee and not McDonald's USA.--This franchisee owns a license to use McDonald's (more...)
Company: McDonald's
Location: Ypsilanti
Posted on: 01/20/2021

Recruiting Manager
Description: Staffmark is a professional staffing and innovative workforce solutions provider for a vast array of clients and industries. As part of Staffmark Group, our goal is to match talented candidates with meaningful (more...)
Company: Staffmark
Location: Bowling Green
Posted on: 01/20/2021

RN Case Management
Description: We Are Hiring: Hours of operation are 8:00 a.m. - 4:30 p.m. Needs to be available to work rotating weekends and holidays. br What You Will Do: Coordinate the overall interdisciplinary plan of care for (more...)
Company: Ascension
Location: Warren
Posted on: 01/20/2021

Key Account Manager - Business Development
Description: MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an (more...)
Company: Michael Page
Location: Birmingham
Posted on: 01/20/2021

Office Manager
Description: Ref ID: 02260-0011663339Classification: Office ManagerCompensation: 21.00 to 25.00 hourlyLocal engineering firm in Belleville is seeking an experienced Office Manager to support in areas of both accounting (more...)
Company: Robert Half
Location: Belleville
Posted on: 01/20/2021

Manager Advanced Quality
Description: JOB DESCRIPTIONSummaryAQE Manager position will have direct responsibility to plan and execute Quality program deliverables as defined in Adient's Quality operation system, specifically in phases 1 thru (more...)
Company: Adient
Location: Plymouth
Posted on: 01/20/2021

Project Manager
Description: Location: Auburn Hills, MIDuration: 11 months Job Category: ITIndustry: AutomobileJob Description:- Develop list of upcoming lease expirations- Working with Purchasing and Database- Work with Plants and (more...)
Company: ICONMA
Location: Auburn Hills
Posted on: 01/20/2021

Department Manager
Description: This job posting is for a position in a restaurant owned and operated by an independent franchisee and not McDonald's USA.--This franchisee owns a license to use McDonald's logos and food products, for (more...)
Company: McDonald's
Location: Woodville
Posted on: 01/20/2021

Director Of Outpatient Services
Description: Calling all Directors of Outpatient Servives This Jobot Job is hosted by Chandler Boyd Are you a fit Easy Apply now by clicking the Apply button and sending us your resume. Salary 90,000 - 150,000 (more...)
Company: Jobot
Location: Auburn Hills
Posted on: 01/20/2021

Project Management
Description: Skills Required: PMA is proficient in MS Office Suite applications, MS Project, and OEM Internet. Will be evaluated on their demonstrated proficiency in the following attributes: Interpersonal Skills (more...)
Company: Advantage Resourcing
Location: Allen Park
Posted on: 01/20/2021

Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Troy RSS job feeds