Data Analyst

The American Dental Education Association (ADEA) is seeking an experienced Data Analyst to help maintain the ADEA Data Portal and the ADEA research data platform, supporting dental education research through reliable data collection, analysis, reporting, and data integrity. This role supports the Office of Educational Services (OES) and is supervised by the Senior Vice President, Policy and Education Research . Based in Washington, DC (hybrid) , you will collaborate with vendors and internal colleagues to keep data systems current, ensure dashboards and documentation remain accurate, and provide technical support to members using ADEA tools. What you will do Collaborate with external vendors to maintain and update the ADEA Data Portal , including adding years of data to current dashboards and updating the dashboards and portal website to preserve functionality and data security and privacy . Create additional dashboards when needed and provide technical assistance to members using the ADEA Data Portal. Keep the ADEA research data platform current by uploading additional years of data and/or datasets, ensuring consistency across years, maintaining database functionality, and ensuring documentation is complete and up to date. Conduct data collection using methods such as surveys , censuses , administrative data collections , and data scraping . Process, validate, and analyze collected data. Code and create spreadsheet-based reports and interactive visual reports . Work directly with ADEA members to ensure updated contacts for distributing data collection tools, support efficient data submission, and help correct missing or incorrectly entered data. Collaborate with colleagues on automating data collection and processing and creating algorithms to improve the efficiency of analysis. Communicate issues in a timely manner and provide solution suggestions, while collaborating with teammates across ADEA on assigned tasks and projects. Follow data privacy policies and comply with applicable data protection regulations . Perform other duties as assigned. Minimum qualifications Bachelor’s degree and five years of professional work experience, including three years of quantitative research, data science and/or database management experience; or master’s degree and three years of relevant experience. Higher education research experience in dental education/medical education is preferred. Proficiency in Python and SQL . Working knowledge of statistics and ETL techniques . Familiarity with data management , data cleaning , and data validation processes. Strong ability to keep multiple tasks on schedule. Attention to detail and meticulous focus on sensitive, time-sensitive materials and activities. Ability to work effectively in a diverse environment and collaborate with vendors, clients, and/or members. Hybrid schedule requirement: must be able to work onsite at ADEA’s Washington, D.C. office Monday through Thursday ; remote work is permitted Fridays . Tools and technologies Python, SQL PowerBI, Qualtrics (PowerBI and Qualtrics preferred) ETL Additional technologies: SAS, SPSS, R Compensation and benefits Salary: USD 70,000 - 80,000 per year Health insurance Vision insurance Dental insurance Life insurance Wellness benefits 35-hour work week Generous paid leave 403(b) retirement plan with 10% employer contribution Selection process Candidates will be invited to complete a take-home coding exercise using Python , SAS , SPSS , or R (software access is not provided). Candidates will have 24 hours to complete the exercise. It is designed to assess coding proficiency, efficiency with data, and the ability to communicate results clearly and accurately. #J-18808-Ljbffr