FREE Nonprofit Jobs Postings and News.


Job Details

Nonprofit Job in Herndon Virginia


  Enterprise Data Architect Job viewed 66 times.
  Job Description

The Air Line Pilots Association, International (ALPA), the largest airline pilot union in the world and the largest non-governmental aviation safety organization in the world (representing over 58,000 pilots at 33 U.S. and Canadian airlines) seeks an experienced Data Architect for our Herndon, Virginia, office.  The Data Architect will work with business knowledge experts and Association leadership to define the vision of ALPA’s data store, i.e. to translate data and reporting requirements from a logical design into the physical database(s) repository(ies).  S/he will work with system designers and developers to address issues of data migration (validation, clean-up, transformation, and mapping) and will ensure data dictionaries are maintained and available to support data understanding and reporting requirements.  S/he should be an expert at both defining data structures and data integration and archiving practices, whether for business intelligence or operational uses.  

Technical skills required of him/her, include: 

•          Data Analysis

•          Database Design

•          Data Modelling

•          Data Migration Tools

•          Data Warehousing

•          Data Integration 

The successful candidate is an excellent communicator.  S/he possesses solid presentation skills and the abilities to listen, elicit and interpret information, and formulate requirements to meet and/or surpass user expectations. 

Travel:  5 - 10 %.  

Minorities, veterans, and people with disabilities are encouraged to apply. 

Minimum Requirements: 

  • Bachelor's degree in relevant area, e.g., Computer Engineering, Computer Science, IT, or related field, from an accredited college or university required; master’s degree or completion of post-graduate courses in related field preferred; or, the equivalent combination of education and practical experience. 

  • Five (5) years of related experience required, six (6) or more years strongly preferred.  Additional applicable experience may be substituted for academic requirements.

  • Data modeling, data warehousing, data extraction and transformation (ETL), and Business Intelligence (BI) related projects and SQL Server experience required.

  • Required Tools:

    • BI reporting and data visualization tools, Tableau preferred

    • Data modeling tools, e.g., erwin data modeler

    • Extract, Transform, and Load (ETL) Tools, e.g., SSIS/SSRS

  • Expertise with enterprise security and familiarity with authentication environments, particularly ADFS and IdentityServer, strongly preferred.

  • Experience working with systems analysis, design, and requirements gathering strongly preferred.

  • Advanced knowledge/skills in SQL required; MongoDB strongly preferred. 

  • Excellent interpersonal and communication skills, oral and written, for effective interaction with all levels of contacts, internal and external.

  • Must be a self-starter with professional maturity and sound judgment, capable of independent decision-making.

  • Must possess exceptional time management skills; be able to work in a fast-paced, multi-tasking environment; and, transition easily between projects.

  • Software:  Microsoft Office and Project strongly preferred. 


Physical Demands: 

Note: The physical demands described herein are characteristic of those that must be met to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals to perform the essential physical activities of this position described below. 

Constantly operates a computer/smartphone/tablet.  Regularly required to maintain a stationary position, move about the office, determine what others have said or written, and converse with others and exchange accurate information.

Regularly required to sit, stand, bend, reach, and move about the office and travel locally and nationally; international travel may be required infrequently.  Also includes occasional bending, stooping, squatting, and/or pushing and pulling or moving, e.g., to pack, unpack, and/or move cases. 

Occasionally required to move, raise, reach, and/or retrieve binders, books, boxes, and files up to ten (10) pounds (lbs.).  While on travel, may be responsible to move, raise, reach, and/or retrieve binders, boxes, cases, and/or files weighing as much as 50 lbs.  (Assistance may not always be available.)  

Please apply online at 

ALPA offers competitive salaries with excellent benefits, including:

  • 26 days paid vacation and holidays per year;

  • Generous sick and bereavement leave;

  • Generous health care benefits – PPO, two HMO’s (where available) and a High Deductible Health Plan which includes coverage for medical, dental, and vision benefits for employee, spouse, and/or dependent children;

  • Company-paid premiums for disability and life insurance;

  • $2 for $1 matching 401(k) retirement savings plan; Roth 401k;

  • Flexible Spending and Health Savings accounts; and

  • Retiree health plan.


    The Air Line Pilots Association is an Equal Opportunity Employer.

    Relocation Not Provided


Sponsorship not available for this position. 




  Metro Area Washington DC
  Job Location City Herndon
  Job Location State Virginia
  Job Location Zip 20170
  Job Location Country United States
  Job Category
  Prefered Experience 5 year(s)
  Job Type Full time
  Language 1 English ( Speak Read Write )  
  Job Posting Date Dec. 7, 2017

Organization Details

  Organization Name The Air Line Pilots Association, Int'l
  Organizational Focus Network of Nonprofit Organizations
  Contact Person Hoa Tran
  Contact Phone none posted
  Contact Fax none posted
  Contact Email
  Web Address

Email Newsletter Sign Up

Visit our
Nonprofit Network Blog

Free Nonprofit Job Posting  |  Find a Job  |  Find a Consultant  |  Blogs  |  Find a Resume  |  Find an Event  |  Find People  |  Find a Nonprofit