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 Department of Information Services’ Applications and Data Analysis group is responsible for the development and ongoing maintenance of all data collection systems for residency program accreditation 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 group 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 and maintain ACGME applications to ensure availability, and quality performance. This 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 these issues. Integrate SSRS reports into existing MVC application using ASP.NET MVC and C#. The SQL Developer will 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 and perform root-cause analysis on any application issues that are identified. Work with data team in the design/maintenance of a Datawarehouse, data integration, and business intelligence architecture 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 College degree and 5+ years of relevant work experience preferred. Excellent written and oral communication skills required. Demonstrated competence with Windows Server 2016, Internet Information Server, and Windows 10 required. Programming experience in Microsoft technologies, including ASP.NET, C# 4.0 or above, Microsoft MVC (model/view/controller pattern) preferred. Must have 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 implementing triggers, replication, and DTS/SSIS packages a plus. Must have demonstrated competence with Microsoft SQL Server Reporting Services (SSRS); experience with SQL Integration Services (SSIS) a plus. Must have experience using Object Oriented Programming (OOP) methodologies and patterns, as well as the ability to refactor existing code. Must have the aptitude to learn new software quickly. Must be detail-oriented with a strong sense of the need for accuracy and the ability to demonstrate excellent analytical and problem-solving skills. Must have working knowledge of Visual Studio.Net 2019, including using Team Foundation Server (TFS) with GIT. Equipment Position requires the significant use of standard office equipment, such as a computer, keyboard, mouse, photo copier, fax machine, telephone, etc. 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 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.