Data Administrator/ETL Developer
American Dental Association – Health Policy Institute
Who we are: It all starts with purpose.
With a meaningful purpose, motivated staff and excellent benefits, working here will definitely have you smiling! With more than 400 colleagues, the ADA staff are some of the most talented people in the Chicago, Washington D.C. and Maryland area. We were named a Top Workplace by the Chicago Tribune in 2019 and 2021! Plus, you’ll be working in the ADA’s Health Policy Institute (HPI) team, the go-to source for dental care market information in the U.S. for researchers, policymakers and the news media. HPI generates and disseminates impactful, impartial, and rigorous research that inform critical debates in the dental care arena. Come join us!
About the job:
Are you our next big data expert? The Data Administrator/ETL Developer will be responsible for building, improving and updating key data sources used by HPI researchers, working with dental claims and other large datasets, and taking on a leadership role in the development of HPI’s dentist office database. This position will liaise between HPI and colleagues in the Technology division in the development of new data assets. This role will also work with researchers in the team on specific data queries, providing periodic updates on key statistics from multiple data sources, and performing other activities as needed, including survey reporting and drafting research articles.
We’re looking for a teammate with the following experience and abilities:
Bachelor’s degree in statistics, economics, data analytics, epidemiology, data science, computer science or other quantitative disciplines, with 3 years of proven experience in building large datasets using multiple input files and managing and analyzing claims data or similar large datasets. In lieu of a Bachelor's degree, 7 years of experience is required.
• Proficiency in programming languages such as Microsoft SQL Server, R, and/or Python.
• Proficiency in SAS, STATA, or similar programing language.
• Ability to shift between multiple projects and to work with colleagues at different levels of the organization.
• Passion for developing innovative ways to improve processes and deliverables.
• Excellent communication, analytical and interpersonal skills.
• Familiarity with medical or dental insurance claims datasets (e.g., IBM Watson, Fair Health, Medicaid) and publicly available datasets (e.g., Census data, MEPS, NHANES, NHIS).
• Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint)
And these are also great “nice-to-haves” that would bring value to our team:
• Experience with ETL tools such as Business Objects Data Services or Azure Data Factory.
• Proficiency in Qualtrics or similar online survey tools
The ADA provides excellent benefits to its employees, including: a 37.5 hour work week, flexible work schedule, health insurance, dental reimbursement, ample paid time off, 401(k), pension, Flexible Spending Account, life insurance, tuition reimbursement, paid parental leave, pet insurance, student loan refinance, 2 days off to work at a charity event of your choice, and, most of all, an incredible group of colleagues!
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The American Dental Association is proud to be an Equal Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, sex, sexual orientation, gender, gender identity, gender expression, transgender status, sexual stereotypes, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. The American Dental Association is committed to providing reasonable accommodations for candidates with disabilities in our recruiting process. If you need any assistance or accommodations due to a disability, please let us know at firstname.lastname@example.org.