BI Data Analyst II

Medimpact San Diego , CA 92140

Posted 6 months ago

BI Data Analyst II

MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join our team!

Why join MedImpact? Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity, high performance, and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare.

At MedImpact, we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products, systems, and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction, service, cost, and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution!

The Scoop:

The Business Intelligence (BI) Data Analyst II is responsible for developing an in-depth understanding of the underlying data and proper business uses to translate end-user data and information requirements into a format to aid various MedImpact organizations and teams in drawing insight from that data. This includes creating queries, visualizations, algorithms, and reports. Also, as a BI Data Analyst II, you will be required to present findings to staff and mentor junior personnel. By creating a more data-driven approach to business, you will enable your colleagues to make smarter, faster decisions enabling the business to grow and adapt to an ever-changing global environment.

What You Get To Do:

  • Defines methodology and analytic approach to ensure each assigned Salesforce case is completed as efficiently as possible

  • Writes complex, highly-optimized queries across large volumes of data to create detailed and accurate outputs with understanding of statistics and Knowledge of PL/SQL and or SAS

  • Writes and maintains detailed documentation of including specifications, expected outcomes, validation methodology/processes, test results, recommendations, version control, and configuration design

  • Understands data standards and identifies data abnormalities. Instills data quality in all outputs that are delivered

  • Takes personal ownership and accountability for pre-determined Service Level Agreements by following up and following through on all deliverables

  • Effectively communicates technical and statistical findings with fellow team members

  • Promptly responds to service failures, resolves issues, and escalates concerns as appropriate

  • Promotes continuous improvement by ensuring adherence to quality principles

  • Keeps current with industries best practices and seeks additional training/seminars to improve technical skills

What You Need:

Education and/or Experience

For consideration candidates will need:

  • Bachelor degree or higher from a university in engineering, IT, economics, math, statistics, science or other related fields in quantitative or analytical discipline (or equivalent combination of education and experience)

  • Three (3) to five (5) years relevant hands-on experience in an analytics, business intelligence or comparable data engineering role, including data warehousing, and business intelligence tools, techniques and technology

  • Experience with pharmacy claims data, insurance data, managed health care industry or PBM operations preferred

Computer Skills

  • Working Knowledge of standard business Applications, Microsoft Office Suite (MS Access, MS Visio, MS Project, MS Word, and MS PowerPoint), Golden 32 or TOAD and Salesforce

  • Advanced proficiency with Excel (Pivot tables, pivot charts, conditional formatting, VLOOKUP, formulas); VBA macro experience a plus

  • Strong knowledge of PL/SQL (complex joins, nested subqueries, aggregation, partitions, functions, pivots and unions). Solid understanding of databases, their architectures and database constraints

  • Working knowledge of COGNOS is a plus

Certificates, Licenses, Registrations

MYSQL Certification or demonstrated knowledge; Oracle Certified Professional is a plus; SAS Certified Base Programmer a plus

Other Skills and Abilities

  • Executes and delivers within the confines and timeframes provided by regulatory agencies

  • Strong knowledge of the US healthcare system and healthcare claims data

  • Ability to write analytical test cases for QA

  • Ability to work beyond standard business hours as required by deadlines and deliverables

  • Ability to prioritize urgent issues effectively

  • Proven team player, delivery-focused, yet flexible and creative when called upon

  • Ability to communicate positively, tactfully and effectively with multiple stakeholders including team members, management, and customers

  • Well-developed facilitation and collaboration skills

  • Experience and understanding of how to accomplish deliverables in a matrixed environment

The Perks:

  • Medical / Dental / Vision / Wellness Programs

  • Paid Time Off / Company Paid Holidays

  • 401K with Company match

  • Life and Disability Insurance

  • Tuition Reimbursement

  • Employee Referral Bonus

This position is eligible for Employee Referral Bonus at Level I

To explore all that MedImpact has to offer, and the greatness you can bring to our teams, please submit your resume to

MedImpact, is a privately-held pharmacy benefit manager (PBM) headquartered in San Diego, California. Our solutions and services positively influence healthcare outcomes and expenditures, improving the position of our clients in the market. MedImpact offers high-value solutions to payers, providers and consumers of healthcare in the U.S. and foreign markets.



To perform this job successfully, the successful candidate must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Big Data / Cloud / BI Solution Architect


Posted 6 days ago

