Data Insights Architect

Patient Access Network Foundation; Washington (District of Columbia); Remote; USD 80,000 - 92,000; Full time

Job summary

The Patient Access Network Foundation seeks a Data Insights Architect to drive data strategy through analytical solutions. In this full-time role, you will utilize Snowflake and Tableau to enhance decision-making and build a data-driven culture, supporting the foundation's mission to help patients access affordable healthcare.

Benefits

Medical, dental, and vision insurance.

Generous paid time off.

401k with employer match up to 4%.

Flexible Spending Accounts.

Health Savings Account.

Tuition and professional development reimbursement.

New employee referral bonuses up to $1,000.

Qualifications

• 5+ years of experience in business intelligence, data engineering, or analytics roles.
• Advanced expertise in Snowflake and Tableau (including dashboard development).
• Strong command of SQL, including complex queries.

Responsibilities

• Design and maintain scalable data architecture using Snowflake and Tableau.
• Produce high-quality data outputs for executive decision-making.
• Conduct data quality assessments and troubleshoot discrepancies.

Skills

Snowflake

Tableau

Salesforce

SQL

Data Governance

Agile Methodologies

Visualization

Communication

Education

Bachelor’s Degree in Data Science, Computer Science, Information Systems or related field

Master’s Degree preferred

Job description

Job Details

Job Location: Remote - Washington, DC

Position Type: Full Time

Salary Range: $80088.00 - $91700.00 Salary

Job Category: Information Technology

Description

A career at the PAN Foundation is an opportunity for you to make a direct impact on the lives of thousands of patients and their families every year. Together, we’re an unstoppable team of dedicated patient champions who work tirelessly toward our vision of a nation where no one goes without treatment due to cost. Join our team and become part of an organization providing life-changing support today!

Position overview

The Data Insights Architect is a key member of the PAN Foundation’s Data Analytics team reporting to the Senior Director of Business Intelligence & Data Analytics. The incumbent will be responsible for architecting, implementing, and scaling data solutions that power the organization's reporting, analytics, and decision-making capabilities to meet the overarching business goals.

The Data Insights Architect brings deep technical expertise in Snowflake, Tableau, Salesforce and data architecture, along with a strong ability to deliver automated, standardized, and high-quality data outputs in an agile working environment.

Working closely with business units and IT leadership, the Data Insights Architect will play a critical role in building a data-driven culture and transforming raw data into clear, actionable insights that align with strategic priorities.

Core Responsibilities

• Design, develop, and maintain scalable data architecture and reporting solutions using Snowflake and Tableau.
• Produce high-quality, validated, and well-documented data outputs that support executive and operational decision-making.
• Conduct regular data quality assessments, troubleshoot discrepancies, and guide corrective actions in collaboration with data owners

Technical/Functional Duties

• Automate recurring data processes and pipelines to increase efficiency, reduce manual reporting, and improve data accuracy.
• Implement data governance policies and data validation to improve data accuracy and consistency and reliability.
• Maintain documentation of data logic, architecture designs, and reporting workflows for scalability and knowledge sharing.

Strategic/Planning Responsibilities

• Drive reporting standardization efforts across departments by implementing enterprise-wide data definitions and metric governance.
• Partner with the Senior Director and other IT teams to evolve the Enterprise Data Warehouse and ensure alignment with long-term data strategy.
• Stay current on industry trends and emerging tools in data architecture and visualization to inform continuous improvement.

Strategic/Planning Responsibilities

• Collaborate with business stakeholders to gather and analyze requirements, data flows, data structures and iterate on solutions in an agile development cycle.

Supervisory/Leadership Duties

• Lead initiatives to improve data literacy, self-service reporting, and BI adoption across the organization.
• Provide technical leadership and mentoring to analysts and developers on best practices in data modeling, visualization, and automation.

Qualifications

We are currently accepting applications from AL, AZ, DC, FL, GA, IN, LA, MD, MI, MO, NC, SC, TN, TX, VA, and WI.

Education

• Bachelor’s Degree Required, in Data Science, Computer Science, Information Systems, or a related field preferred or equivalent experience required. Master’s Degree preferred.

Work experience

• 5+ years of experience in business intelligence, data engineering, or analytics roles, preferably within IT at Non-Profit or Healthcare organizations.

Skills

• Advanced expertise in Snowflake and Tableau (including dashboard development, data blending, and performance optimization).
• Strong product knowledge of Salesforce is required
• Strong command of SQL, including complex queries, CTEs, and performance tuning.
• Proven experience in designing and implementing automated reporting and ETL/ELT workflows.
• Familiarity with agile methodologies, sprint planning, and iterative delivery.
• Understanding of enterprise data warehousing concepts, data governance, and metadata management.
• Excellent communication skills with the ability to explain complex technical concepts to non-technical stakeholders.
• Experience in healthcare, nonprofit, or related domains is a plus.
• Knowledge of scripting or statistical tools such as Python, R, or SAS is a plus.

Travel

• None at this time

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

PAN recognizes that caring for our team is the most vital component to our long-term success. That’s why we offer a competitive benefits package for all eligible employees—including medical, dental, and vision insurance, a 401k with employer match, and generous paid time off — and are dedicated to fostering a diverse team and equitable work environment for all. Join our team and become part of an organization providing life-changing support today!

Benefits

• Medical, dental, and vision insurance.
• Generous paid time off (PTO): including annual preventative health screening, annual mental health days, and 12 observed annual paid holidays.
• 401k with employer match up to 4%.
• Flexible Spending Accounts (medical & dependent care).
• Health Savings Account (HSA) with High Deductible Medical Plan.
• Voluntary Benefits (Supplemental Life Insurance, Critical Illness, Accident Insurance, Accidental Death and Dismemberment (AD&D) & Pet Insurance and discounts).
• Employer Paid Benefits (Basic Life Insurance, Short-Term and Long-Term Disability, AD&D).
• Employee Assistance Program (EAP).

Additional perks

• 100% remote work.
• Work-life balance with set core organizational hours from 9:00 am to 5:30 pm EST.
• Tuition and professional development reimbursement.
• New employee referral bonuses up to $1,000.

PAN’s Core Organizational Values are Dignity, Excellence, Integrity, and Intention.

About the PAN Foundation

As an independent, national 501(c)(3) organization, the PAN Foundation’s mission is to accelerate access to affordable, equitable healthcare through financial assistance, advocacy, and education.

Through our charitable assistance programs, advocacy efforts, and education initiatives, we remove barriers to treatment, champion policies that expand access to care, and help improve health outcomes for thousands of people each year—across a broad range of health conditions.

Compliance Commitment

PAN is dedicated to conducting its business ethically and in full compliance with all applicable federal and state laws and regulations, its Advisory Opinion from the Office of Inspector General (OIG), the PAN Code of Conduct (“Code”), and internal policies and procedures (collectively, “Compliance”).

All employees are expected to:

• Follow all Compliance standards in their daily work.
• Read, understand, and adhere to the Code of Conduct and related policies.
• Complete required Compliance and ethics training.
• Promptly report any Compliance concerns to a supervisor, management, Human Resources, the Compliance Office, or the Integrity Line.

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.