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:
The Senior Data Architect will lead the design and implementation of scalable data warehouse solutions. This role involves integrating data from platforms like Salesforce and NetSuite into Azure Synapse, optimizing performance and ensuring data integrity. The ideal candidate will possess strong SQL skills, a solid understanding of data modeling, and the ability to mentor and lead cross-functional teams while staying updated on the latest Azure Synapse advancements. Collaboration with different internal and external development teams as well as business users will be integral, involving understanding data requirements, designing efficient data models, and implementing solutions to facilitate effective data analysis and reporting.
Must Have:

• Bachelor's Degree in Computer Science, Management Information Systems, or similar
• 10 years minimum experience with Azure cloud services, particularly Azure Data Factory, and related services including Synapse Dedicated Pool, Azure DevOps CI/CD Git Pipeline Deployment, Key Vault, Functions, and ADF Linked Services; Or 14 years of experience in lieu of degree.
• Proficiency in T-SQL, Azure PowerShell, and scripting languages for data manipulation and automation
• Excellent communication and collaboration skills to work effectively with cross-functional teams
• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions
• Knowledge of Power BI architecture, including Datasets, Hybrid Models, and Cache
• Ability to design and implement complex data models, ETL/ELT processes, and data integration strategies
• Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint)

Nice to Have:

• Certifications in Azure Data Engineering or related Azure certifications
• Experience with integrating data from Salesforce, NetSuite, and other CRM/ERP systems
• Familiarity with data governance frameworks and principles
• Prior experience in designing/optimizing data pipelines for performance, scalability, and agility
• Understanding of Database Administration and tuning
• Knowledge of Databricks, Spark, and Python in regards to data engineering

*Position revised 4/30/24.
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)