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, Santa Barbara , SQL Data Analyst, IT / Software / Systems , Los Angeles, California