at American Dental Association in Chicago, Illinois, United States
Job Description
Description
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 a Top Workplace by the Chicago Tribune in 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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
EOE of Minorities/Females/Protected Veterans/Individuals with Disabilities
