Business Analyst I

AOPA • Frederick, MD

7h • $63,000 - $70,000 • Onsite

About The Position

The Business Analyst I supports accurate, accessible, and actionable reporting across the Association. As a member of the Business Intelligence team, this role collaborates with departments to collect, validate, analyze, and visualize data that informs operational and strategic decisions. The analyst also develops and maintains reports as well as dashboards in Salesforce and Tableau, analyzes digital engagement using tools such as Google Analytics and BigQuery, and contributes to consistent data practices and governance. This role is well suited for an analytical professional who can translate business questions into clear findings for technical and non-technical audiences.

Requirements

• Bachelor’s degree in a related discipline.
• Minimum of three 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 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.

Nice To Haves

• 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.

Responsibilities

• 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.
• 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.
• 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.
• Deliver findings and recommendations that inform strategic decisions for internal and external stakeholders.
• Support 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.
• Contribute to the development and revision of operational metrics and departmental KPIs.
• Promote a culture of data collaboration and continuous improvement across the Organization.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level