Principal, Business Intelligence Architect

MedImpact Healthcare Systems Inc.; San Diego (CA); On-site; USD 115,000 - 206,000; Full time

Benefits offered by this job

Medical / Dental / Vision / Wellness

Paid Time Off / Holidays

Incentive Compensation

401K with Company match

Life and Disability Insurance

Tuition Reimbursement

Employee Referral Bonus

Job summary

MedImpact Healthcare Systems, Inc. is seeking a Principal, Business Intelligence Architect to drive BI solutions, data pipelines, and analytics aligned with our data-driven value proposition.

You will partner with executives, engineers, and business customers to translate complex needs into scalable data and reporting outputs. The role requires strong expertise in data architecture, ETL, SQL, and scripting within HIPAA-regulated healthcare environments.

Qualifications

• BA/BS Degree; 8+ years related experience with data/BI leadership.
• Knowledge of data architecture, ETL, and data management.
• Experience with HIPAA-compliant health data handling is a plus.

Responsibilities

• Lead design, development, testing, and support of BI solutions including reports, dashboards, and data models.
• Collaborate with stakeholders to translate business needs into data and reporting solutions.
• Troubleshoot complex data and performance issues; ensure timely, effective outcomes.
• Provide technical guidance and mentorship to team members; participate in design reviews.

Skills

Business Intelligence

Data Modeling

Data Warehousing

SQL

Python

Scripting

Education

BA/BS Degree

Tools

MongoDB

Cassandra

Oracle

PostgreSQL

Job description

Exemption Status & Pay Range

Exemption Status: United States of America (Exempt) $114,622 - $160,472 - $206,321 “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.

About MedImpact

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!

Job Description Summary

As a key member of the Medicaid Fee-For-Service team, the Principal, Business Intelligence Architect serves as a data and reporting subject matter expert, driving the design, implementation, and enhancement of business intelligence solutions that support MedImpact’s data-driven value proposition. This role partners with cross-functional stakeholders, including executives, engineers, project managers, QA testers, and business customers, to translate complex business needs into effective data and reporting solutions, manage multiple concurrent priorities, and deliver high-quality results with a high degree of autonomy.

Essential Duties and Responsibilities

• Lead the design, development, testing, implementation, and support of business intelligence solutions, including reports, dashboards, data models, and other reporting deliverables.
• Partner with business analysts, stakeholders, and customers to gather, clarify, and translate business requirements into scalable data and reporting solutions.
• Troubleshoot and resolve complex data, reporting, and performance issues, ensuring timely and effective outcomes.
• Develop, maintain, and document technical requirements, data solutions, reporting specifications, and design artifacts.
• Apply reporting, data architecture, ETL, and data warehousing best practices to ensure accuracy, efficiency, scalability, and reliability.
• Design and implement data pipelines and reporting frameworks that support evolving business intelligence and analytics needs.
• Establish and promote data quality standards, controls, and monitoring processes to proactively identify and prevent data issues.
• Ensure solutions comply with internal policies, data governance standards, security requirements, and HIPAA regulations.
• Participate in solution design reviews, code reviews, and continuous improvement initiatives to enhance reporting and data capabilities.
• Research, evaluate, and recommend emerging technologies, tools, and industry best practices to improve reporting effectiveness and streamline processes.
• Provide technical leadership, guidance, and mentoring to team members, while collaborating effectively with BI, IT, and cross-functional teams.
• Influence the design and delivery of cost-effective, business-focused reporting solutions through matrixed project leadership and stakeholder engagement.
• Partner with internal and external stakeholders to identify and translate complex, ambiguous, or evolving business needs into actionable data and reporting solutions.
• Serve as a data and reporting subject matter expert, communicating technical concepts and solution designs to both technical and non-technical audiences and representing MedImpact with clients and business partners as needed.

Other duties may be assigned.

Supervisory Responsibilities