VIEW JOBS 10/11/2019 12:00:00 AM 2020-01-09T00:00 In a nutshell Location San Diego - CA, US Team IT Experience 8+ years Degree Bachelor Job Category Other job categories, Other job categories, Other job categories Travel 10% Introduction ASML US, LP brings together the most creative minds in science and technology to develop lithography machines that are key to producing faster, cheaper, more energy-efficient microchips. We design, develop, integrate, market and service these advanced machines, which enable our customers - the world's leading chipmakers - to reduce the size and increase the functionality of their microchips, which in turn leads to smaller, more powerful consumer electronics. Our headquarters are in Veldhoven, the Netherlands, and we have 18 office locations around the United States including main offices in Wilton, CT, Chandler, AZ, San Jose, CA and San Diego, CA. This position requires access to controlled technology, as defined in the Export Administration Regulations (15 C.F.R. § 730, et seq.). Qualified candidates must be legally authorized to access such controlled technology prior to beginning work. Business demands may require ASML to proceed with applicants who are immediately eligible to access controlled technology. Job Mission The selected candidate for the Big Data / Cloud / BI Solution Architect role will be part of the ASML US IT Data Services team and be responsible for the Cymer Light Source information management strategy and roadmap, new capability/technology assessments and pilots, and day to day operations of specific solutions within the Cymer information management landscape.This is a hands-on solution architecture role also entails additional strategic responsibilities to define Cymer's direction and influence ASML's direction for information management, analytics, and Big Data for the US and globally. Job Description * Creates and maintains information architecture and information management strategy that establishes a roadmap for future investment in business intelligence and analytics capabilities * Collaborates with business clients, IT service owners, and business analysts to understand the implications of business information needs and drive updates to the information architecture and business analytics to maximize the value of information across the organization * Identifies, selects, implements, and supports the adoption of business and IT capabilities for managing and integrating structured and unstructured information across the enterprise * Maintains a holistic view of information assets by creating and maintaining blueprints that illustrate how information is stored, processed, and accessed * Act as an information liaison between various business units and IT departments to drive adoption and awareness of information management capabilities and investments * Lead or contribute to projects, scrum teams, and provide guidance/training to IT and other staff * Performs other duties as assigned Education * Bachelor's degree related to Computer Science, Information Systems or a related field * 5+ years of experience in information architecture and management or minimum 5-7 years of experience as data analyst, business intelligence analyst, or equivalent roles Experience * Excellent verbal and written communication skills to engage with diverse organizational levels (business and IT) * Excellent customer management skills, with an advanced understanding of customer relationship building and ability to drive proposal and influence direction * Deep knowledge of enterprise Information Technology concepts and processes (i.e. ITIL, COBIT, etc.). * Must be detail oriented and have strong organizational skills to effectively participate in project meetings, discussions and issue resolution. * Must be highly skilled user of Microsoft Office products (Outlook, SharePoint, Word, Excel, PowerPoint and Visio). * Ability to maintain appropriate confidentiality of information and demonstrate ethical behavior. * Expertise with diverse approaches, models, procedures, and solutions used to deliver the duties and responsibilities mentioned above, including: oDemonstrated expertise with developing and driving realization of information architecture development, information policy formation, information taxonomy and modeling oDemonstrated competence in business domain analysis, data warehousing (design and operations), and database design oDemonstrated competence with benefits, design and management of structured and unstructured content and databases / repositories (SQL, NoSQL, HDFS/Hadoop distributions, etc.) and hands-on experience with specific products oDemonstrated competence with Microsoft SQL Server, Oracle DBMS, SAP Business Objects, and related tools is valued oWorking knowledge and understanding of benefits and positioning of data virtualization oWorking knowledge of data science, data mining, OLAP programming, database management and programming, business process modeling and analysis oWorking knowledge of mobile-enabled business analytics architecture and solutions oWorking knowledge of statistical computing and graphics programming languages (e.g. R, S-Plus, Python, etc.) oWorking knowledge of open source or commercial data visualization tools (e.g. Tableau, Qlikview, Spotfire, etc.) oWorking knowledge of cloud-based offerings and vendor differentiation related to analytics and information processing capabilities oDemonstrated experience and interest in leading or managing small regional teams Personal skills Effective communication, analytical, strong presentation skills, problem solving, collaboration skills and team oriented Context of the position Assessment of business requirements, collection and identification of technical specifications and the subsequent development of technology solutions Internal reference #40860 Asml San Diego CA

BI Data Analyst II