Efficiently manages various database management systems to ensure optimal performance. Designs, develops, and automates data transfers between multiple databases, streamlining operations. Creates data flow models for ETL applications. Identifies and resolves issues related to database performance, capacity, and other data-related concerns. Gathers requirements and implements solutions to meet organizational needs. Collaborates effectively with team members to design and develop ETL processe... more details
Senior Operations Analyst - Hybrid
The Automobile Club of Southern California is seeking a Senior Operations Analyst for our Costa Mesa, CA location. Work alongside a team of experts focused on improving Emergency Road Service Call Center Operations. Your main task will be developing tools for management and call center agents, aiding in performance evaluation, trend analysis, and strategic decision-making.
Responsibilities:
Efficiently manages various database management systems to ensure optimal performance.
Designs, develops, and automates data transfers between multiple databases, streamlining operations.
Creates data flow models for ETL applications.
Identifies and resolves issues related to database performance, capacity, and other data-related concerns.
Gathers requirements and implements solutions to meet organizational needs.
Collaborates effectively with team members to design and develop ETL processes.
Qualifications:
Bachelor’s degree in computer science or a related field, or equivalent combination of industry-related professional experience and education.
Proficient in SQL, Visual Studio, SSIS, and ETL processes; experience with Python, AWS, Athena, and Redshift.
Demonstrated expertise in Microsoft SQL databases, including development and troubleshooting.
Proven track record of writing ETL specifications and crafting complex ETL mappings.
Experience in identifying, researching, and resolving ETL issues.
Preferred Skills/Knowledge:
Experience in the complete lifecycle of application development, from conception and design to implementation and support.
Strong proficiency in ETL design and development, with expertise in SQL and stored procedures.
Familiarity with automation tools and test-driven development methodologies.
Ability to conduct calculations and data manipulations for thorough data validation and analysis.
Experience in working with and analyzing large datasets.
Excellent communication skills, both written and verbal, to effectively convey complex ideas and findings.
Exposure to business intelligence platforms, preferably Tableau.
#LI-KA-1
The starting pay range for this position is:
$76,400.00 - $101,900.00
Additionally, you will be eligible to participate in our incentive program based upon the achievement of organization, team and personal performance.
.
Remarkable benefits:
• Health coverage for medical, dental, vision
• 401(K) saving plan with company match AND Pension
• Tuition assistance
• PTO for community volunteer programs
• Wellness program
• Employee discounts
Auto Club Enterprises is the largest federation of AAA clubs in the nation. We have 14,000 employees in 21 states helping 17 million members. The strength of our organization is our employees. Bringing together and supporting different cultures, backgrounds, personalities, and strengths creates a team capable of delivering legendary, lifetime service to our members. When we embrace our diversity – we win. All of Us! With our national brand recognition, long-standing reputation since 1902, and constantly growing membership, we are seeking career-minded, service-driven professionals to join our team.
“Through dedicated employees we proudly deliver legendary service and beneficial products that provide members peace of mind and value.”
AAA is an Equal Opportunity Employer
The Automobile Club of Southern California will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance.