The Association of American Medical Colleges is looking to solve the problem of collecting, maintaining, and reporting Faculty Roster data about members and constituents, including data about faculty retention rates, faculty promotion rates, and faculty counts across department classification, degrees, and ranks.
Requirements
- Experience with quantitative, qualitative, and logical reasoning; self-directed knowledge acquisition and application; programming, database design, data security, data standards, data processing, relational databases, data instrument construction, data visualization, and report writing
- Experience in data collection, analysis, and reporting in small to large organizations where data is critical to delivering on strategy, mission, and services to members and constituents
- Skill in producing and maintaining programming and databases for collecting data, importing data, managing data, checking data, linking data, analyzing data, reporting data, and distributing data, using tools such as SQL, PL/SQL, PostgresSQL, VBA, Python, HTML, HighCharts, JavaScript, and Verint
- Skilled in collaboration tools such as Outlook, Word, Excel, and Teams, and cloud platforms such as Oracle and AWS
- Working knowledge of association management systems is a plus
- Experience with tools such as SQL, PL/SQL, PostgreSQL, VBA, Python, HTML, and JavaScript
- Experience with data visualization tools such as HighCharts
Responsibilities
- Deliver high-quality and timely execution of assigned data collections and reports
- Develop, implement, and maintain documentation and programming related to the production of data collections, standard reports, research reports, external/internal ad hoc reports, and other analytical offerings
- Monitor the soundness, timeliness, impactful, efficiency, and security of data collection and data reporting services
- Produce and maintain programming and databases for collecting data, importing data, managing data, checking data, analyzing data, reporting data, and distributing data, using tools such as SQL, PL/SQL, PostgreSQL, VBA, Python, HTML, and JavaScript
- Collaborate with IT colleagues when a data collection tool or data reporting tool is an IT-maintained application or when data collections and their associated analytical offerings have some other intersection with IT services
- Serve as a Data Asset Owner for data assets, obtaining all needed Data Asset Owner training and serving in a way that is consistent with AAMC policies and procedures
- Provide day-to-day support to data collection participants, report recipients, and other users with log-in issues, content questions, reminders, extensions, quality control checks, or similar operational concerns
Other
- Bachelor’s degree or equivalent experience
- Preferred: A master’s degree or doctoral degree would be preferred, with coursework in quantitative reasoning and qualitative reasoning
- 3-5 years of related work experience
- Ability to work in a collaborative environment
- Ability to manage time and resources effectively
