Membership Data Analyst

Membership Data Analyst

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 79,000 pilots at 42 U.S. and Canadian airlines) seeks an experienced Membership Data Analyst for our Tysons (McLean), Virginia office. The Membership Data Analyst serves as the primary data analyst for Membership and associated reporting - using the Membership database and financial systems - and as the point of contact for internal/external system data users. They directly support the administration of membership, dues, and other processes within the Association, including special projects and IT system configurations/enhancements. They collect, clean, and transform data from various sources to develop clear and engaging visualizations that convey their findings and recommendations to users across the Association. They have the ability to apply statistical tools and techniques to analyze data, identifying trends and relationships that can be used to isolate problems, develop solutions, and implement data-driven strategies to improve business processes and project outcomes. They also ensure the quality and accuracy of the membership data by identifying and correcting errors in the data and participating in the design, maintenance, and troubleshooting of related data systems and databases.

Local travel: 2 - 5%.

ALPA is an equal opportunity employer that is committed to diversity and inclusion in a safe workplace. We prohibit discrimination, harassment and harmful behavior of any kind based on race, color, sex, religion, sexual orientation, national origin, gender identity, caste, disability, genetic information, pregnancy, or other protected characteristics as outlined in federal or provincial laws. We highly value everyone and all are encouraged to apply, including minorities, veterans, and people with disabilities.

This position is covered by a collective bargaining agreement.

ALPA is a member-driven, staff supported, union with two internal professional unions.

Qualifications:

Bachelor's degree in relevant area, e.g., Business, Data Analysis, Statistics, Information Systems, Accounting & Finance, or related field, from an accredited college or university required; or, the equivalent combination of education and practical experience.
• Minimum three (3) years of experience with data analysis, business intelligence, and/or financial systems required, five (5) or more preferred. At management discretion, ALPA experience with proven expertise may be substituted for some of the above.
• Strong database and business analytics skills essential.
• Experience with relational database environments.
• Knowledge of ETL processes, data pipelines, and data warehousing techniques a plus.
• Excellent business math skills essential, including billing/reconciliations, reporting, and data analysis.
• Proficiency with statistical tools and techniques to analyze data and identify trends a plus.
• Self-directed learning and research skills essential.
• Detail-oriented and analytical problem solver, excellent communication skills.
• Association and/or membership programs experience strongly preferred.
• Ability to develop into a self-starter able to work independently on multiple projects, with varying degrees of complexity, and meet deadlines.
• Software: CRM, MS Excel (Data and Pivot Tables), Microsoft Suite, and BI tools (such as Tableau).

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, nationally, and internationally). May also include 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, could be responsible to move, raise, reach, and/or retrieve luggage weighing as much as 50 lbs. (Assistance may not always be available.)

ALPA offers competitive salaries with terrific benefits, including:

• 401k Plan with Non-Elective Employer Contribution of 11% plus 2% into a Market-Based Cash Balance Plan after 180 days of employment. No employee contribution required! The 401k plan includes a Roth option and 4-year vesting schedule.
• Generous health care benefits on day one - PPO, Kaiser (where available), and a High Deductible Health Plan which includes coverage for medical, dental, and vision benefits for employee, spouse, and/or dependent children;
• 15 days paid vacation and 13 holidays per year plus 2 volunteer days per year;
• Generous sick and bereavement leave;
• Competitive parental leave;
• Company-paid premiums for disability and life insurance;
• Flexible Spending and Health Savings accounts;
• Retiree health plan;
• Education Assistance Program; and,
• Optional benefits including pet insurance, excess life insurance, legal plan, and qualified transportation fringe benefits, where available.
• Partial remote work opportunities.

PROJECTED ANNUAL SALARY RANGE: $ 62,858.00 - $ 89,796.00

Relocation not provided.

Sponsorship not available for this position.

PM19