Business Analytics Engineer II

Job Type: Full time Exempt/Non Exempt: Salary Job Description: Location Details: This is a hybrid work arrangement (time spent in the office and remote). Position Schedule / Shift: Monday - Friday, 9:00 am - 5:00 pm EST. Schedule may be adjusted depending on departmental or project needs. Position Summary: The Business Analytics Engineer II is responsible for analyzing membership and customer data to deliver insights that support business growth, retention, and engagement strategies. This role partners with stakeholders across Marketing, Product, Finance, and Operations to identify trends, measure campaign performance, evaluate key membership metrics, and provide actionable recommendations. Responsibilities include developing Tableau dashboards and reports, writing SQL queries, conducting data analysis, supporting testing and segmentation initiatives, and translating complex data into meaningful business insights that drive decision-making. Key Responsibilities: Conduct moderately complex analytical projects including member behavior analysis, retention driver identification, campaign effectiveness measurement, and cohort analysis Perform exploratory data analysis to uncover trends, patterns, and opportunities in membership data Support pricing analysis by evaluating elasticity, competitive positioning, and revenue impact scenarios Analyze member segmentation and develop targeting recommendations for marketing initiatives Calculate and monitor key membership metrics including lifetime value, churn rates, retention curves, and acquisition costs Participate in A/B test design and conduct statistical analysis to measure incrementality and significance Synthesize findings from multiple data sources into clear, actionable recommendations Design, build, and maintain dashboards in Tableau that enable insight for stakeholders Develop automated reporting solutions that reduce manual effort and improve data accessibility Create compelling data visualizations that effectively communicate complex information to varied audiences Establish and document dashboard design standards and best practices Troubleshoot and optimize dashboard performance, including improving query efficiency Maintain reporting documentation and provide training to dashboard users Write moderately complex SQL queries to extract, transform, and analyze data from multiple sources Develop and maintain data validation processes to ensure reporting accuracy Partner with data engineering teams to improve data quality and address integration issues Learn and apply new analytical techniques and tools to enhance team capabilities Create reusable code and analytical templates to improve team efficiency Serve as the analytics point of contact for specific functional areas or project streams Translate business questions into analytical approaches and deliver findings with clear implications Present analysis results to cross-functional teams and mid-level management Collaborate with Product, Marketing, Finance, and Operations teams to support data-driven decision-making Proactively identify opportunities where analytics can add value and propose projects Build credibility as a trusted analytics resource through quality work and responsive service Qualifications: Required Bachelor's degree in Statistics, Mathematics, Economics, Business Analytics, Computer Science, Management Information Systems, a related quantitative field, or related experience 2-4 years of experience in analytics, business intelligence, or data analysis roles Demonstrated track record of delivering analytical projects that influenced business decisions Background in product analytics, marketing analytics, or customer analytics valued Proficient SQL skills for complex queries, joins, subqueries, and data manipulation Strong Tableau skills including calculated fields, parameters, table calculations, and dashboard design Advanced Excel proficiency including complex formulas, macros, and data modeling Understanding of data warehouse concepts and dimensional modeling Familiarity with statistical analysis and hypothesis testing Experience with CRM platforms (Salesforce preferred) or marketing automation tools a plus Basic exposure to Python or R for data analysis preferred Basic understanding of database concepts and data structures Solid understanding of subscription/membership business metrics (LTV, churn, retention, CAC) Knowledge of cohort analysis, funnel analysis, and customer journey mapping Understanding of marketing channel performance and attribution concepts Familiarity with A/B testing methodologies and experimental design Ability to connect analytical findings to business strategy and financial outcomes Proven ability to manage multiple projects and priorities effectively Preferred Master’s degree in a quantitative field (e.g., Data Analytics, Statistics, Computer Science, Economics, or related discipline) Experience working with subscription, membership, or recurring revenue business models preferred Experience in insurance, automotive services, or member-based organizations Exposure to predictive modeling or machine learning concepts Familiarity with cloud data platforms (Google Cloud Platform preferred) Tableau Desktop Certified Associate or similar certification Knowledge of AAA or similar membership organizations Work Environment: This is a hybrid work arrangement (time spent in the office and remote). Depending on the employee's role and leadership's assessment, some employees will come into an ACG facility on a weekly basis, a monthly basis, or on an "as needed" basis for key meetings and collaborative activities. Most employees will be required to come into the office, at a minimum, for important departmental meetings or team-building events. Works in a temperature-controlled office environment. Travel throughout state/out-of-state, including various ACG clubs and field locations, with exposure to road hazards and temperature extremes. Compensation & Benefits Overview: ACG complies with all applicable state and local laws regarding required benefits (including PTO, paid sick leave, etc.). Earn a competitive salary of $85,966 - $133,702 with annual bonus potential based on performance. Health & Wellness Medical plans with multiple coverage options, including HSA eligibility. Prescription drug coverage. Dental and vision benefits. Employee Assistance Program (confidential support services). Financial Protection & Insurance Company-paid basic life insurance. Optional supplemental life insurance and dependent coverage. Short-term and long-term disability coverage. Critical illness, accident, and pet insurance options. Retirement & Savings 401(k) plan to support long-term financial goals. 3% automatic deferral upon eligibility; may contribute 1% to 50% of eligible earnings, either pre- or post-tax. Company match of 50% paid on employee contributions up to 6% of pay, payable to employees following the end of the year; immediate vesting. Additional company contribution of 4% of pay each payday into your account; 100% vested after three (3) years of service. Health Savings Account (HSA) and Flexible Spending Accounts (FSA) options. Time Off & Leave Paid Time Off (PTO): Accrual-based, increases with tenure, eligible at 90 days of employment. Full-time new employees will receive up to 12 PTO days annually; accrual based on start date and may include additional PTO based on role and/or state & local requirements. Part-time employee PTO hours are calculated based upon the standard weekly hours the employee is scheduled to work and will accrue at a minimum of 3 hours per month. Paid Holidays: Full-time employees are eligible for 10 company-paid holidays annually, in addition to 1 mental health day, 2 floating holidays, and 1 volunteer day. Holidays vary by business unit schedules. Part-time employees are eligible for 8 company-paid holidays annually, in addition to 1 mental health day and 2 floating holidays. Holidays vary by business unit schedules. Paid leave programs include parental, bereavement, jury duty, and military leave. Career Growth & Education Tuition assistance (up to $5,250 annually; 80% covered by ACG). Professional certification support with 100% reimbursement for eligible programs. Opportunities for career development and advancement. Additional Perks Complimentary AAA membership with roadside assistance and travel discounts. Adoption assistance program. Job Posting Period: This position is expected to remain posted through 8/28/2026; however, it may close at any time once a qualified candidate pool is identified. #appcast Who We Are Become a part of something bigger. The Auto Club Group (ACG) provides membership, travel, insurance, and financial service offerings to approximately 14+ million members and customers across 14 states and 2 U.S. territories through AAA, Meemic, and Fremont brands. ACG belongs to the national AAA federation and is the second largest AAA club in North America. By continuing to invest in more advanced technology, pursuing innovative products, and hiring a highly skilled workforce, AAA continues to build upon its heritage of providing quality service and helping our members enjoy life’s journey through insurance, travel, financial services, and roadside assistance. And when you join our team, one of the first things you’ll notice is that same, whole-hearted, enthusiastic advocacy for each other. We have positions available for every walk of life! AAA prides itself on creating an inclusive and welcoming environment of diverse backgrounds, experiences, and viewpoints, realizing our differences make us stronger. To learn more about AAA The Auto Club Group visit Important Note: ACG’s Compensation philosophy is to provide a market-competitive structure of fair, equitable and performance-based pay to attract and retain excellent talent that will enable ACG to meet its short and long-term goals. ACG utilizes a geographic pay differential as part of the base salary compensation program. Pay ranges outlined in this posting are based on the various ranges within the geographic areas which ACG operates. Salary at time of offer is determined based on these and other factors as associated with the job and job level. The above statements describe the principal and essential functions, but not all functions that may be inherent in the job. This job requires the ability to perform duties contained in the job description for this position, including, but not limited to, the above requirements. Reasonable accommodations will be made for otherwise qualified applicants, as needed, to enable them to fulfill these requirements. The Auto Club Group, and all its affiliated companies, is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability or protected veteran status. Regular and reliable attendance is essential for the function of this job. AAA The Auto Club Group is committed to providing a safe workplace. Every applicant offered employment within The Auto Club Group will be required to consent to a background and drug screen based on the requirements of the position. #J-18808-Ljbffr acg