AOPA
Overview The Data Analyst II ensures accurate data collection, processing, modeling, and analysis. This role is on the Business Intelligence team and collaborates cross-functionally to enable high-quality, data-driven decision-making and translate insights into strategic opportunities. The position supports data accuracy and consistency across reporting efforts in a Salesforce environment and monitors web traffic using tools such as Google Analytics and BigQuery to uncover user behavioral trends, optimize digital engagement, and inform marketing strategy. It also involves developing efficient systems for data analysis, reporting, and governance across the Association and designing, managing, and presenting reports and dashboards in Salesforce and Tableau to support transparency, performance tracking, and strategic planning.
Responsibilities
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. 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.
Qualifications
REQUIRED: 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; 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 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; strong writing and presentation skills.
Ability to work effectively within and across teams in a fast-paced environment.
Preferred Qualifications
Background in client-facing professional services or a similar consulting capacity.
Certifications in 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 hours are 8:30 am – 5 pm, Monday through Friday, with a one-hour lunch break. Occasional travel up to 5% may be required. Travel may include local community or networking events, industry-related seminars, and travel by aircraft or road/public transit. The environment is climate-controlled with possible exposure to outdoor conditions during events.
Location & Compensation
Location: Frederick, MD headquarters. Salary range: $75,000 – $85,000, depending on education and experience.
Benefits
Flight Training (Private Pilot License for free) & Annual Flight Proficiency Program
Medical, Dental, Vision insurance for employees and dependents (start date following)
Flexible Spending Plans; Health Savings Plan with employer contribution
401(k) with company match and discretionary employer contributions
Short and Long-term Disability; Life Insurance and AD&D
PTO: 17 days/year; Holidays: 12; Personal days: 3; Volunteer day: 1
Work From Home Fridays; AOPA Membership; Employee Assistance Program
Wellness Program; Tuition Reimbursement; Discount on AOPA swag
Business casual dress code; Free coffee, tea, hot cocoa
Equal Opportunity Employer
Note: This description reflects the majority of duties and may include other duties as assigned.
#J-18808-Ljbffr