Remote Data Integration Specialist
Company: AAA-The Auto Club Group
Location: Phoenix
Posted on: June 26, 2022
Job Description:
Job DescriptionRemote Data Integration Specialist - The Auto
Club GroupThe Finance Analytics Specialist is responsible for
optimizing data and data pipeline architecture. Role is responsible
for obtaining and transforming data in support of ACG's Finance
department's data initiatives.What You Will Do
- Enable timely and accurate Financial reporting by identifying,
ingesting, retrieving, and transforming data
- Build the infrastructure required for optimal extraction,
transformation, and loading of data from a wide variety of data
sources using SQL and Google Cloud Platform 'big data'
technologies.
- Improve decision-making by transforming and preparing data
across multiple platforms, i.e. GCP, PeopleSoft,
Insurance/Club/Membership systems for use in dashboards and
reporting
- Support Executive-level decisions through ad hoc data retrieval
and analysis
- Develop moderately complex queries to support all aspects of
departments reporting initiatives
- Collaborate across Lines of Business and technical teams on
best practices to integrate data and use cases to identify new data
that can bring value to our financial reporting and analysis
- Assist in developing controls to ensure data completeness and
accuracyFinance Analytics Specialist will earn a competitive salary
of $70,000 to $105,000 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 QualificationsPreferred
QualificationsWe're looking for candidates who:
- Strong SQL skills
- 3+ years' experience ingesting, transforming, landing, and
productionizing data in a cloud data environment
- Python scripting
- Experience working in Google Cloud environment
- Experience creating ad hoc reports and dashboards in
DataStudio
- Experience creating ad hoc reports and dashboards in
Tableau
- Experience combining data from multiples of formats: Tables,
JSON, XML, CSV, TXT, etc.
- Familiar with Google Cloud Platform Service cloud services
like: Cloud Sql, BigQuery, DataFlow, DataPrep, AppEngineII.
Required QualificationsEducation
- Bachelors degree in Finance, Statistics, or Computer Science or
related fieldExperience
- 3 or more years ingesting, transforming, landing, and
productionizing data in a cloud data environment
- 3 or more years building datasets for use in corporate
reporting and visualization
- 3 or more years exploratory data analysisKnowledge And Skills
- Experience working in cloud environment; i.e. AWS, Azure, GCP,
Snowflake
- Knowledge of information technology including database, desktop
computing skills, use of standard business application software and
business intelligence (BI) systems.
- Familiar with object-oriented/object function scripting
languages: i.e.: Python, Java, C++, Scala, etc.
- Strong analytic skills related to working with structured and
unstructured datasets.
- Ability to work with internal clients and associates at all
levels, both technical and non-technical in nature
- Ability to communicate, both verbally and in writingWhat It's
Like To Work For UsWe serve our members by making their
satisfaction our highest priority. We do what's right by sustaining
an open, honest and ethical work environment. We lead in everything
we do by offering best-in-class products, benefits and services.
And we value our employees by seeking the best talent, rewarding
high performance and holding ourselves accountable.All in all, we
create an inclusive and welcoming environment of diverse
backgrounds, experiences and viewpoints, realizing our differences
make us stronger.Who We AreThe Auto Club Group helps AAA Members
enjoy life's journey with peace of mind by providing innovative
solutions, advocacy and membership benefits wherever and whenever
they need them. We currently conduct business in 13 states in the
upper Midwest and the Southeast.The Auto Club Group has established
four long-term enterprise goals:
- Long-term, sustainable, profitable growth
- AAA Membership growth and renewal
- Operational excellence
- Become the "flagship club" of the AAA FederationImportant
NoteThe above statements describe the principle 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 fulfil
these requirements.The Auto Club Group, and all of 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.
Keywords: AAA-The Auto Club Group, Phoenix , Remote Data Integration Specialist, Other , Phoenix, Arizona
Didn't find what you're looking for? Search again!
Loading more jobs...