Chelsoft Solutions Co. ยท 1 month ago
Data Modeler with ODI & ADW & OCI_60 miles from Sacramento, CA_Oracle Certification Required
Sacramento, CA
Contract
Onsite
Senior Level, Lead/Staff
10+ years expChelsoft Solutions Co. is seeking a Senior Data Modeler with expertise in data management. The role involves developing and documenting data models for the enterprise data warehouse and mentoring team members on best practices.
Information Technology & Services
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
Qualification
Required
Required To Have State/Gov Experience
Certs: Oracle
ODI & ADW & OCI Experience
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
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
Preferred
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
Company
Chelsoft Solutions Co.
Inc. 5000 Fastest Growing Pvt. Companies in USA 5 yr Honoree; Ingrams 4yr Honoree; 2014 MBE Award Winner in State of KS
51-200 employees
H1B Sponsorship
Chelsoft Solutions Co. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (15)
2024 (12)
2023 (21)
2022 (26)
2021 (18)
2020 (70)
Funding
Current Stage
Growth StageCompany data provided by crunchbase