Data Insights Architect

PAN Foundation; Washington (District of Columbia); Remote; USD 100,000 - 173,000; Full time

Job summary

The PAN Foundation is seeking a Data Insights Architect to drive data solutions that inform decision-making and support patient advocacy efforts. This mid-senior level role is pivotal in extending the organization's capabilities in data analytics and governance, requiring technical expertise in tools like Snowflake and Tableau, coupled with a strong background in data architecture.

Benefits

Medical, dental, and vision insurance

Generous paid time off (including health screening days)

401k with employer match

Tuition and professional development reimbursement

Work-life balance with set core hours

Qualifications

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

Responsibilities

• Design, develop, and maintain scalable data architecture and reporting solutions.
• Conduct data quality assessments and troubleshoot discrepancies.
• Lead initiatives to improve data literacy and BI adoption.

Skills

Snowflake

Tableau

SQL

Data Governance

Agile Methodologies

Data Architecture

Education

Bachelor’s Degree in Data Science or related field

Master’s Degree preferred

Job description

Join to apply for the Data Insights Architect role at PAN Foundation

3 days ago Be among the first 25 applicants

Join to apply for the Data Insights Architect role at PAN Foundation

Description

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology and Engineering

• Industries

  Non-profit Organizations

Referrals increase your chances of interviewing at PAN Foundation by 2x

Get notified about new Data Architect jobs in Washington, DC.

Washington, DC $100,000.00-$172,500.00 4 days ago

Arlington, VA $100,000.00-$118,000.00 2 months ago

Maryland, United States $90,000.00-$130,000.00 7 months ago

Alexandria, VA $200,000.00-$220,000.00 15 hours ago

Herndon, VA $200,000.00-$210,000.00 2 weeks ago

Reston, VA $99,216.00-$206,369.00 2 months ago

District of Columbia, United States $130,000.00-$216,000.00 17 hours ago

Data Management Analyst, Junior (Future Need)

Arlington, VA $30,000.00-$40,000.00 1 month ago

Senior Systems Engineer, Data Center | Technology | Remote

McLean, VA $57,000.00-$145,000.00 3 days ago

Senior Staff Engineer - Finance Data Specialist (Remote)

Chevy Chase, MD $115,000.00-$260,000.00 6 days ago

Senior Staff Engineer - Finance Data Specialist (Remote)

Washington, DC $115,000.00-$260,000.00 6 days ago

Senior Staff Engineer - Finance Data Specialist (Remote)

Springfield, VA $115,000.00-$260,000.00 6 days ago

Gaithersburg, MD $116,227.90-$174,341.84 1 week ago

Resident Solutions Architect -Public Sector

Washington, DC $120,000.00-$170,000.00 3 weeks ago

Washington, DC $95,000.00-$145,000.00 1 week ago

Lanham, MD $85,000.00-$100,000.00 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.