SQL Data Analyst at Roth Staffing Companies in Los Angeles, California

Job Description:

SQL Data Analyst



Employment Type: Contract-to-Hire (1-3 months CTH)


Workplace Type: Onsite


Location: Mission Hills, CA (91345)


Industry: Construction/Equipment Rentals


Compensation: $42-$48/hr. as a contractor $42-$45/hr. + benefits as a full-time employee



DUTIES & RESPONSIBILITIES:

• Analyze and manipulate SQL data sets; test and debug issues with SQL queries and reports; create and optimize complex SQL queries including stored procedures and common table expressions


• Assist in the development of monthly reports and visual dashboards of financial, operational, and customer data, including billings, revenue, and transactions for C-Level executives and the finance team.


• Manage, update, and maintain SQL databases.


• Utilize statistical programming languages to create automation scripts for analyzing and reporting data


• Extract, manipulate, and report data from financial and operations software systems.

REQUIREMENTS SKILLS:

• Bachelor's or Associate's Degree in Data Analytics, Computer Science, Software Engineering, or related fields (Preferred)


• 3-5+ years of experience working in a Data Analyst role working in a fast-paced environment analyzing and reporting SQL data.


• Ability read & write complex SQL query scripts and experience with SQL query optimization, stored procedures, and common table expression (CTE)


• Knowledge and expeirnece with SQL Server Reporting Services (SSRS) and SQL Report Writer


• Strong skills with Microsoft Excel and experience using Pivot Tables and Formulas


• Experiences using Power BI or similar data visualization tools.


• Familiarity Python scripting for data automation purposes


• Experience extracting, manipulation, and reporting data information from financial and operations systems.

BONUS SKILLS:

• Certifications with SQL, Oracle, and Data Analytics


• Experience and knowledge of Oracle databases and PL/SQL scripting.


• Knowledge of Asset & Inventory Management and Sales/Rental Contract Management Software; familiarity with Basis Software is a huge plus!


• Familiarity with Adobe products

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions. Apply Now