SQL Developer

SQL Developer and Application Support Specialist

Job Title: SQL Developer and Application Support Specialist

Position Type: Consultant

Location: New York

Work Arrangement: Hybrid; 3 days in New York office

Job Description:

We are seeking an experienced SQL Developer with strong application support skills. The ideal candidate will have at least 7 years of experience in database management, report development, and ETL processes, along with a proven track record in providing technical support for applications. This role requires a proactive, results-driven individual who can collaborate with business teams and technology experts to enhance both applications and systems.

Responsibilities:
• Gather and document business requirements from stakeholders, and analyze business processes to identify areas for improvement.
• Provide technical support for applications, including troubleshooting and resolving issues in a timely manner.
• Design, develop, and maintain SQL databases and database objects (tables, views, indexes, stored procedures, functions, etc.).
• Optimize database performance through indexing, query optimization, and other techniques.
• Ensure data integrity and security through proper design and implementation of database constraints and permissions.
• Develop and maintain Power BI dashboards and reports using SSRS.
• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
• Required to work in the New York office 3 days a week.

Qualifications/Skills:
• A bachelor’s degree in Computer Science, Information Technology, or a related technical field.
• At least 7 years of proven experience as an SQL Developer.
• Proficiency in writing and optimizing complex SQL queries and stored procedures.
• Experience with data analysis and reporting tools (e.g., Excel, SQL, SSRS, Power BI).
• Extensive experience with troubleshooting application support issues.
• Strong knowledge of software development life cycles and methodologies.
• Experience with Workday or any HR platform is a plus.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with stakeholders at all levels.
• Ability to work independently and as part of a team.
• Strong organizational skills and the ability to multitask and prioritize effectively.