Data Analyst II

JOB SUMMARY: 

The Data Analyst II ensures accurate data collection, processing, modeling, and analysis. This role works on the Business Intelligence team and collaborates cross-functionally to enable high-quality, data-driven decision-making and translate insights into strategic opportunities. In addition to supporting data accuracy and consistency across reporting efforts in a Salesforce environment, this individual also monitors and analyzes web traffic using tools such as Google Analytics and BigQuery to uncover user behavioral trends, optimize digital engagement, and inform marketing strategy. They will also assist with developing efficient systems for data analysis, reporting, and governance across the Association. Responsibilities include designing, managing, and presenting reports and dashboards in Salesforce and Tableau to support transparency, performance tracking, and strategic planning.

ESSENTIAL FUNCTIONS: 

Data Analysis & Persona Modeling (30%)

Conduct analysis and deliver results that help leadership make data-driven decisions

 Define and track KPIs for member acquisition, conversion, engagement, and product usage 

Provide custom audience list pulls for various departments

Monitor, analyze, and report on website traffic and user behavior using Google Analytics and other web analytics tools

Segment audiences and analyze user journeys to support targeted outreach and personalization efforts

Build audience models tailored to stakeholder needs

Data Collection & Processing (20%)

Ensure proper tagging, tracking, and data integrity across digital platforms, including troubleshooting and validating analytics implementations

Optimize data intake, validation, and mining processes; ensure effective modeling, visualization, and communication of outputs

Develop automation procedures to streamline data collection and improve efficiency

Create custom web behavior datasets to address data gaps in Salesforce and meet evolving needs of different teams

Cross-Functional Collaboration & Strategic Support (20%)

Respond to data and analytics requests from departments across the Organization

Collaborate with cross-functional teams to transform raw data into actionable business insights

Assist other teams within the Organization in formulating recommendations, policies, or plans to address the Organization’s concerns

Reporting & Communication (20%)

Deliver findings and recommendations that inform strategic decisions for internal and external stakeholders

Lead the development of reports and insights analyzing key operations and business functions

Design and maintain dashboards in Salesforce and Tableau to support program monitoring and performance tracking

Operational Metrics & Data Culture (10%)

Contribute to the development and revision of operational metrics and departmental KPIs

Promote a culture of data collaboration and continuous improvement across the Organization

**Although this job description aims to capture the majority of the position duties, other duties may be assigned based on business and departmental needs.

REQUIRED JOB QUALIFICATIONS: 

Bachelor's degree in a related discipline.

Five to seven years of professional experience in analytics, conducting studies and analyses that yield meaningful insights. 

Strong quantitative, analytical, communication, and presentation skills; ability to develop metrics and procedures for collecting and processing diverse and disparate data. 

Knowledge of available data sources and various economic and statistical techniques; the ability to efficiently identify and analyze relevant information.

Proficient in writing code in MS SQL

Experience in programming languages such as BigQuery, Python, R, SPSS, SAS, or similar. 

Working knowledge and understanding of the structure of Salesforce,  Google Analytics, and web traffic data. 

Skilled in using data visualization software such as Tableau and Power BI

Experience translating complex research findings into accessible insights for non-technical audiences. 

Superior writing and presentation skills to communicate key findings clearly and persuasively to a diverse audience.

The ability to work effectively within and across teams in a fast-paced environment to ensure seamless collaboration and successful project execution.

PREFERRED JOB QUALIFICATIONS: 

Background in client-facing professional services or a similar consulting capacity.

Certifications in one or more domains: Google Data Analytics, Tableau, Salesforce (Business Analyst, Marketing Cloud Engagement, CRM Analytics), etc.

In-depth understanding of contemporary economic, financial, and regulatory institutions within the context of general aviation.

WORKING CONDITIONS: 

This position works in an office setting.

Typical working hours are 8:30 am - 5 pm, Monday through Friday, with a one-hour lunch break. 

Generally, a climate-controlled environment with occasional exposure to outdoor weather conditions when attending aviation-related events, including exposure to higher altitudes and confined spaces, if in a general aviation aircraft.

This position may require up to 5% travel. Potential travel may include local community or networking events, as well as industry-related seminars.  Travel is by aircraft (general aviation and commercial) and by road or public transit.  

PHYSICAL DEMANDS: 

The physical demands of this position are typical of a standard office environment. While performing the duties of this job, the employee will regularly be required to:

Sit for extended periods while working at a computer or attending meetings.

Use hands and fingers to operate a computer keyboard, mouse, and other office equipment.

Communicate effectively via email, phone, and in-person, which requires clear speech, hearing, and vision.

Occasionally, lift or move items weighing up to 15 pounds, such as boxes of materials or equipment.

Occasionally, stand, walk, and reach with hands and arms during the course of normal office activities.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation will be made to enable individuals with disabilities to perform the essential functions. 

ADDITIONAL INFORMATION:  
 
This position is located at AOPA’s Frederick, MD headquarters.   

The salary range for this position is: $75,000 - $85,000, depending on education and experience. 

BENEFIT INFORMATION: 

Flight Training (earn your Private Pilot License for free) & Annual Flight Proficiency Program (so you can keep flying and remain proficient) 

Medical, Dental, and Vision insurance is available for employees and their dependents the 1st of the month following their start date 

Flexible Spending Plans 

Health Savings Plan with employer contribution (for eligible participants) 

401(k) Retirement Plan with a company match, and annual discretionary supplemental employer contribution 

Company paid Short and Long-term Disability Insurance 

Company paid Life Insurance and AD&D insurance with the option to buy up  

Paid Time Off (PTO): 17 days accrued during first year (accruals increase based on tenure) 

Paid Holidays: 12 holidays 

Personal days: 3 (prorated based on hire date) 

Volunteer day: 1 (prorated based on hire date)  

Work From Home Fridays 

Paid Parental Leave  

AOPA Membership 

Employee Assistance Program 

Wellness Program (earn medical insurance premium discounts) 

Gym Reimbursement Program 

Supplemental insurance options (critical illness, accident, hospital indemnity) 

Tuition Reimbursement Program  

Discount on AOPA swag 

Business casual dress code 

Free coffee, tea, hot cocoa