Job Description

Job Description

Well-established Company is searching for a full-time, on-site in office SQL Developer for our Cheektowaga, NY office location.

1. Programming:

• Develop, maintain, and optimize SQL queries and scripts for data extraction, transformation, and loading (ETL) processes.
• Modify programming based on client requests or internal requirements.
• Troubleshoot and resolve issues related to data quality, performance, and integration.
• Develop and maintain documentation for database schemas, processes, and procedures.
• Develop new programs to meet client and/or internal needs.
• Assist with updates/configurations/patches on systems, when necessary.
• Maintain Test Database with Data Obfuscation
• Manage SOR/databases (encryption, functioning, backups, etc.).

2. Reporting: Design and implement reporting requested for all departments within the organization.

3. Data Transmission: Responsible for pulling, uploading and processing all client data files from client’s specified websites within the client specified time frame in an efficient and accurate manner.

• Manages collection and retention of evidence to document compliance with auditable requirements.

• To monitor for changes to procedure and exceptions to data for all incoming and outgoing data.

• A Degree in Computer Science or Management Information Systems.

• Advanced knowledge of multiple programming languages such as C+, C#, .NET, Python, Java, or VBA.

• Strong proficiency in SQL programming language with experience in writing complex queries and stored procedures.

• Understanding and/or knowledge of Data processes in the Collection Industry.

Required functional skills (skills need to complete the functions of job; i.e. project methodology, presentation experience, etc.

• Strong analytical skills with the ability to understand complex data structures and relationships.
• Ability to multi-task and prioritize responsibilities assigned.