Junior Database Developer

Job not on LinkedIn

November 4

Apply Now

Receive Emails with Similar Jobs

ALTUS Receivables Management

WebsiteLinkedInAll Job Openings

Finance • Insurance • Technology

ALTUS Receivables Management is a leading provider of audit and recovery services specifically tailored for the property and casualty (P&C) insurance industry. The company utilizes advanced technology and analytics to help clients identify and recover cash leakage through various services, including subrogation audit and recovery, deductible audits, and premium recoveries. With a proven track record and a focus on compliance and data security, ALTUS serves many major insurance carriers and offers deep expertise in the complexities of the insurance sector.

201 - 500 employees

💸 Finance

📋 Description

• Requirements gathering: Work with stakeholders (clients/internal team) to understand the requirements of the data migration project • Develop ETL (Extract/Transform/Load) processes for new customers • Data extraction: Extract the data (various formats) from the source system and prepare it for migration to the target system • Data analysis – Reviews/Validates the data for consistency and completeness • Data mapping: Develop documentation that map relationships between the data in the source and target systems • Data loading: Load the data into the target system and ensure that the data is properly formatted and integrated with the target system • Data testing: Test the data to ensure that it has been accurately and completely migrated • Troubleshooting: Resolve any issues that arise during the data load process • Performance optimization: Ensure the data load process is optimized for performance • Maintain access and permission of database users • Write SQL and SOQL commands, extended stored procedures and SSIS packages

🎯 Requirements

• Bachelor’s degree (BA/BS) from four-year college or equivalent experience • Minimum of 3 years of SQL Server programming experience • Ability to work in all phases of database management • Proficiency using Microsoft Structured Query Language (SQL), PowerShell, MS SQL Server Database (2016 to current) • Knowledge of SOQL syntax for Salesforce and using tools like DBAmp (CData) to extract Salesforce data via SQL Server • Knowledge of insurance industry terminology a plus

🏖️ Benefits

• Benefit package with health, dental, vision, life and disability coverage options • 401(k) retirement plan option with company matching • Generous paid time off policy - start with 18 days per year • Paid holidays immediately upon hire - 7 standard holidays & 2 floating holidays of your choice