Who We Are: It all starts with purpose.

We are a purpose-driven nonprofit with a dynamic staff culture.

With a meaningful purpose, motivated staff, and excellent benefits, working here will definitely have you smiling! The ADA’s headquarters is located just steps from Chicago’s Magnificent Mile and close to public transportation. 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 aTop Workplace by the Chicago Tribunein 2019 and 2021!Come join our team!

Job Responsibilities:

Data Engineer will oversee the integration and management of data in our Salesforce and Azure-based SQL data warehouse environment. They will be responsible for designing, implementing, and maintaining robust ETL processes, ensuring high data quality, and optimizing data integration strategies to support our business intelligence and analytics needs.

Must Have:

Applicants must be legally authorized to work in the United States and should not now or in the future require sponsorship for employment.
Bachelor's degree in Computer Science, Information Technology or related
Minimum 3 years experience in data engineering or a similar role, specifically in Azure environment; or 7 years of experience in lieu of degree
Previously worked in a salesforce environment
Excellent problem-solving, analytical, and communication skills
Knowledge of ETL concepts, data warehousing methodologies, and cloud computing
Strong understanding of SQL and data modeling
Ability to lead projects and work collaboratively in a team environment
Proficiency in Microsoft Office Suite (Word, Excel, and PowerPoint), Azure Data Factory, Azure SQL Database, and other Azure data services

Nice to Have:

Certifications in Salesforce and Azure cloud technologies
Experience with BI tools like Power BI, Tableau, or similar
Knowledge of Python, Java, or other scripting languages
Knowledge of Purview

Just a few of the benefits offered to employees:

Promotes Work/Life Balance
Hybrid Work Schedule (2-3 days from home)
Health insurance/ dental reimbursement plan
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

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 recruiting@ada.org.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.