Medical Informatics Analyst, Consultant - Pharmacy Blue Shield of California - 3.6 Oakland, CA Job Details Full-time $123,090 - $184,800 a year 4 hours ago Benefits Work from home Qualifications Statistics Operational analysis Pharmacy informatics Preparation of internal financial performance reports Financial data reconciliation Predictive modeling analysis Automation SAS R Gap analysis SAS language High school diploma or GED SQL Key Performance Indicators Bachelor's degree Cost analysis Inventory reconciliation Financial strategy recommendations Data-driven problem-solving Cost reduction analysis System development Data accuracy checks Predictive analytics projects Senior level Query management 4 years Cross-functional collaboration Clinical data analysis Healthcare performance metrics analysis Financial data analysis tools Full Job Description Your Role The Pharmacy Financial Analytics team. The Medical Informatics Consultant will report to the Sr. Principal Medical Informatics Analyst of Pharmacy Financial Analytics. In this role, you will play a key part in advancing our organization's analytical capabilities by supporting network and rebate reporting, reconciliation processes, model development, and automation initiatives. Your work will directly empower leadership with the tools, insights, and data needed to make informed strategic decisions, drive operational excellence, and support the continued growth and success of the organization through innovative, data-driven solutions. Your Work In this role, you will: Develop, optimize, and maintain complex SQL queries to extract, transform, and analyze pharmacy, claims, financial, and operational data. Use SAS and other analytical tools to manipulate large healthcare datasets, support statistical analysis, and contribute to predictive model development. Support the design, maintenance, and enhancement of underwriting tools used to evaluate pharmacy cost, utilization, revenue, and performance trends. Design, automate, and maintain financial reporting to monitor pharmacy revenue streams, dispensing margins, rebate activity, billing accuracy, and key performance indicators. Perform financial reconciliations across pharmacy claims, rebate, inventory, operational, and general ledger data to ensure accuracy, identify variances, and support issue resolution. Analyze financial and operational trends to identify cost-saving opportunities, revenue impacts, process gaps, and business performance drivers. Translate complex pharmacy and financial data into clear insights, recommendations, and presentations for business leaders and cross-functional partners. Partner with Pharmacy, Finance, Underwriting, Actuarial, and operational teams to support strategic initiatives, improve reporting capabilities, and drive data-informed decision-making. Your Knowledge and Experience Requires a bachelor's degree or High School Diploma/GED and 4 years of additional relevant experience in lieu of a degree Requires 7 years of relevant experience delivering analytics (cost, quality, utilization, and/or outcomes) with enterprise impact Requires 5 years of prior pharmacy experience Requires SAS Certified Advanced Programmer credential (or equivalent) or advanced analytics certification (e.g., R, Python) Hybrid This role requires employees to be in-office based on our hybrid workplace model, balancing purposeful in-person collaboration with flexibility. For most teams, this means coming into the office two days each week. Employees living more than 50 miles from an office location will work with their manager to determine in-office time based on business need.

ABOUT THE TEAM

About Blue Shield of California As of January 2025, Blue Shield of California became a subsidiary of Ascendiun. Ascendiun is a nonprofit corporate entity that is the parent to a family of organizations including Blue Shield of California and its subsidiary, Blue Shield of California Promise Health Plan; Altais, a clinical services company; and Stellarus, a company designed to scale healthcare solutions. Together, these organizations are referred to as the Ascendiun Family of Companies. At Blue Shield of California, our mission is to create a healthcare system worthy of our family and friends and sustainably affordable. We are transforming health care in a way that genuinely serves our nonprofit mission by lowering costs, improving quality, and enhancing the member and physician experience. To achieve our mission, we foster an environment where all employees can thrive and contribute fully to address the needs of the various communities we serve. We are committed to creating and maintaining a supportive workplace that upholds our values and advances our goals. Blue Shield is a U.S. News Best Company to work for, a Deloitte U.S. Best Managed Company and a Top 100 Inspiring Workplace. We were recognized by Fair360 as a Top Regional Company, and one of the 50 most community-minded companies in the United States by Points of Light. Here at Blue Shield, we strive to make a positive change across our industry and communities - join us!

Our Values:

Honest. We hold ourselves to the highest ethical and integrity standards. We build trust by doing what we say we're going to do and by acknowledging and correcting where we fall short. Human. We strive to listen and communicate effectively, showing empathy by understanding others' perspectives. Courageous. We stand up for what we believe in and are committed to the hard work necessary to achieve our ambitious goals. Our Workplace Model We believe in fostering a workplace environment that balances purposeful in-person collaboration with flexibility - providing clear expectations while respecting the diverse needs of our workforce. Our workplace model is designed around intentional in-person interaction, collaboration, connection, creativity and flexibility: For most teams, this means coming into the office two days per week. Employees living more than 50 miles from an office location, out of state employees, and employees in certain member-facing roles should work with their manager to determine in-office time based on business need. For employees with medical conditions that may impact their ability to work in-office, we are committed to engaging in an interactive process and providing reasonable accommodations to ensure their work environment is conducive to their success and well-being. The Company reserves the right to require more presence in the office based on business needs, and requirements are subject to change with periodic reviews.

Physical Requirements:

Office Environment - roles involving part to full time schedule in Office Environment. Based in our physical offices and work from home office/deskwork - Activity level: Sedentary, frequency most of work day.

Equal Employment Opportunity:

External hires must pass a background check/drug screen. Qualified applicants with arrest records and/or conviction records will be considered for employment in a manner consistent with Federal, State and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or disability status and any other classification protected by Federal, State and local laws.