TotalTek Technology

Apply Now

Apply Now

Client Overview:
Our client is a leading pharmacy benefit manager.  They continue to experience substantial growth by capitalizing on new and existing market opportunities and improved product offerings. Business growth and financial success are supported by the continued investment in technology, a commitment to operational excellence, and their workforce.

Position Summary:
Under limited supervision, the Data Analyst is responsible for designing, creating and executing analytical products including standard reporting, custom reporting, import/export data files and simulation models. Works with staff to produce routine and non-routine reports that provide valuable insight for all areas of the business to enable continuous business improvements with current practices, products, and services. This is a Direct Hire role.


  • Work with business users and decision makers at various levels within the organization to understand business data needs and translate them into reporting solutions. Develop and execute standard and custom reports and data files using AS/400 and MS SQL Server data query tools and provide to users.
  • Interpret routine and non-routine data and analyze results using statistical techniques and provide ongoing reports. Identify, analyze, and interpret trends or patterns in more complex data sets.
  • Work closely with management to prioritize business and information needs. Support corporate initiatives and projects related to data requests and analytical products. Submit routine and non-routine reports to internal staff and executive team as requested. Devote up to 10% of time providing quality management reporting for the mail service pharmacy.
  • Initially validate results to ensure data integrity of the reports and/or files produced.
  • Work with internal customers on custom data reporting and file requests to define requirements, create queries to meet requirements, conduct testing, and any import/export processes. Establish and document report data formatting, delivery methods, and maintenance procedures.
  • Work with clients to establish eligibility data exchange and write data mapping specifications for custom file layouts. This includes testing eligibility data files with vendor, defining profiles, and documenting procedures.
  • Train internal and external users on reporting tools and provide ongoing support. Work with external customers and system vendors to coordinate data file transfers.
  • May direct the work of other lower level professionals or manage processes and programs.
  • Build knowledge of the organization, processes and customers. Solve a range of straightforward problems. Analyze possible solutions using standard procedures. Receives a moderate level of guidance and direction. Problems faced are difficult and sometimes complex.
  • Complete other duties as assigned.


  • Bachelor’s degree in Information Technology, Mathematics, and/or Statistics or equivalent combination of education and experience.
  • Minimum of three years of previous related experience such as authoring SQL queries and using report writing tools with SSRS experience.
  • Prior pharmacy/medical claim data reporting and analysis. (preferred)
  • Solid knowledge of data modeling, database design, and data mining.
  • Strong problem analysis skills to include the use of mathematical concepts to validate results.
  • Strong analytical skills with the ability to collect, organize, disseminate, and present significant amounts of information with an attention to detail and accuracy.
  • Proficient with Microsoft Office Professional.
  • Clear and concise communication with strong written and verbal communication skills.
  • Ability to interact with all levels of internal and external business partners.
  • Adaptable to change and able to work independently and as part of a team.
  • Manage and prioritize work effectively with minimal supervision.

Preferred Qualifications: 

  • Prior pharmacy/medical claim data reporting and analysis. (preferred)


  • Occasional (up to 10%) travel may be required based on business need.

COVID Information:
Our client is committed to the safety of their employees.  Currently, all employees are working remotely.  Ultimately, they hope to return to the office following CDC recommended safety measures.   

About TotalTek:
TotalTek is a Technology Company providing Engineering and IT solutions.  We are a minority owned company with onshore and offshore capabilities that originated in northeast Wisconsin. Our workforce solutions and customized delivery in Project Outsourcing, Managed Resource Program and Staff Augmentation have expanded our capabilities to better serve clients. Our core value is Improving Lives for Clients and Consultants alike and is why we believe TotalTek is a simple solution to your complex Engineering and IT problems.

Apply Now

Apply Now