Senior Database Developer

JOB RESPONSIBILITIES:

• Maintain, continue to develop, and help instruct other D&A staff on understanding technical processes with skills in data manipulation, database access and development, ETL, data integration, application development, and database development tools.
• Have a solid understanding of database modelling and design, and understand the concepts of ACID, data normalisation, relational integrity, and rules-based data management.
• Create new, or modify existing, database tables, indexes, constraints, types, views, functions, triggers, stored procedures and scripts. Fully test and verify all new and modified database objects and processes.
• When needed, develop new database components and data management tools and/or make modifications to existing structures, processes and applications based on requirements provided by the Business Analytics team or the department manager/director.
• Perform monthly, semi-annual, and annual data processing, database loads, and data verification. Apply changes, corrections and overrides as needed.
• Automate recurring data collection/manipulation/load/verification processes.
• Ensure that all production data products are produced in an accurate and timely manner.
• Verify database contents reconcile with comparable reports and/or company financials, as well as table content (including counts, amounts and descriptive information) is reasonable and correct.
• Track down data anomalies, financial discrepancies, invalid values, data integrity or relational issues, and performance concerns, and determine the appropriate corrective course of action.
• Create or modify automated backup, clean-up, load, sync, or other utilities and routines.
• Work with Business Analytics staff on specific data management and/or analytical applications as directed by their supervisor.
• Perform other duties as assigned by their supervisor or the department manager/director.

The ideal candidate will have:

• A Bachelor s degree in Management Information Systems, Computer Science, Mathematics, or a related field.
• 2 to 5 years of progressive experience in database development, data processing, and/or data-driven applications.
• Experience in the insurance or risk management industry is a plus.

Minimum Skills & Qualifications:

• Strong proficiency in writing and optimizing SQL expertise.
• Experience with SQL Server or comparable RDBMS platforms (e.g., Oracle, PostgreSQL).
• Knowledge of database modeling and optimization techniques.
• Familiarity with ETL tools, techniques, data management applications, and reporting/analytics software.
• Ability to analyze complex datasets and translate business requirements into technical solutions.

Desirable Skills & Experience:

• Advanced experience with T-SQL and SQL Server Management Studio (SSMS).
• Experience using version control tools and managing code in team environments.
• Experience with automation and scripting (e.g., Python, PowerShell).
• Experience developing user interfaces or admin tools to interact with data systems.
• Exposure to business intelligence tools such as Qlik (preferred), Power BI, or SSRS.
• Experience working with insurance, risk management, or claims data.