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