Data Analyst

The American Dental Education Association (ADEA) is seeking to add an experienced Data Analyst to its team. The Data Analyst is responsible for maintaining the ADEA Data Portal, the ADEA research data platform and for analyzing, reporting and ensuring data integrity as part of different ADEA research projects. This position is supervised by the Senior Vice President, Policy and Education Research in the Office of Educational Services (OES). As a key member of the OES research team, you will be the technical lead for the maintenance of the ADEA Data Portal and the ADEA research data platform and will actively support ADEA’s research programmatic activities by fulfilling dental education data collection and analysis. Primary Responsibilities Work collaboratively with external vendors to maintain and update the ADEA Data Portal including but not limited to adding years of data to current dashboards; making necessary updates to the dashboards and the data portal website to maintain functionality, data security and privacy; and creating any additional dashboards, as necessary. Provide technical assistance to members as they utilize the ADEA Data Portal. Maintain the ADEA research data platform up to date, by uploading additional years of data and/or datasets in the current database, ensuring the consistency of the database across the years, the functionality of the database and that documentation is complete and up to date. Conduct data collection through surveys, censuses, administrative data collections, data scraping, etc. Process, validate and analyze collected data. Code and create spreadsheet\-based reports and interactive visual reports. Work with ADEA members directly to ensure updated contacts for the distribution of the data collection tools, the submission of their data in an efficient manner and the correction of missing/incorrectly input data. Collaborate with ADEA colleagues on automating data collection and processing and creating algorithms to make the analysis process more efficient. Communicate timely any issues encountered and provide suggestions for solutions. Work with colleagues across ADEA on tasks and projects, as necessary. Follow data privacy policies and comply with data protection regulations. Other duties as assigned. A bachelor's degree and five years of professional work experience, including three years of quantitative research, data science and/or database management experience; or a master's degree and three years of relevant experience. Higher education research experience in dental education/medical education preferred. Python and SQL proficiency. PowerBI and Qualtrics preferred. Working knowledge of statistics and ETL techniques. Familiarity with data management, data cleaning, and data validation processes. Ability to keep a variety of tasks on time. Attention to detail and meticulous focus on sensitive and time sensitive materials and activities. Ability to work effectively in a diverse team environment and the ability to collaborate well with others from different backgrounds, including vendors, clients and/or members. * Must be able to work onsite at ADEA’s Washington, D.C. office Monday through Thursday as part of a required hybrid schedule; remote work is permitted on Fridays. As part of the selection process, candidates will be invited to complete a take home coding exercise using one of the following tools: Python, SAS, SPSS, or R (please note that access to the software is not provided). Candidates will have 24 hours to complete the exercise, which is designed to assess coding proficiency, efficiency in working with data and the ability to communicate results clearly and accurately. This position's salary range is $70,000 to $80,000\. In addition to a rewarding and purposeful mission, ADEA offers you a collaborative team environment with competitive salary and excellent benefits, including health, vision, dental and life insurance, wellness benefits, a 35\-hour work week, generous paid leave and a 403(b) retirement plan with 10% employer contribution. Our office is strategically located in in the heart of DC's Downtown East End neighborhood, known for its trendy shopping, gourmet dining, and a dynamic entertainment experience and conveniently located across from the Metro Center station. For more information and to apply online, visit www.adea.org. The American Dental Education Association (ADEA) is The Voice of Dental Education. Its members include all 78 U.S. and Canadian dental schools, over 800 allied and advanced dental education programs, 66 corporations and more than 20,000 individuals. The mission of ADEA is to develop an inclusive, future\-ready oral health workforce prepared to improve the health of all people and communities through leadership, education , and collaboration. ADEA's activities encompass a wide range of research, advocacy, faculty development, meetings and communications, including the esteemed Journal of Dental Education, as well as the dental school admissions services ADEA AADSAS, ADEA PASS, ADEA DHCAS and ADEA CAAPID. ADEA is an Equal Opportunity Employer. The Associations EEO policy prohibits discrimination in employment on the basis of race, color, religion, age, sex, national origin or ancestry, marital status, personal appearance, sexual orientation, gender identity or expression, pregnancy, child birth or related medical conditions, family responsibilities, genetic information, political affiliation, matriculation, veteran status, union affiliation, disability, credit information, status as a victim or family member of a victim of domestic violence, a sexual offense, or stalking, or any other legally\- protected characteristic in accordance with federal or local law (the Protected Categories). EEO applies to all terms and conditions of employment, including but not limited to recruitment, hiring, training and development, promotion, termination, compensation, and benefits.