Talent.com
Data Modeler
Data ModelerChelsoft Solutions Co • Sacramento, California, USA
Data Modeler

Data Modeler

Chelsoft Solutions Co • Sacramento, California, USA
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Data Modeler

ODI & ADW & OCI experience

Required to have State / Gov experience

Certifications - Oracle

Location : Local to Sac CA preferred. Hybrid work required.

  • Two days a week in office required. Monday and Wednesday each week.
  • Must live within 60 miles maximum from location

Requirements :

  • Senior hands-on data modeler with strong communication skills.
  • Expert level command of ER / STUDIO Data Architect modeling application
  • Strong ability to articulate data modeling principles and gather requirements from non-technical business stakeholders
  • Excellent presentation skills to different (business and technical) audiences ranging from senior level leadership to operational staff with no supervision
  • Ability to translate business and functional requirements into technical requirements for technical team members.
  • Candidate needs to be able to demonstrate direct hands-on recent practical experience in the areas identified with specific examples.
  • Key Duties / Responsibilities :

  • Performs business and systems analysis and documentation
  • Develops conceptual logical and physical relational data models for the enterprise data warehouse
  • Experience with large data warehouse implementation projects
  • Performs data modeling in relational and dimensional models
  • Develops physical data model and / or works with architect to develop physical data model
  • Ability to expertly develop Data Facts and Dimensions in the EDW
  • Provides documentation to support the Kimball Dimensional Data Modeling Framework as necessary
  • Visualizes and designs the enterprise data management framework : specifies processes used to plan acquire maintain use archive retrieve control and purge data
  • Documents data flow diagrams in existing and future reports to use as input in report design and optimization
  • Develops Requirements Specifications
  • Develops Design Specifications
  • Performs data analysis / predictive data modeling
  • Mentors and educates team members on best practices and industry standards
  • Qualifications : Mandatory :

  • Minimum of ten (10) years demonstrable experience in the data management space with at least 5 years specializing in database design
  • Minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines such as researcher or data engineer supportive of key duties / responsibilities identified above.
  • Minimum of five (5) years of demonstrated experience with ER / Studio data modeling application
  • Minimum of five (5) years of relevant experience in relational data modeling and dimensional data modeling statistical analysis and machine learning supportive of key duties / responsibilities identified above.
  • Excellent communication and collaboration skills to work effectively with stakeholders and team members.
  • At least 2 years experience working on Star Snowflake and / or Hybrid schemas
  • Desired :

  • At least 2 years experience working on Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCI environment.
  • Expert level Kimball Dimensional Data Modeling experience
  • Expert level experience developing in Oracle SQL Developer or ER / Studio Data Architect for Oracle.
  • Ability to develop and perform Extract Transform and Load (ETL) activities using Oracle tools and PLL SQL / SQL with at least 2 years experience. Ability to perform technical leadership of a Oracle data warehouse team including but not limited to ETL requirements solicitation DBA data warehouse administration and data analysis on a hands-on basis.
  • Key Skills

    Atl,CMMS,ABAP,Community Support,CRM,Fleet

    Employment Type : Full Time

    Experience : years

    Vacancy : 1

    [job_alerts.create_a_job]

    Data Modeler • Sacramento, California, USA

    [internal_linking.related_jobs]
    Remote Sales Representative (50k-90k per year)

    Remote Sales Representative (50k-90k per year)

    Professional Careers • Lincoln, California
    [filters.remote]
    [job_card.full_time] +1
    We're looking for candidates with great customer service skills to fill our Remote role!.This role is entirely remote and offers full-time / Part time hours with flexibility.We are ready to schedule ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Analyst / Data Modeler

    Senior Data Analyst / Data Modeler

    eStaffLLC • Sacramento, CA, US
    [job_card.full_time]
    We are seeking a senior, hands-on Data Analyst / Data Modeler with strong communication skills for a long-term hybrid assignment with our Sacramento, California-based client.This position requires o...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Content Creator (Model)

    Content Creator (Model)

    Orca Communications • Sacramento, California, United States
    [filters.remote]
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Want To Be Internet Famous? We’re Hiring Creators!.Do you have enormous energy, big dreams, and tons of personality? Could you light up social media if just given the chance? Here’s your shot.Orca ...[show_more]
    [last_updated.last_updated_variable_days]
    Electrical BIM Modeler III

    Electrical BIM Modeler III

    Rosendin • Sacramento, CA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Whether you're a recent grad or a seasoned professional, you can experience meaningful career growth at Rosendin.Enjoy a true sense of ownership as you work with a proven industry leader on some of...[show_more]
    [last_updated.last_updated_30]
    Data Modeler

    Data Modeler

    eStaff LLC • Sacramento County, CA, United States
    [job_card.full_time]
    We are seeking a senior, hands-on Data Analyst / Data Modeler with strong communication skills for a long-term hybrid assignment with our Sacramento, California-based client.This position requires y...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Modeler

    Data Modeler

    My3Tech • Sacramento, CA, United States
    [job_card.temporary]
    [filters_job_card.quick_apply]
    Hello, Position : Data Modeler Location : Sacramento, CA (Hybrid) Duration : Long-term Contract< / div&g...[show_more]
    [last_updated.last_updated_1_day]
    Licensed Hair Stylist - Lincoln Hills Town Center

    Licensed Hair Stylist - Lincoln Hills Town Center

    Great Clips • LINCOLN, California, United States
    [job_card.full_time] +1
    Join a locally owned Great Clips® salon, the world's largest salon brand, and be one of the GREATS! Whether you're new to the industry or have years behind the chair…great opportunities await!!.Bri...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Newly Licensed Real Estate Agent

    Newly Licensed Real Estate Agent

    Culbertson and Gray Group • Lincoln, CA, US
    [job_card.full_time]
    Advance Your Real Estate Career with The Culbertson Gray Group.Are you ready to elevate your real estate career with a dynamic team that thrives on innovation and growth? The Culbertson Gray Group ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Modeler_W2_ Sacramento CA

    Data Modeler_W2_ Sacramento CA

    Chelsoft Solutions Co • Sacramento, CA, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Data Modeler ODI & ADW & OCI experience Required to have State / Gov experience Certifications - Oracle Location : <...[show_more]
    [last_updated.last_updated_variable_days]
    Financial Modeling Consultant FreelancerRemote

    Financial Modeling Consultant FreelancerRemote

    CrowdPharm • Sacramento, CA, US
    [job_card.full_time]
    Hot Iron Health is seeking a Freelance Financial Modeling Consultant with expertise in developing robust financial models for the pharmaceutical and biotechnology industries.As a consultant, you wi...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Virtual Construction Modeler II

    Virtual Construction Modeler II

    Royal Electric • Sacramento, CA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Virtual Construction Modeler II.At Royal Electric Company we provide expert electrical design, construction, and service with builders, contractors and facility owners who value relationships, trus...[show_more]
    [last_updated.last_updated_30]
    Stibo MDM Technical Architect (Rocklin)

    Stibo MDM Technical Architect (Rocklin)

    ClifyX • Rocklin, CA, United States
    [job_card.full_time]
    Strong knowledge of MDM solutions (CMDM, SMDM, Multi-domain MDM) in STIBO STEP.Extensive experience in Extension APIs, Business Rules and guide the junior team members. Knowledge on Stibo Architectu...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Remote M&A Associate - AI Trainer ($50-$60 / hour)

    Remote M&A Associate - AI Trainer ($50-$60 / hour)

    Data Annotation • Elk Grove, California
    [filters.remote]
    [job_card.full_time] +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Modeler (Sacramento County)

    Data Modeler (Sacramento County)

    eStaff LLC • Sacramento County, CA, United States
    [job_card.full_time]
    We are seeking a senior, hands-on Data Analyst / Data Modeler with strong communication skills for a long-term hybrid assignment with our Sacramento, California-based client.This position requires y...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Data Annotation • Elk Grove, California
    [filters.remote]
    [job_card.full_time] +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Practice Lead / Supervisor (EyeOptics Optometry Center)

    Practice Lead / Supervisor (EyeOptics Optometry Center)

    VSP Vision • Elk Grove, CA, United States
    [job_card.full_time]
    Compensation range for the role is listed above.Applicable salary ranges may differ across markets.Actual pay will be determined based on experience and other job-related factors permitted by law.A...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Licensed Hair Stylist - Galt Village Center

    Licensed Hair Stylist - Galt Village Center

    Great Clips • GALT, California, United States
    [job_card.full_time] +1
    Join a locally owned Great Clips® salon, the world's largest salon brand, and be one of the GREATS! Whether you're new to the industry or have years behind the chair…great opportunities await!!.Ful...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Power BI Developer

    Power BI Developer

    KK Tech LLC • Sacramento, CA, US
    [job_card.full_time]
    Atleast 2 years of hands-on experience in using Generative AI or Machine Learning to successfully deliver data analytics solutions. At least 5 years of hands-on full-time experience of designing and...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]