Data Analyst at National Resident Matching Program

About the OrganizationThe National Resident Matching Program® (NRMP®) is a private, not-for-profit organization established in 1952 to provide a uniform date of appointment to positions in graduate medical education (GME) in the United States.  The NRMP is not an application processing service; rather, it provides an impartial venue for matching applicants’ and programs’ preferences for each other consistently.  The NRMP conducts the annual Main Residency Match encompassing 40,000 applicants for more than 25,000 positions in core residencies as well as Matches for fellowship positions in 55 subspecialties through its Specialties Matching Service®.POSITION SUMMARY  The NRMP is looking for a Data Analyst. This role will be responsible for the preparation of reports, publications and data sets for the NRMP and its constituents.  This role will be engaged in building new reports, maintaining existing reports, and using SQL proficiently in data preparation and analysis. Security and Privacy responsibilities are identified in the Acceptable Use Policy (AUP), which applies to all users, roles, and NRMP resources. EMPLOYEE VALUE PROPOSITIONRewards: see our engagement package here https://www.nrmp.org/about/careers/Opportunity: This is an exciting role that plays a pivotal role in delivering key publications to the communityOrganization: The NRMP is a mission-based global provider of matching services incorporated in 1952People: A collaborative IT culture with a supportive team and genuine camaraderie to fuel usWork: Work on cutting edge technology to deliver our mission; Work from anywhere in the continental United StatesESSENTIAL DUTIES AND RESPONSIBILITIES (Duties that occupy a major portion of time and importance in the job)Analyze and manage all reports across the enterprise throughout SDLC.Analyze and create datasets using SQL to uncover trends and drive actionable insights.Develop and test queries, stored procedures, functions, and packages to deliver accurate data intensive reports and data sets.Track, respond and deliver on incoming reporting and data requests from internal and external constituents and provide status updates to leadership.Actively engage in performance tuning of reports and query optimization.Perform unit testing of data and reports and engage in UAT at all stages.Work on periodic maintenance, enhancement and defect fixing in testing and UAT environment.Other responsibilities as assigned Key RequirementsA successful candidate will have the expertise and skills described below.EDUCATION, PREVIOUS EXPERIENCE AND TRAININGAt least 3 years of work experience in data analysis/reporting in a full-time, salaried role within a corporate environmentAt least 3 years of experience working in cross-functional teams and collaborating with business stakeholders in support of departmental and/or multi-departmental report initiatives.A bachelor's degree in computer science, mathematics, statistics, economics, finance or related field preferred.Familiarity with undergraduate and graduate medical education and the residency selection process is highly desirable.TECHNICAL KNOWLEDGE AND SKILLSStrong experience with SQL, PL/SQL, and/or other programming tools building complex queries.Strong experience with python as a scripting language for ETL processes and data integration.Adept in agile methodologies and capable of applying DevOps principles.Experience with Crystal Reports is a plusExperience with Tableau, Power BI, Amazon Quicksight or other equivalent business intelligence tools is a plus.Excellent verbal and written communication skills INTERPERSONAL SKILLS AND CHARACTERISTICSBe highly creative and collaborative. An ideal candidate would be expected to collaborate with cross functional teams to define the business problem, refine the requirements, and design and develop data deliverables accordingly.Be a confident, energetic self-starter with strong interpersonal skills.Have good judgment, demonstrate initiative, and demonstrate commitment to high standards of ethics, regulatory compliance, customer service, and business integrity.Have data visualization, statistical analysis and documentation skillsBe detail-orientated, have excellent organizational capabilities, strong communication, speaking and writing skillsProfessional data presentation skillsAdapts to change, views difficult situations and problems as opportunities for improvement.Actively embraces change instead of emphasizing negative elements.  INTERACTIONS Internal:Daily contact with NRMP staff.Occasional interaction with members of the Board of Directors and external consultants.External:Interaction with external constituents to process reporting and data requests.Interaction with third-party software and IT vendors. ADA SPECIFICATIONSThis position is primarily remote and sedentary; however, this position will be expected to attend meetings in the Washington, DC headquarters or other locations with sufficient notice and as directed by the CEO. There may be occasional overnight travel and duties may require some bending and lifting. The above statements describe the general nature and level of work being performed by the individual(s) assigned to this position. They are not an exhaustive list of all duties, responsibilities, and skills required. NRMP is an equal opportunity employer and values diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability or other protected class status. In addition, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.The incoming salary range for this role is $73,790-$84,554, with growth potential from $73,790 to $93,270. Salary is commensurate with experience.Visit Careers | NRMP to view our competitive benefits and engagement package.