The following describes the various aspects of the designated job. Some or all of these aspects may be changed over time, with or without notice, at the sole discretion of the ACGME.

Applicants must be currently authorized to work in the United States (US) on a full-time basis. The ACGME will not provide employment sponsorship for this position (e.g., H-1B Visa or other US employment authorization).

Title:                      SQL Developer

Department:          Department of Information Services 

Reports To:           Director, Data Analytics, Quality, and Reporting

Work Schedule:     Full Time

Job Summary

The SQL Developer supports existing ACGME applications, with a special emphasis on database programming, including SQL Server Integration Services (SSIS) development and developing reports using Microsoft SQL Server Reporting Services (SSRS).

Applications and Data Analysis Overview

The Applications and Data Analysis group in the Department of Information Services is responsible for the development and ongoing maintenance of all data collection systems that deal with graduate medical education institution and program accreditation, recognition, and outcomes. The group also provides project management, quality assurance testing, analytical reporting, and support for these data systems and data acquisition tools. Currently the department is taking a leadership role in the visual display of data and its use in accreditation.

Primary Duties and Responsibilities

• Develop and maintain SSRS reports that can be integrated into existing reporting structure and applications.
• TSQL programming, including building views, stored procedures, and database functionality for reporting needs.
• Create and maintain applications, including coding, testing, debugging of web-based applications.
• Design and implement ETL functionality using SSIS.
• Monitor/maintain ACGME applications to ensure availability, and quality performance, which involves accessing the systems through the internet with attention to response time, using the SQL or Windows monitor to assess the performance of the servers and other systems. If problems are found, either through analysis or user alerts, the developer is responsible for resolving them.
• Integrate SSRS reports into existing MVC application using ASP.NET MVC and C#.
• Contribute on standing and ad-hoc development teams in support of the data analysis and development teams, as well as other ad-hoc projects as assigned by the director.
• Collaborate with ACGME Product Managers and Leads to identify and develop application product requirements for developers; perform root-cause analysis on any application issues identified.
• Work with the data team in the design/maintenance of a datawarehouse, data integration, and business intelligence architecture needed to meet business needs and requirements. 
• Communicate with users to resolve problems and improve performance.
• Perform related work as assigned.
• Use Git and TFS for source control of code, as well as branching, merging, and deployments as needed.
• Provide backup support to database administrator for tasks such as backup/restore, index maintenance, availability group support, etc.
• Maintain database documentation.
• Other duties as assigned.

Education, Knowledge, Skills, and Abilities

Required

• An earned degree from a college or university.
• Three years of relevant work experience.
• Demonstrated competency with Microsoft SQL Server Reporting Services (SSRS). 
• Programming experience in Microsoft technologies, including ASP.NET, MVC, C# 4.0 or above, using Microsoft Visual Studio 2017 or above.
• Demonstrated proficiency in the design and development of database systems using Microsoft SQL Server 2016 or above, including database design, development of views, and stored procedures.
• Experience using Object Oriented Programming (OOP) methodologies and patterns, as well as the ability to refactor existing code.
• Working experience with Windows Server, Internet Information Server, and Windows 10.

Preferred

• Excellent written and oral communication skills.
• Experience implementing triggers, replication and DTS/SSIS packages.
• Experience with SSIS.
• Aptitude to learn new software quickly.
• Detail-oriented with a strong sense of the need for accuracy and the ability to demonstrate excellent analytical and problem-solving skills.
• Experience using GIT for source code control. 

Equipment

Position requires the significant use of standard office equipment, such as a computer, keyboard, mouse, photo copier, fax machine, and telephone.

Working Conditions

Most of the work of the SQL Developer is normally done in the ACGME office with the typical physical demands of an office environment. During the COVID-19 pandemic, ACGME employees are working remotely until further notice. The SQL Developer will need to be able to efficiently and effectively work remotely.
 
Physical Requirements
 The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job.

While performing the duties of this job, the SQL Developer:

• Will frequently be required to sit and work for extended periods of time at computer terminal using various computer programs and other computer tools.
• Will frequently be required to participate in meetings via Zoom or other video conferencing platforms. Note, this is particularly relevant while working remotely.

The ACGME is an Equal Opportunity/Affirmative Action/Pro Disabled and Veteran Employer. The ACGME welcomes differences in the form of gender, race, ethnicity, disability, geography, socioeconomic status, age, politics, religion, philosophy, sexual orientation, gender identity, or expression status. All applicants who share this goal are encouraged to apply.