Job Opening details:-
Company Name :-
United Auto Credit Corporation


Position Name :-


Company Location :-
Newport Beach, CA 92660

 

Full Job Description :-
SUMMARY:
Our IT department is looking to add a passionate SQL Data Analyst Jr.(SDA). The successful candidate will turn data into information, information into insight and insight into business decisions. This position will be in our Newport Beach, CA office.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

SDA responsibilities include conducting full lifecycle analysis to include requirements, activities and design SDA will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements
Interpret data, analyze results using statistical techniques and provide ongoing reports

· Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
· Acquire data from primary or secondary data sources and maintain databases/data systems
· Identify, analyze, and interpret trends or patterns in complex data sets
· Good verbal communication and technical writing skill
· Develop Reports (Live Reports, Canned Reports), Develop and Implement BI and Analytics Report Dashboard
· Certain level of Database Server Administration such as Replication, Log Shipping, Always on High Availability
· Monitor Job and troubleshoot issues and fix accordingly or delegate the issues to appropriate person/team.
PREFERRED EXPERIENCE & QUALIFICATIONS: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability
· Working experience as an analyst or business analyst
· Working experience with database administration and Maintenance
· Knowledge of data models, database design development, data mining techniques
· Knowledge of and experience with reporting packages (SSRS, BI Platform, etc), databases (SQL Server, etc), programming (XML, Javascript, or ETL frameworks)
· Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc)
· Knowledge and experience with ETL tools such as SSIS (Design Develop Implement and Troubleshoot), Informatica
· Excellent TSQL Development and Implementation.
· Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
· Adept at queries, report writing and presenting findings
· BS in Mathematics, Economics, Computer Science, Business Administration, Information Management or Statistics (Preferred)
WHAT YOU CAN EXPECT FROM US
We provide a competitive base salary as well as a comprehensive benefits package that includes medical, dental vision and a 401(k) investment plan. In addition, our hands on management team offer employees a true open door policy and a philosophy of promoting from within allows for career growth potential. If you are interested in stretching
your mind and collaborating with some exceptional people, you won’t want to miss the opportunity of becoming a part of our diverse team.
Job Type: Full-time
Schedule:

8 hour shift

Ability to commute/relocate:

Newport Beach, CA 92660: Reliably commute or planning to relocate before starting work (Preferred)

Experience:

SQL: 1 year (Preferred)
Microsoft SQL Server: 2 years (Preferred)
ETL: 1 year (Preferred)

Work Location: One location