Jobs
>
Chicago

    Senior Data Architect - Chicago, United States - American Dental Association

    American Dental Association
    American Dental Association Chicago, United States

    5 days ago

    Default job background
    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 2021Come 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

    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 c)
  • TD Synnex - SHI for Chicago Public Schools (Central Office)

    Data Architect

    5 days ago

    TD Synnex - SHI for Chicago Public Schools (Central Office) Chicago, United States

    Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing approximately 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and ...

  • Laiba Technologies

    Cloud Data Architect

    1 week ago

    Laiba Technologies Chicago, United States

    **Position: Cloud Data Architect** · **Location: Chicago, IL** · - 15+ years of experience · - Certifications ( AWS / Snowflake / Datawarehouse) · - Datawarehouse Architecture / Concepts · - Data Modelling Concepts & Architecture · - Data Structure & Architecture · - DB Experienc ...

  • IT Associates

    Data Architect

    1 week ago

    IT Associates Chicago, United States

    Cloud Data Architect ( Data Migration to Azure / Cloud Data Solution Architecture) · Direct Hire OR Fulltime with Full Benefits and Bonus · Hybrid 2-3 days in office in Ann Arbor, MI · Multi-Million Dollar E-commerce client · As a Cloud Data Solutions Architect focused on Data ...

  • The LaSalle Group

    Data Architect

    1 week ago

    The LaSalle Group Chicago, United States

    We are seeking a highly skilled and motivated Data Architect with hands-on experience in Microsoft Azure to join our client's dynamic team. As a Data Architect, you will play a critical role in designing, implementing, and managing our data architecture, ensuring reliability, sca ...

  • Keylent Inc

    Data Architect

    5 days ago

    Keylent Inc Chicago, United States

    This is old requirement · COGNIZANT / Client / Onsite · We have the following 3 positions to be filled immediately. Please make sure to submit QUALITY resumes and who are available Local / Ready to Relocate. Check with consultants if they have submitted earlier. · Location - C ...

  • CyberTec

    Data Architect

    5 days ago

    CyberTec Chicago, United States

    Job Title : Data Architect- · Location: Chicago , IL Must live in Chicago and go downtown · Job Type : 75% onsite · Duration : 12 months · Opening : 1 Opening · Must have: - Data +Application Architect for MDM solution. · - Design a Unique Guest ID real-time integration solu ...

  • LTIMindtree

    Data Architect

    4 days ago

    LTIMindtree Chicago, United States

    About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • Analytic Recruiting Inc.

    Data Architect

    1 week ago

    Analytic Recruiting Inc. Chicago, United States

    A leading Supermarket chain are seeking an AI Architect/Director to enable AI capabilities across their business through apps & services. The role will support creating personalized experiences for shoppers and using cutting-edge analytics and first-party retail data from million ...

  • 66degrees

    Data Architect

    1 week ago

    66degrees Chicago, United States

    Overview of 66degrees · 66degrees is a leading consulting and professional services company specializing in developing AI-focused, data-led solutions leveraging the latest advancements in cloud technology. With our unmatched engineering capabilities and vast industry experience, ...

  • Ztek Consulting

    Data Architect

    2 weeks ago

    Ztek Consulting Chicago, United States

    Job Role : · Data Architect (Snowflake & Azure) · Location : · Chicago, IL (Day 1 Onsite) · Mode of interview : · Skype, Video/Telephonic · Job Roles/Responsibilities: · Data Integration and Synchronization: · Design efficient data synchronization processes between on-prem ...

  • V2soft

    Data Architect

    5 days ago

    V2soft Chicago, United States

    V2Soft ( ) is a global company, headquartered out of Bloomfield Hills, Michigan, with locations in Mexico, Italy, India, China, and Germany. At V2Soft, our mission is to provide high-performance technology solutions to solve real business problems. We become our customer's true ...

  • TechWish

    Data Architect

    5 days ago

    TechWish Chicago, United States

    Data Architect · Must be local to Chicago · very strong skills with Snowflake · ****MUST HAVE VERY STRONG SNOWFLAKE · Work on a Snowflake DW design and implementation. · Design and deploy services to AWS using Terraform and Cloud formation stack. · Design CICD pipelines for ap ...

  • HUB International

    Data Architect

    1 week ago

    HUB International Chicago, United States

    At HUB International, we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empower ...

  • LTIMindtree

    Data Architect

    1 week ago

    LTIMindtree Chicago, United States

    About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • Diverse Lynx

    Data Architect

    2 weeks ago

    Diverse Lynx Chicago, United States

    Role: Data Architect · Position Type: Contract · Contract Duration: 6+ months with possibility of extension · Work Location: Chicago, IL ( Hybrid, onsite from day one) · Primary Skills: AWS, Python, Spark, KAFKA · Job Description: Strong expertise in Datawarehouse/data architec ...

  • Allergan

    Data Architect

    1 week ago

    Allergan Chicago, United States

    Area of Interest: Administrative Services · AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several ...

  • Mondelez International

    Data Architect

    5 days ago

    Mondelez International Chicago, United States

    Job Description · Are You Ready to Make It Happen at Mondelēz International? · Join our Mission to Lead the Future of Snacking. Make It With Pride. · Execute Business Intelligence Solutions & Insights initiatives to uncover trends that deduce insights and solve business problems ...

  • NextRow

    Data Architect

    5 days ago

    NextRow Chicago, United States

    Job Description · NextRow is You must be a problem solver who looks to elevate the work of everyone around them. · - Provides expert guidance to projects to ensure that their processes and deliverables align with the Client target state architecture. · - Defines & develops ent ...

  • Mondelēz International

    Data Architect

    5 days ago

    Mondelēz International Chicago, United States Full time

    Job Description · Are You Ready to Make It Happen at Mondelēz International? · Join our Mission to Lead the Future of Snacking. Make It With Pride. · Execute Business Intelligence Solutions & Insights initiatives to uncover trends that deduce insights and solve business problem ...

  • Selby Jennings

    Principal, Data Architect

    6 days ago

    Selby Jennings Chicago, United States

    Selby Jennings has partnered with a leading clearing house that is looking for a Data Architect to join their team at the Principal level. This role is offered on a hybrid capacity out of Chicago or Dallas. · The Principal, Data Architecture will have the following responsibiliti ...