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 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
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
Medical / Dental / Vision / Wellness Programs
Paid Time Off / Company Paid Holidays
401K with Company match
Life and Disability Insurance
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 www.medimpact.com/careers
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.