SQL Data Analyst
Company: LEDGENT Technology & Engineering - Roth Staffing C
Location: Los Angeles
Posted on: November 11, 2024
Job Description:
SQL Data AnalystEmployment Type: Contract-to-Hire (1-3 months
CTH)Workplace Type: OnsiteLocation: Mission Hills, CA
(91345)Industry: Construction/Equipment RentalsCompensation:
$42-$48/hr. as a contractor, $42-$45/hr. + benefits as a full-time
employeeDUTIES & 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 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 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.
#J-18808-Ljbffr
Keywords: LEDGENT Technology & Engineering - Roth Staffing C, Los Angeles , SQL Data Analyst, IT / Software / Systems , Los Angeles, California
Didn't find what you're looking for? Search again!
Loading more jobs...