SQL Developer - Los Angeles, United States - EDR Technology

EDR Technology
EDR Technology
Verified Company
Los Angeles, United States

3 weeks ago

Mark Lane

Posted by:

Mark Lane

beBee recruiter
Description

SQL Developer

Location:
Los Angeles, CA(Onsite)

Must be a Green Card Holder or US Citizen

Job Description:
Qualifications and Duties
1) Establish and document the technical requirements for reporting software such as tables, views, report design, unit test plans, and test cases.

2) Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.

4) Create and maintain complex SQL statements to generate tables and views that will be used by PowerBI developers to drive visualizations. Develop and enhance SQL-based tables and views as per user requirements.

5) Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to development standards and best practices using dbt.

6) Generate SQL tables using dbt according to established procedures and standards. Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended.

7) Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity.

9) Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements.

10) Train other staff members in development processes and standards to ensure consistency across the team.


Pay:
$75, $85,000.00 per year


Benefits:


  • 401(k)
  • 401(k)
matching

  • Dental insurance
  • Health insurance
  • Paid time off
  • Retirement plan
  • Vision insurance

Compensation package:

  • Yearly pay

Experience level:

  • 3 years

Schedule:

  • 8 hour shift

Application Question(s):

  • Are you a Green Card holder or a US Citizen?

Experience:


  • SQL: 3 years (preferred)
  • Power BI: 3 years (preferred)

Ability to Commute:

  • Los Angeles, CA preferred)

Ability to Relocate:

  • Los Angeles, CA 90017: Relocate before starting work (required)

Work Location:
In person
More jobs from EDR Technology
See all jobs of EDR Technology