SQL Tech Lead

New York, Inc.
Berkeley, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Berkeley, United States of America

Tech stack

Java
Agile Methodologies
Cloud Database
Computer Programming
Databases
Data Governance
Data Integrity
ETL
Data Mining
Data Visualization
Data Warehousing
Database Design
Database Development
Python
Microsoft SQL Server
SQL Azure
MongoDB
NoSQL
Performance Tuning
Scrum
Power BI
Cloud Services
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Freeform SQL
Snowflake
Database Performance
Information Technology
Cassandra
Azure
Programming Languages

Job description

We are seeking an experienced Lead SQL and ETL Developer with over 7 years of experience to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining SQL databases and Extract Transform Load (ETL) jobs, ensuring data integrity, and optimizing performance. You will work closely with data analysts, data scientists, and other stakeholders to support data-driven decision-making within the organization., Work with cross-functional teams to understand business requirements and translate them into technical specifications.

Plan and manage project delivery scope, sprint planning, task assignment to developers and tracking completion.

Create and maintain documentation for database designs, processes, and procedures, as defined by CHUBB engineering and architecture.

Design, develop, and maintain SQL databases and data models.

Write complex SQL queries for data extraction, transformation, and loading (ETL).

Optimize SQL queries and database performance.

Ensure data integrity and security across all databases.

Troubleshoot and resolve database issues and performance bottlenecks.

Requirements

Ability to work independently and Support Team members in a team-oriented, collaborative environment

Stay updated with the latest industry trends and technologies related to SQL and database management.

Must-Have Skills:

7+ years of experience in SQL development and database management.

Excellent communication and collaboration skills.

Proficiency in writing complex SQL queries, stored procedures, and functions.

Strong understanding of database design principles and data modeling.

Experience with performance tuning and optimization of SQL queries.

Experience with Microsoft SQL Server 16 and above versions, and Azure SQL Database.

Experience with development of ETL jobs in SSIS

Knowledge of ETL processes and tools.

Experience with data warehousing concepts and practices.

Strong analytical and problem-solving skills.

Nice-to-Have Skills:

Experience with cloud-based database solutions (e.g., Azure SQL Database, Azure Synapse, Snowflake).

Experience with Informatica Intelligent Cloud Services (IICS)

Experience with data visualization tools (e.g., Power BI).

Knowledge of programming languages such as Python, or Java.

Knowledge of .Net programming.

Understanding of data governance and compliance standards.

Familiarity with Agile methodologies and project management tools.

Familiarity with NoSQL databases (e.g., MongoDB, Cassandra).

Education:

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).?

???? Interested or open to new opportunities?

Apply for this position