BI Analyst Level 2

Back to Careers

Job Title: BI Analyst Level 2

Location: Remote/Hybrid

FLSA Status: Exempt

Job Summary

The BI Analyst Level 2 is responsible for creating accurate and timely reporting and data analysis for the entirety of our organization. The responsibilities include reporting (SSRS/Power BI), data loading and export (SSIS), data warehousing (SSAS), and ad-hoc analyses using T-SQL on data involving all aspects of the pharmacy industry. The BI Analyst Level 2 will design and implement new data warehouses, data warehouse related ETL processes, and plan application migration to new datasets with minimal supervision or technical oversight. The BI Analyst Level 2 will have an expert understanding of the data in the pharmacy industry and extensive experience in maintaining robust ETL processes in a production environment.

Level 2 IT positions are expected to participate in the mentoring and training of junior staff. They are also expected to execute good project management for long running projects and initiatives with little managerial oversight.  Level 2 positions will be expected to coordinate multi-member and cross domain projects on a regular basis.

Essential Job Functions

• Create and maintain SSRS/ Power BI reports
• Distribute reports for various business segments
• Design, Implement, and maintain advanced ETL processes
• Ad-hoc analyses via SQL queries as needed
• Tune and troubleshoot performance including TSQL, Indexes, and process
• Assists software developers in designing queries
• Design, implement, and maintain data warehouses
• Design, implement, and maintain self-service BI services
• Train end users in consuming self-service BI services
• Compile and write documentation of process development following established methods so others can understand the process.
• Write or contribute to instructions and manuals following documentation standards to guide end
• Report status, issues, and timelines to management staff and project
• Follow established guidelines for source code revision control, coding standards, and release
• Work independently
• Manage their projects

Additional Responsibilities

• Perform other duties and projects as required by management.

Minimum Qualifications for Consideration

• 6+ years experience in data analytics, data science, or SQL programming

Knowledge, Skills and Abilities

• SSIS package advanced ETL design/build/deployment/support
• BI Xpress task factory components
• SSRS/ Power BI reporting (drill through, linked reports, sub reports)
• Advanced TSQL (stored procedure build/support, functions, pivot, views, median’s, cross apply)
• Data mart design (fact/dimension, tabular, cubes)
• Tabular model prototyping, Power Pivot
• Data visualization Power View, Power Map
• Advanced understanding of Medi-Span and NDC/GPI and pricing methodologies
• Therapeutic classes, drug status, package size calculations
• Advanced understanding of NCPDP D.0 and 835 5010
• File structure, segments and relationships
• Advanced understanding of Reimbursement methodologies
• Cost based methodologies as it relates to supply and demand in the market.
• PD response process
• Advanced understanding of reimbursement methodologies
• LTC, compounding, CO/B, DME and Medicare cross over
• DIR fees PLB adjustments
• Advanced understanding of acquisition cost methodologies
• Inventory statuses NDC vs LGPI vs PGPI, generic programs
• AWP purchase discounts

Physical Requirements/Working Conditions

This work is sedentary and requires the following physical activities:

• Sitting for long periods of time; occasional bending, squatting, kneeling, stooping; good finger dexterity and feeling; frequent repetitive motions; talking, hearing, and visual acuity.
• Frequent lifting (up to 20 pounds of paper supplies or minor office equipment).
• Driving to client locations and other sites as needed.

Direct Reports

• None