Jobs
>
Milwaukee

    Cloud Data Architect - Milwaukee, United States - EVERSANA

    Default job background
    Full time
    Description

    Job Description

    THE POSITION:

    As a Cloud Data Architect, this role will be instrumental in enhancing and supporting our Enterprise Cloud Data Warehouse currently on Snowflake. Responsible for designing and delivering data models, data integrations and ETL data pipelines, supporting client project deliverables and ensuring meticulous documentation of solutions provided. The ideal candidate will have a strong background in data architecture, experience with Snowflake Cloud Data Warehouse, and proficiency in ETL processes.

    ESSENTIAL DUTIES AND RESPONSIBILITIES:

    1. Design and implement end-to-end data integration solutions with Enterprise Cloud Data Warehouse.

  • Data replication from variety of internal and external data sources into Snowflake Data Warehouse Raw layer.
  • Collaborate with cross-functional teams to understand business requirements and translate them into effective data models.
  • 2. Experience with Snowflake Cloud Data Warehouse Platform is required:

  • Experience using Snowflake capabilities such as Snowpipes, Tasks, Streams, Stored Procedures, Data Replication.
  • Implement best practices for data auditing & data quality.
  • Implement Industry best practices for User Access and Data Security.
  • Experience with Secure Data Sharing
  • Experience implementing best practices for virtual warehouse management
  • 3. Design and implement ETL processes:

  • Experience using DBT ETL is required.
  • Experience using Qlik Replicate and Qlik Compose ETL is preferred.
  • Experience using CICD pipelines and code repositories such as Bitbucket is preferred.
  • Develop and implement efficient ETL processes to support data integration from different engagement platforms.
  • Optimize data workflows for performance and scalability.
  • Experience with AWS Services (S3, Event Bridge, Cloudwatch, etc.) is required.
  • 4. Support client project deliverables:

  • Able to lead the implementation and integration of data solutions for clients.
  • Provide technical guidance and support during client onboarding processes.
  • Conduct data mapping exercises to align business requirements with data architecture.
  • 5. Demonstrate proficiency in SQL; Python scripting skills are a valuable addition:

  • Write and optimize SQL queries for data extraction, transformation, and loading.
  • Python skills for automation and scripting are desirable.
  • 6. Knowledge of Life Sciences or Healthcare business processes is advantageous

  • Familiarity with Patient Services and Specialty Pharmacy systems and business processes is a plus.
  • 7. Exhibit strong documentation abilities:

  • Familiarity with SDLC processes and documentation.
  • Experience using work management and documentation platforms such as Jira, Confluence is a plus.
  • Document requirements and conduct peer reviews.
  • Ensure documentation is accessible and understandable for both technical and non-technical stakeholders.
  • EXPECTATIONS OF THE JOB:

  • Travel – Under 5%
  • Hours – 40+, typically Monday - Friday
  • The above list reflects the general details necessary to describe the expectations of the position and shall not be construed as the only expectations that may be assigned for the position.

    An individual in this position must be able to successfully perform the expectations listed above.

    Qualifications

    MINIMUM KNOWLEDGE, SKILLS AND ABILITIES:

  • At least 5+ years with Data Warehouse architecture design and solutioning.
  • At least 3+ years of experience working with Snowflake cloud data warehouse.
  • At least 2+ projects operating in Lead Data Architect role.
  • Experience using and developing with ETL tools, preferably DBT and Qlik Replicate and Compose.
  • Strong problem-solving and analytical abilities.
  • Ability to design, execute and communicate solutions to different stakeholders.
  • Experience with AWS and Python scripting.
  • Bachelor's or advanced degree in Computer Science, Information Technology, or a related field.
  • PHYSICAL/MENTAL DEMANDS AND WORKING ENVIRONMENT:

    The physical and mental requirements along with the work environment characteristics described here are representative of those an individual encounters while performing the essential functions of this position.

    Office: While performing the essential functions of this job the employee is frequently required to reach, grasp, stand and/or sit for long periods of time (up to 90% of the shift), walk, talk and hear; occasionally required to lift and/or move up to 25 pounds. The noise level in the work environment is usually moderately quiet, with frequent interruptions and multiple demands.

    Work Perks

  • Competitive Wages Above market salary structures as part of our total rewards program
  • Retirement Resources Generous employer matching retirement solutions
  • Health & Wellness Leading health, dental and vision insurance products
  • Continuous Education Employer-funded tuition reimbursement
  • Global Workplace Flexibility Remote and hybrid work across the globe
  • Paid Time Off Generous paid time off including company holidays
  • Training & Development Company provided training and development
  • Employee Assistant Programs Offering financial, work-life balance, legal solutions and more to employees at no cost

  • AE Business Solutions

    Data Architect

    6 days ago


    AE Business Solutions Milwaukee, United States

    AE Business Solutions is looking for a **Data Architect** for a **hybrid, contract to hire position **with a client located in Milwaukee, WI.** **The Architect will possess excellent leadership capabilities and lead architectural design and strategy discussions to support the mis ...

  • Compunnel Inc.

    Data Architect

    3 weeks ago


    Compunnel Inc. Milwaukee, United States

    Job Title: Data Architect · Location: Milwaukee, WI - Hybrid – 2 to 3 days work from office · Type: Direct inhouse requirement - Contract-to-hire with a contract period of minimum 1 year with possibility of extension. · Interview Process: Please note these are all going to be Vid ...

  • GE HEALTHCARE

    Data Architect

    2 weeks ago


    GE HEALTHCARE Waukesha, United States

    **Job Description Summary**: As a Data Architect for the services business, you will play a pivotal role in designing, implementing, and maintaining our data architecture to support our business intelligence and analytics initiatives. You will collaborate closely with cross-funct ...

  • Robert W. Baird & Company, Inc.

    Data Architect

    1 week ago


    Robert W. Baird & Company, Inc. Milwaukee, United States

    Data Management. Develop strategies and architectures to support the mission and growth of the Data and Analytics organization. Lead architectural design and strategy discussions. Learn, research, and POC new technologies. Understand when/where vario Data Architect, Architect, So ...

  • Compunnel

    Data Architect

    2 weeks ago


    Compunnel Milwaukee, United States

    Job Title: Data Architect · Location: Milwaukee, WI - Hybrid – 2 to 3 days work from office · Type: Direct inhouse requirement - Contract-to-hire with a contract period of minimum 1 year with possibility of extension. · Interview Process: · Please note these are all going to be ...

  • Robert W. Baird & Co.

    Data Architect

    1 week ago


    Robert W. Baird & Co. Milwaukee, United States

    Do you love data? Are you naturally curious and passionate? Are you driven by enabling mission-critical business processes and data-driven decisions? Are you pragmatic and inspired by meeting people where they are in their data journey? Want to contribute to a growing financial s ...

  • Robert W. Baird & Co. Incorporated

    Data Architect

    1 week ago


    Robert W. Baird & Co. Incorporated Milwaukee, United States

    Do you enjoy making sense of business data? Are you naturally curious and passionate? Are you driven by enabling mission-critical business processes and data-driven decisions? Are you pragmatic and inspired by meeting people where they are? Want to contribute to a growing financi ...

  • Codeworks L.L.C

    Data Architect

    1 week ago


    Codeworks L.L.C Milwaukee, United States

    Job Description · Job DescriptionCodeworks is an IT Services firm in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships. Who We're Looking For... · A Data Architect for a contract / contract to hire hybrid position in Milwaukee, Wisc ...

  • Kaygen

    Data Architect

    3 weeks ago


    Kaygen Milwaukee, United States

    KAYGEN is an emerging leader in providing top talent for technology based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Servic ...


  • The Panther Group Milwaukee, United States

    Enterprise Data Architect (Remote) The Panther Group has an immediate need for an Enterprise Data Architect for a our client in the financial industry. This position is remote opportunity. Job description: Establish the approach and framework for bui Data Architect, Enterprise, A ...


  • JobRialto Milwaukee, United States

    General Data Management · Develop strategies and architectures to support the mission and growth of the Data and Analytics organization. · Lead architectural design and strategy discussions. · Learn, research, and POC new technologies. Understand when/where various technologie ...


  • JobRialto Milwaukee, United States

    :Minimum Bachelor's degree in computer science, information technology, or a similarly relevant field. Master's Business degree is preferred · Minimum 15 years of data professional hands-on experience with data architecture, governance, data engineering, reporting and analytics, ...


  • newance Milwaukee, United States

    You want to be part of something exciting Join our team in Milwaukee, WI, where you will experience a truly innovative and agile work environment, centered on producing the best solutions for our clients. You are interested in working in a collaborative environment using test dri ...


  • NORTHWESTERN MUTUAL LIFE INSURANCE Milwaukee, United States

    JOB REQUIREMENTS: At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference. Principal Enterprise Architect, AI & Data Science This is a hybrid position in Milwaukee. Will require 3 days (M, T, and W) onsite eac ...


  • Xylem Pewaukee, United States

    We're Hiring for a **Data Architect, Source to Pay and Order to Cash** · If you are excited and passionate about helping LetsSolveWater, consider joining our team today **Xylem, Inc.** is a leading global water technology company servicing more than 150 countries and is dedicated ...

  • Insight Global

    Data Architect

    2 days ago


    Insight Global Brookfield, United States

    Insight Global is seeking a Data Architect for our actuarial consulting services client to sit remotely. In this position as a Data Architect, you play a pivotal role in the alignment of the business vision, technology strategy and portfolio execution. You will be responsible for ...

  • NESCO Inc

    Data Architect

    3 weeks ago


    NESCO Inc Brookfield, United States

    What you'll be doingStay current with industry data privacy regulations and standards (e.g., HIPAA, FCRA, GDPR, CCPA) and integrate compliance into architectural designs. · Design and implement security measures, including encryption, access controls, and auditing, to protect sen ...

  • GE Healthcare

    Data Architect

    1 week ago


    GE Healthcare Waukesha, United States

    Job Description Summary · As a Data Architect for the services business, you will play a pivotal role in designing, implementing, and maintaining our data architecture to support our business intelligence and analytics initiatives. You will collaborate closely with cross-functio ...

  • GE Healthcare

    Data Architect

    6 days ago


    GE Healthcare Waukesha, United States

    Job Description Summary · As a Data Architect for the services business, you will play a pivotal role in designing, implementing, and maintaining our data architecture to support our business intelligence and analytics initiatives. You will collaborate closely with cross-functio ...


  • IKO Industries Milwaukee, United States

    **WHAT'S IN IT FOR YOU?** · - Competitive salary · - Competitive health and benefit plan · - Competitive matched retirement savings program · - The opportunity to join a continuously growing organization with focus on Diversity and Inclusion · - The opportunity to work with an in ...