Data Analyst

American Dental Education Association; Washington (District of Columbia); On-site; USD 70,000 - 80,000; Full time

Benefits offered by this job

Health insurance

Vision insurance

Dental insurance

Life insurance

Wellness benefits

35-hour work week

Paid leave

403(b) retirement plan

Job summary

American Dental Education Association (ADEA) seeks an experienced Data Analyst to maintain the ADEA Data Portal and research data platform, ensuring reliable data collection, analysis, and reporting. The role supports the Office of Educational Services and reports to the Senior Vice President, Policy and Education Research.

Based in Washington, DC (hybrid), the analyst collaborates with vendors and internal teams to keep data systems current, dashboards accurate, and documentation complete while

Qualifications

• Bachelor’s degree with five years of professional work experience, including three years in quantitative research, data science and/or database management; or master’s degree with three years of relevant experience.
• Higher education research experience in dental education/medical education preferred.
• Proficiency in Python and SQL.
• Working knowledge of statistics and ETL techniques.
• Familiarity with data management, data cleaning, and data validation processes.
• Hybrid schedule: onsite at Washington, DC office Monday through Thursday; remote Fridays.

Responsibilities

• Collaborate with external vendors to maintain and update the ADEA Data Portal and dashboards for data security and privacy.
• Create additional dashboards and provide technical assistance to members using the Data Portal.
• Upload additional years of data to the research data platform and ensure consistency across years and complete documentation.
• Conduct data collection using surveys, censuses, administrative data collections, and data scraping.
• Process, validate, and analyze collected data.
• Develop spreadsheet-based reports and interactive visual reports.
• Coordinate with ADEA members to refresh contacts and support data submission.
• Automate data collection and processing; develop algorithms to improve analysis efficiency.
• Communicate issues promptly and suggest solutions with teammates.

Job description

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.