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.
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.
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.
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 https://jobs-alpa.icims.com/jobs/1273/data-architect/job
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.