SQL Developer - Los Angeles, United States - Jada Systems, Inc.
Description
Job Summary:
Jada Systems Inc seeks qualified proposers to provide SQL Developer on behalf of the Information Technology Services.
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 on development processes and standards to ensure consistency across the team.
Requirements:
- Proficiency in SQL programming and database management
- Experience with AWS services for data storage and processing
- Knowledge of database design principles and best practices
- Familiarity with ETL tools like Informatica for data integration
- Ability to work with big data technologies such as Hadoop, Apache Hive, and Spark
- Strong analytical skills with a focus on data accuracy and integrity
Job Types:
Full-time, Contract
Pay:
$78, $94,277.94 per year
Benefits:
- Health insurance
- Paid time off
Experience level:
- 3 years
Schedule:
- 8 hour shift
- Monday to Friday
Experience:
- SQL: 3 years (preferred)
- Data warehouse: 3 years (required)
Ability to Commute:
- Los Angeles, CA required)
Ability to Relocate:
- Los Angeles, CA 90017: Relocate before starting work (required)
Work Location:
In person
More jobs from Jada Systems, Inc.
-
Business System Analyst
Pasadena, United States - 1 week ago
-
Data Scientist
Los Angeles, United States - 6 days ago
-
Dot Net Developer
Costa Mesa, United States - 2 weeks ago
-
Office Assistant
Pasadena, United States - 3 weeks ago
-
BI Developer
Los Angeles, United States - 6 days ago
-
Artificial Intelligence Consultant
California, United States - 1 week ago