What are the responsibilities and job description for the Data Analyst position at Castel Communications, LLC?
Well-established Company is searching for a full-time, on-site in office Data Analyst 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.
4. Work Experience and Background:
- 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.
5. Required functional skills:
- Strong analytical skills with the ability to understand complex data structures and relationships.
- Ability to multi-task and prioritize responsibilities assigned.
Job Type: Full-time
Pay: $60,000.00 - $90,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- AD&D insurance
- Dental insurance
- Dependent health insurance coverage
- Disability insurance
- Health insurance
- Health savings account
- Life insurance
- Paid sick time
- Paid time off
- Prescription drug insurance
- Vision insurance
Experience:
- SQL: 1 year (Preferred)
Ability to Commute:
- Buffalo, NY 14225 (Preferred)
Work Location: In person
Salary : $60,000 - $90,000