• Snowflake Data Modeler

    Motion Recruitment Partners (North Chicago, IL)


    Snowflake Data Modeler

     

    North Chicago, Illinois

     

    Hybrid

     

    Contract

     

    $40/hr - $60/hr

     

    Our organization is dedicated to discovering and delivering innovative solutions that address today’s critical medical challenges and prepare for the needs of tomorrow. We aim to make a meaningful impact on people’s lives across key healthcare domains, with a focus on driving transformation through advanced data and technology solutions.

     

    We are seeking a dedicated **Data Modeler Consultant** to lead the adoption and implementation of a modern data modeling tool within a Snowflake Data Warehouse environment. The primary responsibility of this role is to reverse-engineer existing databases into the new modeling platform and enrich models by adding comprehensive metadata and clear business descriptions. This position is essential in transforming fragmented and undocumented environments into well-documented, standardized, and business-aligned data assets.

     

    Contract Duration: 6 – 12 Months

    Required Skills & Experience

    + Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.

    + 3+ years of hands-on data modeling experience using tools like ER/Studio, SqlDBM, Erwin, etc., in cloud data warehouse or analytics environments (Snowflake preferred).

    + Expertise in reverse-engineering existing databases and translating into modern data modeling tools.

    + Strong capability in metadata management, business glossary development, and technical documentation.

    + Familiarity with data governance concepts, naming conventions, and data quality best practices.

    + Proficiency in SQL and database structure assessment.

    + Excellent communication, collaboration, and stakeholder engagement skills.

    Desired Skills & Experience

    + Experience leading or supporting data modeling tool adoption projects.

    + Background in large-scale data migrations or modernization efforts.

    + Experience in regulated industries such as healthcare, pharmaceuticals, or financial services.

    + Understanding requirements for analytics, self-service BI, and AI/ML data contexts.

     

    Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

    \#LI-EM1

    You will receive the following benefits:

    + Medical Insurance - Four medical plans to choose from for you and your family

    + Dental & Orthodontia Benefits

    + Vision Benefits

    + Health Savings Account (HSA)

    + Health and Dependent Care Flexible Spending Accounts

    + Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance

    + Hospital Indemnity Insurance

    + 401(k) including match with pre and post-tax options

    + Paid Sick Time Leave

    + Legal and Identity Protection Plans

    + Pre-tax Commuter Benefit

    + 529 College Saver Plan

     

    Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.

     

    **Posted by:** Esteban Medina

    Specialization:

    + Database Engineer