SQL Database Developer Consultant I

National General is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. We offer home, auto and accident and health insurance, as well as other specialty niche insurance products, through a large network of independent insurance agents, as well as directly to consumers. 

Job Description

We are seeking a motivated and detail-oriented SQL Database Developer to join our data and technology team. This role is ideal for early-career professionals with a foundational understanding of SQL and relational databases. The successful candidate will assist in developing, maintaining, and optimizing database structures, queries, and data processes to support business applications and reporting needs for vital National General systems.

The internal National General job title used for this role is Software Engineer Consultant I.

Key Responsibilities

• Write, test, and maintain SQL queries, stored procedures, and functions

• Collaborate with developers, analysts, and end users to understand data requirements

• Assist in the design and development of relational database schemas and data models

• Support database performance tuning and indexing efforts

• Monitor, troubleshoot, and resolve issues in SQL Server or other RDBMS platforms

• Assist with ETL (Extract, Transform, Load) processes for importing and transforming data

• Support database documentation, backups, and version control practices

Qualifications

• Familiarity with SQL and basic knowledge of T-SQL, PL/SQL, or similar query languages

• Understanding of relational database concepts, data normalization, and indexing

• Exposure to Microsoft SQL Server, MySQL, PostgreSQL, or equivalent RDBMS

• Basic experience with SSIS (SQL Server Integration Services) or other data integration tools

• Familiarity with source code/version control systems such as Git or Azure DevOps

• Some experience with reporting tools (e.g., SSRS, Power BI, Tableau) is a plus

• Strong analytical and problem-solving skills

• Willingness to learn and adapt in a fast-paced environment

Preferred Skills (Nice to Have)

• Internship or project experience with database systems

• Exposure to scripting languages like Python or PowerShell

• Basic knowledge of ETL tools or data warehousing concepts

Experience

• 0-2 years of experience (Preferred)

Supervisory Responsibilities

• This job does not have supervisory duties.

#LI-MF1

Compensation

Base compensation offered for this role is $62,800.00 - $90,000.00 annually and is based on experience and qualifications.

*** Total compensation for this role is comprised of several factors, including the base compensation outlined above, plus incentive pay (i.e., commission, bonus, etc.) as applicable for the role.

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

National General Holdings Corp., a member of the Allstate family of companies, is headquartered in New York City. National General traces its roots to 1939, has a financial strength rating of A– (excellent) from A.M. Best, and provides personal and commercial automobile, homeowners, umbrella, recreational vehicle, motorcycle, supplemental health, and other niche insurance products. We are a specialty personal lines insurance holding company. Through our subsidiaries, we provide a variety of insurance products, including personal and commercial automobile, homeowners, umbrella, recreational vehicle, supplemental health, lender-placed and other niche insurance products.

Companies & Partners

Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.

Benefits

National General Holdings Corp. is an Equal Opportunity (EO) employer – Veterans/Disabled and other protected