Senior Research & Data Analyst is responsible for the development, collection, maintenance, and operations for a portfolio of assigned standard data collections and reports including quality metrics, utilization metrics, work effort, and financial metrics as appropriate. Supports and coaches junior staff for complex tasks and collaborates with technical leaders for guidance related to enhancing data operations and services. Develops, implements, and evolves programming and documentation for assigned data and reports, including programming and documentation about what members or constituents are eligible to participate and have access to assigned data collections and reports. Collaborates and consults with internal and external partners on enhancements to data collections and reporting systems.  

• Be responsible for data assets and systems related to the National GME Census in GME Track, the FACTS tables, the ERAS National Statistics tables, the Primary Care Loan Report, the Report on Residents, and additional data and reporting assets as assigned from other DOS teams and data teams from other clusters. As appropriate, mentor less senior colleagues on these data assets and systems.

• Develop, collect, verify, maintain, and report data about and from members and constituents.

• Develop, implement, and update programming and documentation for assigned data and reports, including programming and documentation about what institutions and individuals are eligible to receive the corresponding data collections and data reports.

• Produce and maintain programming and databases for collecting data, importing data, managing data, checking data, engaging with members and constituents as required for data quality questions, linking data, analyzing data, reporting data, and distributing data, using AAMC IT approved tools such as SQL, PL/SQL, PostgreSQL, VBA, Python, HTML, HighCharts, JavaScript, and Verint.

• Mentor less senior colleagues to expand in their knowledge of this work.

• Monitor the soundness, timeliness, impact, efficiency, and security of data collection and data reporting services. Monitoring occurs through, for example, performing data quality checks and investigating discrepancies, verifying, and resolving data issues. 

• Develop and/or maintain recurring data collections and administer data collections to members and constituents. 

• Write and maintain office manuals, runbooks, and similar materials that describe the procedures for running data collection and data reporting services; review materials from less senior staff in a collegial manner. 

• Collaborate with IT colleagues to support IT-maintained applications, data collections, and integration with other data and analytical offerings. Coach and assist junior staff for IT-related activities such as developing requirements and user acceptance testing. 

• Support and coach junior staff on more complex tasks and for addressing technical and process issues and improvement opportunities.  

• Engage with data collection participants, report recipients, and other users with content questions, reminders, extensions, quality control checks, or similar operational concerns.
  
  

• Consult with colleagues and constituents (including, but not limited to, data respondents, report users, subject matter experts, researchers, and IT staff) on ways to enhance data collections, standard reports, research reports, external/internal ad hoc reports, and other analytical offerings. Support junior staff and unit supervisors to synthesize and prioritize the input from colleagues and constituents.

• Contribute to IT initiatives related to infrastructure changes, data access and security, and system modernizations and updates, providing support for junior staff as well as alerting unit supervisors about risk and benefits.  

• Represent the unit, the cluster, and the AAMC data community in internal and external discussions around data collection, analytics, and reporting. 

• Maintain accurate financial and timekeeping records to support ongoing prioritization, enterprise portfolio management, and impact analyses as required for assigned data assets. 

• Apply knowledge and experience to solve problems and to identify root causes of onetime or recurring issues and recommend solutions. 

• Be a good steward of AAMC time and resources; escalate potential issues early enough to ensure that collaboration with other colleagues will result in on-time, high-quality, impactful, efficient, and secure data services. 

• Help with other data assets and their associated analytical offerings, as required. 

• Manage the tracking of internal and external data requests across the AAMC. This duty includes reviewing data requests, fulfilling data requests, and triaging data requests to other staff as appropriate.