Analyst, Business Intelligence

AAA Club Alliance•Wilmington, DE

6h•$61,959 - $107,276•Hybrid

About The Position

AAA Club Alliance is hiring for a Business Intelligence Analyst to join our team! What We Offer: As part of our team, you’ll enjoy a total rewards package designed to support your well-being, growth, and work-life balance. Our package includes: Competitive annual salary; the starting base compensation for this position is: $61,959-$107,276 Annual Bonus + Annual Merit Increase Eligibility Hybrid schedule (3 days on-site weekly) Comprehensive health benefits package 3+ weeks of paid time off accrued during your first year 401(K) plan with company match up to 7% Professional development opportunities and tuition reimbursement Paid time off to volunteer & company-sponsored volunteer events throughout the year Other benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, Life Insurance and Short Term/Long Term Disability The base pay range shown is a guideline for compensation and ultimate salary offered will be based on factors such as applicant experience and geographic location. The primary duties of the Business Intelligence Analyst are to: Utilize SQL and SAS, and/or any other comparable or emerging industry tools/methods for extraction, manipulation and cleansing of data, SAS Guide and/or any other comparable or emerging industry tools/methods for analytics, SAS Miner and/or any other comparable or emerging industry tools/methods for data mining and modeling, ESRI and/or any other comparable or emerging industry tools/methods for spatial and density mapping analysis and Microsoft SharePoint and/or any other comparable or emerging industry tools/methods for report presentation and delivery. Assist management in identifying opportunities to integrate new technologies to enable improved efficiencies in data analysis and business intelligence and insights. Develop streamlined, efficient representation of business trends by completing complex data aggregation and analysis. Design, maintain, analyze, and deliver timely daily, weekly, monthly and on demand management reports summarizing call volume, cost, service trends and various key performance indicators that measure product and enterprise integrity across all business lines. Develop reporting which support management in implementing strategies to achieve departmental and business line operational efficiencies and cost reductions. Support the process to calculate monthly bonuses and incentives for various business lines. Assist with the coordination with Accounts Payable and Human Resources to produce accurate and timely payment files. Conduct financial analysis on current and prospective programs that relates to advanced data analysis and trending, with the goal of delivering actionable recommendations to Management. Assist with the creation of presentations designed to influence key stakeholders and drive strategic business decisions. Assist management by collaborating with internal business line departments, vendor liaisons, external partners to share best practices, trends, and systemic enhancements to meet current and future business needs that supports the delivery of best-in-class analytics. Use SQL, Power BI, BASE SAS and SAS Guide, as well as any other comparable or emerging industry tools and methods to complete complex data aggregating; commingling multiple datasets to develop a streamlined, efficient representation of Automotive Solutions cost models related to roadside assistance usage and service provider trends. Analyze data with any comparable or emerging industry tools or methods for data mining and statistical analysis, to develop trend analysis around roadside assistance usage, and expense and liability models. Utilize ESRI GIS application and/or any other comparable or emerging industry tools or methods to complete advanced spatial and density mapping analysis to support overall business line operational strategies. Other duties as assigned

Requirements

Possess a strong technical background at a level normally acquired through the completion of Bachelor’s degree in Computational and Data Science, Economics, or Math required, or Masters of Science in Data Science, Masters of Science in Data Analytics, Masters of Science in Predictive Analytics or BS degree in other field in combination with years of experience and certifications will be considered.
3+ years of experience working with relational data.
Experienced in relational databases such as Oracle and Microsoft SQL.
Possess comprehensive knowledge of Microsoft’s Office Suite.
Must be a team player with excellent interpersonal skills and the ability to work in a cross functional matrix environment
Ability to work independently in fast paced environment with competing priorities, excellent oral and written communication skills and the ability to interpret end-user needs.

Nice To Haves

Possess or is quickly able to gain a strong background in Roadside Assistance and Automotive Services business preferred.
Experience with industry leading analytical tools and methods including, but not limited to Power BI, SAS Guide, SAS Modeler, BASE SAS and/or MCTS certification and working (or better) knowledge of ESRI preferred.
Demonstrated ability to translate complex and advanced analytics into easy to grasp concepts to non-technical partners.
Possess or is quickly able to gain a strong knowledge of AAA Club Alliance systems and any future system replacements, and the organization’s General Ledger Package, Accounts Payable system, Alliance Data Warehouse (ADW) and Membership System (MzP).
Experience in SharePoint desired and preferred.

Responsibilities

Utilize SQL and SAS, and/or any other comparable or emerging industry tools/methods for extraction, manipulation and cleansing of data, SAS Guide and/or any other comparable or emerging industry tools/methods for analytics, SAS Miner and/or any other comparable or emerging industry tools/methods for data mining and modeling, ESRI and/or any other comparable or emerging industry tools/methods for spatial and density mapping analysis and Microsoft SharePoint and/or any other comparable or emerging industry tools/methods for report presentation and delivery.
Assist management in identifying opportunities to integrate new technologies to enable improved efficiencies in data analysis and business intelligence and insights.
Develop streamlined, efficient representation of business trends by completing complex data aggregation and analysis.
Design, maintain, analyze, and deliver timely daily, weekly, monthly and on demand management reports summarizing call volume, cost, service trends and various key performance indicators that measure product and enterprise integrity across all business lines.
Develop reporting which support management in implementing strategies to achieve departmental and business line operational efficiencies and cost reductions.
Support the process to calculate monthly bonuses and incentives for various business lines.
Assist with the coordination with Accounts Payable and Human Resources to produce accurate and timely payment files.
Conduct financial analysis on current and prospective programs that relates to advanced data analysis and trending, with the goal of delivering actionable recommendations to Management.
Assist with the creation of presentations designed to influence key stakeholders and drive strategic business decisions.
Assist management by collaborating with internal business line departments, vendor liaisons, external partners to share best practices, trends, and systemic enhancements to meet current and future business needs that supports the delivery of best-in-class analytics.
Use SQL, Power BI, BASE SAS and SAS Guide, as well as any other comparable or emerging industry tools and methods to complete complex data aggregating; commingling multiple datasets to develop a streamlined, efficient representation of Automotive Solutions cost models related to roadside assistance usage and service provider trends.
Analyze data with any comparable or emerging industry tools or methods for data mining and statistical analysis, to develop trend analysis around roadside assistance usage, and expense and liability models.
Utilize ESRI GIS application and/or any other comparable or emerging industry tools or methods to complete advanced spatial and density mapping analysis to support overall business line operational strategies.
Other duties as assigned

Benefits

Competitive annual salary; the starting base compensation for this position is: $61,959-$107,276
Annual Bonus + Annual Merit Increase Eligibility
Hybrid schedule (3 days on-site weekly)
Comprehensive health benefits package
3+ weeks of paid time off accrued during your first year
401(K) plan with company match up to 7%
Professional development opportunities and tuition reimbursement
Paid time off to volunteer & company-sponsored volunteer events throughout the year
Other benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, Life Insurance and Short Term/Long Term Disability
Medical, Dental, and Vision plan options
Up to 2 weeks Paid parental leave
401k plan with company match up to 7%
2+ weeks of PTO within your first year
Paid company holidays
Company provided volunteer opportunities + 1 volunteer day per year
Free AAA Membership
Continual learning reimbursement up to $5,250 per year