Data Analyst - Finance

AAA • Costa Mesa, CA

1d • $74,500 - $99,500 • Onsite

About The Position

The Data Analyst provides analytical and organizational support to the Finance operations/management. They are proficient in data processing and report development, as well as scripting languages, including Python and SQL. Capable of creating, developing, testing, and deploying highly adaptive tools and reports used to support business. Responsible for conducting data analysis, analyzing trends, and creating visualizations and dashboards. The Data Analyst will be expected to understand established procedures and recommend improvements. The Data Analyst can self-manage tasks, projects, and complete them in a timely manner under general supervision.

Requirements

• Bachelors Equivalent combination of education and experience.
• 1-3 years Experience in a traditional data or analytics corporate environment.
• 1-3 years Experience in providing qualitative or quantitative data compilation, analysis and reporting.
• 1-3 years Experience with manipulating data with SQL, Python, R or related technologies.
• Professional verbal and written communication skills required.
• Strong SQL skills with data mining knowledge.
• Advanced Excel skills (incl. VBA, macros, complex calculations, etc.).
• Able to rapidly learn new processes, databases, applications.

Nice To Haves

• Tableau preferred.
• Python preferred.
• Experience in statistical churn model a plus.

Responsibilities

• Develop SQL scripts and long-term reporting using a variety of data analysis tools / languages (SQL, Teradata, Tableau, and Excel).
• Identify and analyze trends with root cause analysis while providing solutions.
• Provide ad hoc data analysis in a variety of source systems and using a variety of data analysis tools/ languages (SQL, Teradata, Tableau, Excel, Access).
• Design, build, and maintain a predictive churn model. Develop internal reports on key indicators of churn, including ad-hoc reports as needed.
• Organize projects clearly with accurate plan for speed of delivery of initiatives.
• Document existing and newly created processes for implementation in production systems.
• Meet with Team and Management concerning semi-complex production reporting and enhancements. Provides detail regarding challenges and offer solutions and recommendations.
• Collaborate with other Business Units such as Big Data, Marketing, and Product Management to accomplish common goals and objectives.
• Querying large data sets, validating data, and performing User Acceptance Testing.
• Developing specialized reports/dashboards.
• Troubleshooting data issues.
• Developing solutions to complex data issues.
• Formulation of calculations to compute incentives, goals, forecasts.

Benefits

• Health coverage for medical, dental, vision
• 401(K) saving plans with company match AND Pension
• Tuition assistance
• Floating holidays and PTO for community volunteer programs
• Paid parental leave
• Wellness programs
• Employee discounts (membership, insurance, travel, entertainment, services and more!)

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree