General Information

BI Data Analyst III

Description

Business Intelligence Data Analyst III

$80,218 - $110,300 - $140,382 

“Pay scale information is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any selected candidate or employee, which is always dependent on actual experience, education, qualifications, and other factors.  A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate.”

This position is not eligible for Sponsorship.

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 III 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 III, you will be required to lead operational meetings, make business decisions as a department SME and act as a backup for the team’s manager. 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 Power BI; SAS experience is a plus
• 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
• Recommends and implements improvements to existing processes and assists with adoption of new software tools
• Acts as a technical business liaison to explain complicated technical information to non-technical audiences (both internal and external) effectively
• Promptly responds to service failures, resolves issues, and escalates concerns as appropriate
• Promotes continuous improvement by ensuring adherence to quality principles
• Seeks out and actively participates in business initiatives that contribute to service excellence
• Keeps current with industries best practices and seeks additional training/seminars to improve technical skills

Supervisory Responsibilities

This job has no direct supervisory responsibilities but will be required to perform as a team leader and act as a backup for the team’s manager.

Education and/or Experience

For consideration candidates will need:

• Bachelor’s degree or higher in engineering, IT, economics, math, statistics, science or other related fields in quantitative or analytical discipline (or equivalent combination of education and experience)
• Eight (8+) years relevant hands-on experience in an analytics, business intelligence or comparable data engineering role, including data warehousing, and business intelligence tools (Specifically Power BI), techniques and technology
• Experience with pharmacy claims data, insurance data, managed health care industry or PBM operations preferred
• Experience as a project manager, team leader or supervisor

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 Power BI (DAX, Power Query, Power Automate, Fabric, etc.)
• 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

Certificates, Licenses, Registrations

• Power BI Data Analyst Associate a plus
• PL/SQL 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 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
• Ability to effectively delegate tasks to junior team members
• Ability to mentor and train team members

Travel

This position may require domestic travel up to 15%; attendance may be required at various local conferences and meetings.

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

Equal Opportunity Employer, Male/Female/Disabilities/Veterans

OSHA/ADA:

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.

Disclaimer:

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.

Are you a returning applicant?