Talent.com
Senior Data Modeler
Senior Data ModelereStaffLLC • Sacramento, California, USA
Senior Data Modeler

Senior Data Modeler

eStaffLLC • Sacramento, California, USA
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

We are seeking a Senior Data Modeler in the Sacramento California area. This position requires you to be able to work on-site in Sacramento California on Mondays and Wednesdays each week. Candidates must currently live within 60 miles of Sacramento CA. Anyone else will be rejected.

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 a physical data model and / or works with the architect to develop a 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 specifying 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
  • Development Requirements Specifications
  • Develop Design Specifications
  • Performs data analysis / predictive data modeling
  • Mentors and education team members on best practices and industry standards

Mandatory Requirements :

  • Minimum of ten (10) years demonstrable experience in the data management space with at least 5 years specializing in database design and at least 5 years in data modeling.
  • Senior hands-on Data Modeler with strong communication skills.
  • Expert-level command of the ER / STUDIO Data Architect modeling application
  • Must have Oracle Data Integrator (ODI) experience.
  • At least 2 years experience working in Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCI environment
  • Strong ability to articulate data modeling principles and gather requirements from non-technical business stakeholders
  • 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.
  • 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.
  • Excellent presentation skills to different (business and technical) audiences ranging from Senior-level leadership to operational staff with no supervision
  • At least 2 years of experience working on Star Snowflake and / or Hybrid schemas
  • 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 identified areas with specific examples.

    • Required to have State / Gov experience

    Desired :

  • 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 PL / SQL with at least 2 years of experience.
  • Ability to perform technical leadership of an Oracle data warehouse team including but not limited to ETL requirements solicitation DBA data warehouse administration and data analysis on a hands-on basis.

    • Required Experience :

    Senior IC

    Key Skills

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

    Employment Type : Contract

    Experience : years

    Vacancy : 1

    [job_alerts.create_a_job]

    Senior Data Modeler • Sacramento, California, USA

    [internal_linking.similar_jobs]
    Senior Data Architect

    Senior Data Architect

    VirtualVocations • Sacramento, California, United States
    [job_card.full_time]
    A company is looking for a Senior Data & AI Architect - Enterprise & AI Enablement.Key Responsibilities Define and evolve the architectural blueprint for data and AI systems supporting underwriti...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Big Data Manager

    Big Data Manager

    ClifyX • Sacramento, CA, US
    [job_card.full_time]
    Big Data Manager - (WEST Region) CA Los Angeles, CA - Los Alamitos, CA - Norwalk, CA - El Segundo, CA - Sacramento, CA - San Diego, CA - San Francisco, CA - San Jose, WA - Seattle, OR Portland (C...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Analyst - Actuarial

    Senior Analyst - Actuarial

    Ally • Sacramento, CA, United States
    [job_card.permanent]
    Ally Financial only succeeds when its people do - and that's more than some cliché people put on job postings.We live this stuff! We see our people as, well, people - with interests, families, frie...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Design Manager

    Senior Design Manager

    HDR • Sacramento, CA, United States
    [job_card.full_time]
    At HDR, our employee-owners are fully engaged in creating a welcoming environment where each of us is valued and respected, a place where everyone is empowered to bring their authentic selves and n...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Senior Manager, Geospatial Technology

    Senior Manager, Geospatial Technology

    CDM Smith • Sacramento, CA, United States
    [job_card.full_time]
    CDM Smith is seeking a Geospatial Technology Leader to join our Digital Engineering Solutions team.This individual will lead the Geospatial Technology group within the Digital Engineering Solutions...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Applied Scientist - AI Development and Modeling

    Senior Applied Scientist - AI Development and Modeling

    Oracle • Sacramento, CA, United States
    [job_card.full_time]
    Join Oracle Analytics and be part of our mission to redefine enterprise AI through groundbreaking products that deliver intelligent data analysis at scale. Leverage your expertise in data management...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • Galt, California, US
    [filters.remote]
    [job_card.full_time]
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...[show_more]
    [last_updated.last_updated_variable_days]
    Databricks Engineer - Data Engineer III

    Databricks Engineer - Data Engineer III

    AmerisourceBergen Corporation (Cencora) • Sacramento, CA, United States
    [job_card.full_time]
    Our team members are at the heart of everything we do.At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on ...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Virtual Construction Modeler I

    Virtual Construction Modeler I

    Royal Electric • Sacramento, CA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    At Royal Electric Company we provide expert electrical design, construction, and service with builders, contractors and facility owners who value relationships, trust, expertise, and a commitment t...[show_more]
    [last_updated.last_updated_variable_days]
    Actuarial Analyst, Senior

    Actuarial Analyst, Senior

    Blue Shield of CA • Rancho Cordova, CA, United States
    [job_card.full_time]
    The Actuarial Provider Strategies team supports the budget setting, program design, and operations of Blue Shield of California's value-based care (VBC) payment models, which includes Accountable C...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Programmer Analyst

    Senior Programmer Analyst

    Sacramento Regional Transit District • Sacramento, CA, United States
    [job_card.full_time]
    THIS POSITION WILL REMAIN OPEN UNTIL FILLED.APPLICATIONS ARE REVIEWED AS RECEIVED, AND INTERVIEWS WILL BE SCHEDULED FOR MOST QUALIFIED CANDIDATES, AS APPLICATIONS ARE REVIEWED.The purpose of this p...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Consultant Data Architect

    Senior Consultant Data Architect

    Yeo & Yeo HR Advisory Solutions • Sacramento, California, USA
    [job_card.full_time]
    Are you a seasoned data architect looking for a role that blends hands-on technical work with shaping data strategyto makea difference in the lives of millions If so read on!.Ifitshigh-stakes high-...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Consultant - Data Architect

    Senior Consultant - Data Architect

    Yeo & Yeo HR Advisory Solutions • Sacramento, CA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Are you a seasoned data architect looking for a role that blends hands-on technical work with shaping data strategy to make a difference in the lives of millions?.If so, read on! &#...[show_more]
    [last_updated.last_updated_variable_days]
    Lead BI Developer

    Lead BI Developer

    Launch Potato • Sacramento, California, USA
    [job_card.full_time]
    Launch Potato is a profitable digital media company that reaches over 30M monthly visitors through brands such as.As The Discovery and Conversion Company our mission is to connect consumers with th...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Applied Scientist - Healthcare AI

    Senior Applied Scientist - Healthcare AI

    Oracle • Sacramento, CA, United States
    [job_card.full_time]
    Join Oracle Health & AI, a vibrant new initiative focusing on innovative product development and strategies within Oracle Health. This is your chance to be part of an entrepreneurial team dedicated ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior BI Developer

    Senior BI Developer

    VirtualVocations • Sacramento, California, United States
    [job_card.full_time]
    A company is looking for a Senior BI Developer to lead strategy and analytics innovation within their platform.Key Responsibilities Own complex analytics applications from design to delivery, man...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Data Science Leader, Analytics

    Data Science Leader, Analytics

    META • Sacramento, CA, United States
    [job_card.full_time]
    As a Data Science Manager at Meta, you will play a key role in shaping the future of experiences for billions of people and hundreds of millions of businesses worldwide. You will apply your leadersh...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]