Database Developer

Allstate Insurance Company; Tijuana; A distancia; MXN 1,113,000 - 1,486,000; Jornada completa

Descripción de la vacante

A leading insurance corporation is seeking an Application Developer II to support and develop data-driven applications in Tijuana, Mexico. The role involves enhancing business processes and collaborating on software solutions, with a primary focus on SQL Server and PostgreSQL. Ideal candidates will have strong problem-solving skills and at least 2 years of software development experience, with a remote working environment aligned to Pacific Time.

Formación

• 2+ years of experience in application or software development.
• Strong SQL development and scripting experience.
• Solid analytical and problem-solving skills.

Responsabilidades

• Develop and maintain applications and automated processes for data operations.
• Support data processing activities and ensure system performance.
• Participate in the migration of legacy SQL Server processes to Yellowbrick.

Conocimientos

SQL development

PowerShell scripting

Analytical skills

Problem-solving skills

Teamwork

Communication skills

Herramientas

SQL Server

PostgreSQL

Python

Power BI

Descripción del empleo

Integon 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. It’s how we’ve become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more.

Job Description

We are seeking an Application Developer II to join our Data & Analytics team. This role plays a key part in supporting and developing data-driven applications that handle essential business processes such as ledgering, reinsurance, and analytics data processing.

The ideal candidate will be passionate about database technologies, automation, and process optimization, with strong analytical and problem-solving skills. You will start by learning our systems and support workflows, and gradually move into more complex development projects as you gain familiarity with our tools and environment.

Key Responsibilities

• Develop, enhance, and maintain applications and automated processes supporting data operations.
• Support daily data processing activities, ensuring data integrity and system performance.
• Participate in the migration of legacy SQL Server processes to Yellowbrick (PostgreSQL).
• Develop and maintain PowerShell scripts to manage data movement and system tasks.
• Conduct structured code reviews and ensure compliance with internal standards.
• Collaborate with team members to identify, troubleshoot, and resolve issues across environments.
• Participate in on-call rotations to provide production support as part of a shared schedule.
• Contribute to the design and documentation of database and system solutions.
• Prepare accurate test data and participate in testing reviews to identify and address potential issues.
• Continuously identify opportunities to improve process efficiency and automation.
• Track and resolve defects, document fixes, and communicate dependencies according to established standards.
• Work closely with project managers to provide accurate time estimates, communicate deviations, and ensure timely delivery of assigned tasks.

Technologies Used

• Must-Have: SQL Server and/or PostgreSQL and PowerShell scripting
• Nice-to-Have: Python and Power BI or similar reporting tools, experience with data migration projects or modern database platforms (e.g., PostgreSQL, Yellowbrick)

Qualifications required:

• 2+ years of experience in application or software development
• Strong SQL development and scripting experience
• Solid analytical and problem-solving skills
• Excellent teamwork and communication abilities

Soft Skills

• Strong problem-solving and critical thinking abilities
• Ability to learn quickly and work independently in a remote environment
• Collaborative approach and willingness to support team goals
• High attention to detail and accountability for deliverables

Work Schedule

• Remote role, aligned with the candidate’s local time zone
• Preferred schedule: 8:00 a.m. – 6:00 p.m. Pacific Time

Supervisory Responsibilities

This job does not have supervisory duties.

Education & Experience (in lieu)

In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

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.

In the event you need assistance or accommodation in completing your online application, please contact Integon via WhatsApp at 664.203.4492

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.