CW Reporting Analyst (SQL)

Pyramid Consulting

Phoenix, AZ

JOB DETAILS
SKILLS
Analysis Skills, Asset Management, Automotive Financing, Consumer Branding, Data Analysis, Data Warehousing, Database Administration, Documentation, Finance, Financial Reporting, Financial Services, Hyperion, Insurance, Leadership, Microsoft Access Database, Microsoft Excel, Microsoft Office, Microsoft Visual Basic for Applications (VBA), Microsoft Windows Operating System, Multitasking, Operational Support, Pivot Tables, Python Programming/Scripting Language, Reporting Skills, Retail, SQL (Structured Query Language), Statistical Analysis System (SAS), Statistics, Tableau, Time Management, Workforce Management
LOCATION
Phoenix, AZ
POSTED
2 days ago
Reporting Analyst

As a Reporting Analyst this candidate will be responsible for providing timely and accurate reporting that enables our leadership to make informed data-driven decisions. This position requires development of reports, charts, tables, graphs, and intermediate statistical analysis using tools such as Python, Tableau, SAS, SQL, and Microsoft Excel. Specifically this candidate will be responsible for the following:

  • Automate standardized reporting
  • Generation and delivery of standard reports
  • Synthesize raw data into actionable insights to drive business decisions
  • Identify gaps and opportunities for improvements among existing reports
  • Completion of ad-hoc reporting, data, and analysis requests
  • Create and maintain process documentation
  • Meet regular delivery timelines

Primarily interactions will be with the SOAR team, with some interactions with other Demand Management and Workforce Management teams. However, we support all service operations areas of the business, so there will be potential to interact with many areas.

This project is a 6 month contract and is currently in the ongoing phase.

Position Requirements:

Must Haves:

  • 5+ years of experience in designing reports, charts, graphs in Microsoft Office applications
  • 5+ years of recent SQL programming experience preferably in Windows
  • Ability to multitask on several projects at once
  • Ability to work independently with deadlines and deliver high quality results
  • Advanced experience in creating Access databases and Excel Reports using modules, forms, macros, formulas, VBA, and pivot tables
  • Strong understanding of financial services data desired
  • Proficiency with web and client based reporting tools i.e. Aginity or Hyperion
  • Data warehouse experience helpful
  • Python and Tableau experience helpful

Preferred/ Nice-to-haves:

Client Financial Services is headquartered in Plano, TX. It is the finance and insurance brand for Client in the United States, offering retail auto financing and leasing through Client Credit Corporation and extended service contracts through Client Insurance Services (TMIS). Client currently employs over 3,300 associates nationwide, and has managed assets totaling more than *** billion. It is part of a worldwide network of comprehensive financial services offered by Client Financial Services Corporation, a wholly-owned subsidiary of Client Corporation. Equal Opportunity Employer

About the Company

P

Pyramid Consulting