Data Analyst - Finance

AAA • Costa Mesa, CA

5d • $74,500 - $99,500

About The Position

The Data Analyst provides analytical and organizational support to Finance operations and management. The role uses data processing, report development, and scripting languages such as Python and SQL to create, develop, test, and deploy adaptable tools and reports that support the business. The analyst conducts data analysis, identifies trends, and creates visualizations and dashboards. The role also involves understanding established procedures and recommending improvements, while managing tasks and projects under general supervision and, as stated in the duties, close guidance from a Senior resource.

The position develops long-term and ad hoc reporting, analyzes trends and root causes, and helps maintain a predictive churn model and related reports. It documents processes, works with teams and management on production reporting and enhancements, and collaborates with other business units to support common objectives. The role requires extensive knowledge of AWS, Snowflake, SQL databases, data mining, and Tableau-based visualization.

Requirements

• Bachelor’s degree or equivalent combination of education and experience.
• 1–3 years of experience in a traditional data or analytics corporate environment.
• 1–3 years of experience compiling, analyzing, and reporting qualitative or quantitative data.
• 1–3 years of experience manipulating data with SQL, Python, R, or related technologies.
• Professional verbal and written communication skills.
• Strong SQL skills and data mining knowledge.
• Advanced Excel skills, including VBA, macros, and complex calculations.
• Ability to rapidly learn new processes, databases, and applications.
• Extensive knowledge of AWS, Snowflake, and SQL databases, as well as data mining and data visualization through Tableau.

Nice To Haves

• Tableau experience.
• Python experience.
• Experience with a statistical churn model.

Responsibilities

• Develop SQL scripts and long-term reports using SQL, Teradata, Tableau, and Excel.
• Identify and analyze trends, conduct root cause analysis, and provide solutions.
• Perform ad hoc data analysis across source systems using SQL, Teradata, Tableau, Excel, and Access.
• Design, build, and maintain a predictive churn model.
• Develop internal reports on key churn indicators, including ad hoc reports as needed.
• Organize projects and create accurate plans to support timely delivery of initiatives.
• Document existing and newly created processes for implementation in production systems.
• Meet with the team and management about semi-complex production reporting and enhancements; describe challenges and offer solutions and recommendations.
• Collaborate with business units such as Big Data, Marketing, and Product Management to accomplish shared goals.
• Query large datasets, validate data, and perform User Acceptance Testing.
• Develop specialized reports and dashboards, troubleshoot data issues, and develop solutions to complex data issues.
• Formulate calculations to compute incentives, goals, and forecasts.

Benefits

• Health coverage for medical, dental, and vision.
• 401(k) savings plan with company match and pension.
• Tuition assistance.
• Floating holidays and PTO for community volunteer programs.
• Paid parental leave.
• Wellness programs.
• Employee discounts on membership, insurance, travel, entertainment, services, and more.
• For full-time positions, eligibility to participate in an incentive program based on organization, team, and personal performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level