• Manages assigned staff in the segment area.
• Responsible for the overall direction, coordination, and evaluation of the unit.
• Carries out supervisory responsibilities in accordance with the organization's policies and applicable laws.
• Responsibilities include interviewing, hiring, and training employees; planning, assigning, and directing work; appraising performance; rewarding and disciplining employees; addressing complaints and resolving problems.
• Supports and enforces all company policies and procedures in a fair and consistent manner, taking corrective action whenever necessary.

Client Responsibilities

This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients.

Qualifications

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

Education and/or Experience

BA/BS Degree; 8+ years related experience and 8+ years of SME in respective area(s); (or equivalent combination of education and experience) with at least 4+ years leading individual contributors and leaders of leaders; which may be substituted with an appropriate mix of leadership experience and 5 years of MedImpact experience plus an appropriate external leadership training program and internal mentorship with a seasoned leader (VP+ level) that must completed within 12 months in new position.

Computer Skills

Strong working knowledge of Business Intelligence, Reporting and Data Management Technologies. Excellent working knowledge of SQL High level of proficiency with data query tools Excellent working knowledge of relational databases Excellent working knowledge of a variety of currently used programming languages such as SQL, Scripting and Shell Scripting, etc. Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications UNIX and/or Windows environments Strong scripting and build automation Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications Microsoft Office Suite

Other Skills and Abilities

Knowledge of data architecture, ETL tools, orchestration frameworks. Experience in structured and unstructured data, SQL databases (e.g., Oracle, PostgreSQL), NoSQL (e.g., MongoDB, Cassandra) Experience with streaming data architectures (e.g., event-driven systems) preferred. Proficiency in Python, Java, Scripting Tools or other common programming languages. Analytical-thinking, critical-reasoning, and problem-solving skills as applied to complex business-technology subject areas. Ability to communicate complex ideas to non-technical stakeholders. Written, verbal and presentation skills to educate, inform and facilitate decision-making at management level. Planning and organization skills to conceive and execute data and reporting projects and work-efforts independently and leading others. Proven capability in meeting challenges with resourcefulness, generating suggestions for improvement, developing innovative approaches and ideas. Ability to initiate and influence change in a matrix environment with limited formal authority. Expertise in protecting health data requiring HIPAA compliance.

Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables. Mathematical Skills Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals.

Competencies

Business Acumen Directing Others Organizational Agility Conflict Management Drive for Results Political Savvy Customer Focus Innovation Management Strategic Agility Decision Quality Managerial Courage

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit and talk or hear. The employee is regularly required to stand; walk; use hands to finger, handle, or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Ability to maintain clear near visual acuity at approximately 20 inches or less (i.e., “close vision”) to accurately read fine print, view computer screens, and handle small objects. Requires adequate color vision and depth perception to support safety and precision in detail-oriented tasks.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. This position may regularly be exposed to or encounter moving mechanical parts, high, precarious places, fumes, or airborne particles, toxic or caustic chemicals, outdoor weather conditions, risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers, light traffic).

Work Location

This position works on-site at the San Diego Headquarters or other company location (or from a remote location with management approval based on business requirements). Must provide adequate support to internal clients; be available for regular interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as be available to facilitate effective decisions through collaboration with stakeholders.

Working Hours

This is an exempt level position requiring the incumbent to work the hours required to fully accomplish job responsibilities and meet deadlines for work deliverables. The individual must have the flexibility to work beyond traditional hours and be able to work nights, weekends or on holidays as required. Work hours may be changed from time to time to meet the needs of the business. Typical core business hours are Monday through Friday from 8:00am to 5:00pm.

Travel

This position requires no travel; however, attendance may be required at various local conferences and meetings.

The Perks

• Medical / Dental / Vision / Wellness Programs
• Paid Time Off / Company Paid Holidays
• Incentive Compensation
• 401K with Company match
• Life and Disability Insurance
• Tuition Reimbursement
• Employee Referral Bonus

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 Statement

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

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. MedImpact was founded more than three decades ago by a pharmacist and independent drug store owner who saw firsthand how families struggled with the high cost of prescriptions, and how it impacted their lives, financial security, and health. So, he started MedImpact to make prescription benefits understandable and accessible. While we have grown to be one of the leading PBMs in America, we remain as committed to these principles today as we did when it all began.