.ABOUT USIntegon Service Co. supports its insurance company affiliates, which offer property and casualty insurance products, including personal auto, homeowners, RV, motorcycle, small business auto insurance and more.With our Mexico headquarters located in Tijuana, Baja California, at Integon, with over 900 employees, we continue to grow our portfolio of remote positions that can be filled anywhere in the country. We offer the stability of a large corporation with the flexibility of a remote or hybrid career.We continue to build a caring and inclusive company culture and are proud to be certified as a Great Place to Work!Primary Purpose:This position will serve as a high-level technical expert in the designing, coding, testing, supporting and debugging of new software or significant enhancement to existing software.Essential Duties and Responsibilities:- Create, maintain, and optimize stored procedures, functions, inline SQL, database structures, SSIS Packages and SSRS Reports to adapt to changes in needs and requirements.- Tests coded program routines and makes revisions to eliminate errors.- Reviews test results with business, completes final program documentation, and obtains approval for changes.- Analyzes and documents how the business requirements fit into existing system.- Develops technical specifications to resolve business client questions, problems, and to address enhancement needs.- Develop new methods and procedures for accomplishing work. Provide work direction to less experienced team members.- Translate detail program specifications for complex problems into coded computer instructions.- Works with IT management team on project priorities and deliverable timelines.- Interfaces with all IT and business teams to determine/communicate impacts as needed.- Independently analyzes issues, uses judgement to make decisions, and takes necessary action.- Reviews work of other team members for accuracy, adherence to standards, optimization.- Provide on call support as needed and provide direction to other on call resources as needed.- Participate and perform production deployments of DB/SSIS/SSRS related artifacts.- Other duties as assigned.Minimum Skills and Competencies:- Bachelor's degree or equivalent years of experience in related field.- Minimum 5 years of experience at a similar position is required.- Expert in SSIS, SSMS- Expert in T-SQL (Structured Query Language).- Advanced knowledge of relational databases.- Expert in SSRS reporting- Demonstrated knowledge of data warehouse concepts (data normalization, star schema, etc.)- Demonstrated knowledge of all phases of Software Development Lifecycle and Agile Scrum methodology.- Excellent interpersonal skills with the ability to communicate effectively and establish working relationships with individuals at varying levels within the organization.- Ability to work in an open team environment