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]
    Patient Coordinator (Laguna Creek Optometry)

    Patient Coordinator (Laguna Creek Optometry)

    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_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]
    1099 Board Certified Behavioral Analyst (BCBA) - Herald CCH 356

    1099 Board Certified Behavioral Analyst (BCBA) - Herald CCH 356

    Telecare Corporation • Herald, CA, United States
    [job_card.part_time]
    Telecare's mission is to deliver excellent and effective behavioral health services that engage individuals in recovering their health, hopes, and dreams. Telecare continues to advance cultural dive...[show_more]
    [last_updated.last_updated_30] • [promoted]
    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]
    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]
    Metadata Librarian

    Metadata Librarian

    InsideHigherEd • Sacramento, California, United States
    [job_card.full_time]
    Library of the University of California, Davis.The Library of the University of California (UC), Davis, seeks a forward-looking and entrepreneurial professional to join our team as the Metadata Lib...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    Remote Customer Service (50k-90k per year)

    Remote Customer Service (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 Customer Service role!.This role is entirely remote and offers full-time / Part time hours with flexibility.We are r...[show_more]
    [last_updated.last_updated_30] • [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

    Data Modeler

    My3Tech • Sacramento, California, USA
    [job_card.full_time]
    Location : Sacramento CA (Hybrid).Location : Local to Sacramento CA preferred.Two days a week in office required.Monday and Wednesday each week. Must live within 60 miles maximum from location.Require...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    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]
    Groundwater Modeler

    Groundwater Modeler

    Montgomery & Associates • Sacramento, CA, US
    [job_card.full_time]
    Montgomery & Associates (M&A) is seeking a.This position will be associated with one of our two largest offices (Oakland or Sacramento). Our team is currently working approximately 50% in th...[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]