Need Locals/Nearbys to Sacramento,CA ORACLE CERTIFIED-Data Modeler

2 days ago

Sacramento, California, United States My3Tech Full time

Hello,

Position: Data Modeler

Location: Sacramento, CA (Hybrid)

This position is with State client, Can work on C2C/on W2.

***Location: Local to Sacramento, 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.

Required to have State/Gov experience

Certifications: Oracle

ODI & ADW & OCI experience

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
  • 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

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.

---

Thanks

Srujana

Email: |

  • SharePoint & ECM Administrator-F2F Only-Local to-Sacramento, CA

    2 weeks ago

    Sacramento, California, United States Exarca Inc. Full time $60,000 - $120,000 per year

    SharePoint & ECM Administrator Enterprise Content Management) with Sacramento County.Enterprise Content Management AdministratorMust be local to Sacramento, CA (HybriD )interview - F2F ( ONE ROUND ONLY ) - Interviews are anticipated the week of November 17thLocation:County of SacramentoHybrid Remote-3 days on site with 2 days remoteMust have excellent...

  • CRNA - Per Diem - Methodist Hospital of Sacramento - Sacramento, CA

    2 weeks ago

    Sacramento, California, United States Somnia Full time $7,200 - $100,000 per year

    OverviewSomnia Anesthesia | Collaborative Care Team | Full scope practice | Competitive comp Somnia Anesthesia, a physician-owned and clinician-led anesthesia group, is looking for CRNAs to join our growing team at Methodist Hospital of Sacramento. This is a unique opportunity that offers you hospital work without the obligation of call. This practice...

  • Field Clinical Specialist: Sacramento, CA

    2 weeks ago

    Sacramento, California, United States BIOTRONIK Full time $80,000 - $120,000 per year

    Field Clinical Specialist: Sacramento, CAAs one of the world´s leading manufacturers of cardio- and endovascular medical devices, BIOTRONIK is headquartered in Berlin, Germany, and represented in over 100 countries by its global workforce. The work of our committed, highly specialized, exceptionally skilled employees results in crucial advancements in the...

  • Interventional Psychiatrist, Sacramento, CA

    8 hours ago

    Sacramento, California, United States Sutter Health Full time

    Opportunity InformationSutter Medical Group (SMG) seeks to hire an Interventional Psychiatrist to join dynamic team in Sacramento, CA.Primary role: cover SCP's Interventional Psychiatry program—ECT, IV Ketamine, and TMS QualificationsBoard certified/Board eligible TMS trained Experience with ECTJoin Us and Enjoy2-year income guarantee with shareholder...

  • Perm - Physician - Maternal Fetal Medicine Sacramento, CA

    8 hours ago

    Sacramento, California, United States Optigy Full time

    Specialty: Maternal-Fetal Medicine Specialist Sacramento, CALocation: Sacramento, CaliforniaCompany: OptigyType: Permanent OnsiteRates: $400,000$450,000 base + bonus potential________________________________________About the LocationLocated in vibrant and sunny Sacramento, CA, this practice offers the ideal combination of clinical challenge, academic...

  • Caregiver Flexible Hours and Local Clients

    1 week ago

    Sacramento, California, United States Seniors Helping Seniors - Greater Sacramento CA Full time

    Apply today and meet our RecruiterWe understand the importance of having financial stability, a flexible schedule, and a workplace that cares.Starting at $18.50/hr. Excellent work environment (including 24/7 support) and full-time or part-time schedules available for Caregiving positions throughout Sacramento, Carmichael, Arden Arcade, Rancho Cordova, Fair...

  • Certified Professional Coder

    15 hours ago

    Sacramento, California, United States Capleoglobal Inc Full time

    Hybrid – Mostly Remote with Local Travel)Candidates must live within the Sacramento, CA and be available for occasional on-site work and local travel. Positions are structured as 13-week temp-to-hire with conversion opportunities.Title: Pro Fee Coder/ Certified Professional CoderLocation: Sacramento, CA 95815Duration: 13 Weeks (Temp to Hire)Shift: Day...

  • Youth Aide

    6 days ago

    Sacramento, California, United States City of Sacramento, CA Full time

    Youth Aide (Landscape & Learning, Spring)City of Sacramento, CASacramento, California United StatesPosted: Dec 02, 2025Salary: $16.50 Hourly USDFull TimeGrounds and Landscaping ServicesOtherTHE POSITION NON-CAREER PART TIME/SEASONAL The Landscape & Learning (L&L) program is a workforce development program operated by the City of Sacramento Department of...

  • Legal Secretary

    2 weeks ago

    Sacramento, California, United States City of Sacramento, CA Full time $50,000 - $70,000 per year

    Legal Secretary (Exempt)City of Sacramento, CASacramento, California United StatesPosted: Nov 07, 2025Salary: $62, $87,402.85 Annually USDFull TimeClerical and Administrative SupportLegal ServicesTHE POSITION With supervisor approval, incumbents may be eligible for intermittent remote work; however, they must physically reside within the Sacramento region...

  • Community Service Officer I

    2 days ago

    Sacramento, California, United States City of Sacramento, CA Full time

    Community Service Officer I (Limited-Term)City of Sacramento, CASacramento, California United StatesPosted: Nov 02, 2025Salary: $63,508.54 Annually USDFull TimeCommunity and Economic DevelopmentTHE POSITION You must have taken and passed the Community Service Officer I examination for further consideration. To take the examination, click here . Please...