SQL Data Engineer Developer

SQL Data Engineer – Developer   The Global Actuarial Systems team is a small, agile group of technology enthusiasts.  We are tasked with solving the complex data needs of both US and International reserving actuaries. Our group is responsible for collating data from several disparate systems and platforms and providing analytic solutions for the world's largest publicly traded property and casualty insurer. Our systems are the foundation for the loss triangles which are reported externally, and which ensure we have the capital to pay future claims. This position is for a full-time data engineer in either our San Pedro Garza Garcia, N.L. office.   Responsibilities  

• Create and implement procedures and functions using SQL
• Examine existing SQL queries for potential enhancements
• Design, build, and maintain efficient, reusable, and reliable code
• Set up automated processes, when required, for handover to the Deployment team
• Document current or new processes
• Ensure the best possible performance and maintain the quality and responsiveness of applications
• Modernization of the existing IBNR application responsible for writing $30b to the financial ledger each month
• Implement BI processes so end users can quickly and easily derive value from billion row datasets
• Deliver quality solutions on time and within budget, following SDLC best practices in the documentation of design specifications and unit test plans
• Provide on-call production support monthly during the book-close period
• Use Service Now to create and manage change requests

  Qualifications  

• 4+ years SQL Server development experience
• Knowledge of creating SQL queries based on a specified structure and syntax
• Strong MSSQL development skills (SQL Server, SSIS, SSRS)
• Experience with DevOps and GIT
• Solid understanding of stored procedure generation, debugging, and execution.
• Ability to deal with complicated database queries
• Experience with Agile methodologies, prioritizing backlog, etc. a plus.
• Capability to work on concerns raised by the customer
• Enthusiastic about work and code quality
• Extensive technical analysis and investigative capabilities
• Excellent time management and problem-solving abilities
• Learning mindset and team player
• Exposure to BI solutions (Power BI/Cognos/etc)
• Comfortable interfacing with end users
• Result/Solution-Oriented individual who can work/learn in a fast-paced environment.
• Actuarial reserving experience or experience developing actuarial applications in the insurance industry are a plus

If you apply for this opportunity we will get you resume and its contain personal data whose treatment has been authorized by its owner for Digital OnUs, S. de RL de CV (the "Company”). If you are not the owner of this information or have no relation whatsoever with the subjects treated in it, you are requested in the most attentive way not to make copies of it and / or its attached files and delete it immediately, under the risk of being considered as responsible for the unauthorized treatment of personal data in accordance with the Federal Law on Protection of Personal Data Held by Private Parties, its Regulations, and other applicable regulations. If you are the owner of personal data in possession of the Company and wish to obtain further information regarding the processing of your personal data or the exercise of your ARCO rights, please consult our integral privacy notice on the website https://www.digitalonus.com/privacy-policy/