X
Business Analyst
Job #: 88471
Details
8/19/2025 6:07:58 PM
We are seeking a senior, hands-on Data Analyst / Data Modeler for a long-term hybrid
Rate $65-$70 C2C The position is with the State of California - ONLY send candidates who currently live within 60 miles maximum from Sacramento, CA Candidates must have a LinkedIn profile with a picture of anyone without will be rejected Any Visa Team Viewer Interviews ALWAYS provide your consultants with full name-(What is on their Visa), resume, phone number, Skype address, rate, email address, and location. Without the information requested, we cannot move forward. Please do not call or send follow-up emails, as that will only slow down our ability to respond to you quickly. Description 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 that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client. Key Duties/Responsibilities: * Performs business and systems analysis and documentation * Develops conceptual, logical, and dimensional 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 * Develops Data Facts and Dimensions in the EDW * Provides documentation to support the Kimball Dimensional Data Modeling Framework * 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 * Development Requirements Specifications * Develop Design Specifications * Performs data analysis/predictive data modeling * Mentors and Education team members on best practices and industry standards Requirements: * Excellent communication and collaboration skills to work effectively with stakeholders and team members. * Ability 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 in the job description above. * 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 in the job description above. * At least 2 years' experience working on Star, Snowflake, and/or Hybrid schemas * 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. 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 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.
;
+ Collection
Inquire
Submit Resume