This job is closed
We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.
SQL Data Analyst
$87,360 - $93,600/Yr
Roth Staffing Companies - Los Angeles, CA
posted about 2 months ago
Full-time - Entry Level
Los Angeles, CA
Administrative and Support Services
About the position
The SQL Data Analyst position at Roth Staffing Companies involves analyzing and manipulating SQL data sets, creating reports and dashboards for C-Level executives, and maintaining SQL databases. This role is crucial for providing insights into financial and operational data within the construction and equipment rental industry.
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.
- 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
- 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 in a fast-paced environment analyzing and reporting SQL data.
- Ability to read & write complex SQL query scripts and experience with SQL query optimization, stored procedures, and common table expressions (CTE).
- Knowledge and experience with SQL Server Reporting Services (SSRS) and SQL Report Writer.
- Strong skills with Microsoft Excel and experience using Pivot Tables and Formulas.
- Experience using Power BI or similar data visualization tools.
- Familiarity with Python scripting for data automation purposes.
- Experience extracting, manipulating, and reporting data information from financial and operations systems.
Nice-to-haves
- 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.
Benefits
- $42-$48/hr. as a contractor
- $42-$45/hr. + benefits as a full-time employee
