Data and Reporting Analyst
MI-Admin Office Building (AOB), United States
Full Time Entry-level / Junior USD 60K - 70K
It’s a great time to join AAA The Auto Club Group!
JOIN THE TEAM COMMITTED TO DRIVING YOUR CAREER FORWARD
Job Type:
Full timeExempt/Non Exempt:
SalaryJob Description:
Data and Reporting Analyst – The Auto Club Group
What you will do:
The Distribution Data and Reporting Analyst prepares compensation reports, gathers data from business units, and oversees Google Cloud Platform (GCP) reporting. It also manages plan enhancements and coordinates with vendors (i.e., Varicent). The position also exports GCP files for presentations.
Primary Duties and Responsibilities:
- Prepare and present reports of job and variable compensation analysis
- Evaluate and implement channel analysis tools, techniques, and materials
- Works with BU to gather data needed for variable compensation analysis, departmental projects
- Act as Compensation resource to work with GCP team on construction of tables
- Oversees the design and development of GCP reporting
- Functional modeling on plan enhancements
- Works with Field reporting on mutually inclusive items
- Varicent liaison for plan changes and new plan requirements
- Export GCP files in order to provide compensation data necessary to construct presentations.
Supervisory Responsibilities:
- None
How you will benefit:
Data and Reporting Analyst will earn a competitive salary of $60k - $70k annually with annual bonus potential based on performance.
- Excellent and comprehensive benefits packages are just another reason to work for the Auto Club Group. Benefits include:
- 401k Match
- Medical
- Dental
- Vision
- PTO
- Paid Holidays
- Tuition Reimbursement
We’re looking for candidates who:
Required Qualifications:
Education:
- Bachelor Degree in related business line/field or equivalent work experience
Experience:
- 3-5 years of experience
- Investigating and resolving complex problems
- Coordinating support activities provided by multiple off-site vendors and internal departments
- Analyzing, understanding, and articulating financial impacts
- Designing business unit specific systems
- Analyzing, testing, documenting, implementing and/or deployment of complex data reporting
- Researching, testing editing and confirming accuracy of content
- Utilizing PC software applications (e.g., Windows operating systems, MS Word, Excel, PowerPoint, Access, VISIO, MS Project, Netware, IPM, NT, client/server database management systems, etc.) to format databases, write queries, generate reports, etc.
Knowledge of:
- Structured system analysis, design and testing
- Systems development methodologies
- Project management techniques
- Microsoft suites (Excel, Visio, etc.)
- Financial Modeling
- Programming queries and reporting
- Planning, organizing, and training others on the development and implementation/deployment of technical/financial data
Skills and Ability to:
- Demonstrate Excel expertise
- Proficiency in data analysis of complex reports
- Proficiency in presenting results of large datasets
- Communicate effectively with others in a work environment and with the public
- Provide guidance to all levels of staff and management
Preferred Qualifications:
Skills and Ability to:
- Write SQL
- GCP knowledge
Work Environment
This is a hybrid work arrangement (time spent in office and remote). Depending on the employee's role and leadership's assessment, some employees will come in to 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 teambuilding events.
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 www.aaa.com
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/affirmative action 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.
Tags: Data analysis Excel GCP Google Cloud SQL Testing
Perks/benefits: 401(k) matching Career development Competitive pay Health care Insurance Salary bonus Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.