| Data Modeler-Data Analyst|| Sacramento, Ca at Sacramento, California, USA |
| Email: [email protected] |
| From: charu sharma, tek inspirations [email protected] Reply to: [email protected] Data Modeler / Data Analyst 2+ year Contract assignment. *Hybrid work arrangement with 2 office days per week on-site in Sacramento, Ca. HQ.* End Client Name : State of California (CalTrans) Thorough understanding of dimensional modeling tools and techniques (need to speak to specific tools such as ER Studio Data Architect, etc.) What process would be used to develop data models, which models will be created and for who (e.g., Conceptual, Logical, and Physical) Ability to speak confidently and in-depth about the Kimball Framework (or similar frameworks) Ability to describe the various deliverables (work products) that would be produced as part of the DW design and implementation Describe the process of moving data from source systems into the DW (ETL/ELT, Staging Tables, Data Quality, Business Rule, etc.) Visualizing and designing the enterprise data management framework will be integral, along with documenting data flow diagrams for existing and future reports. You will spearhead Requirements and Design Specifications while conducting data analysis and predictive modeling. If you're ready to make a significant impact and drive innovation, join us on this exciting journey! Data Analyst/Data Modeler: Key Duties/Responsibilities: Performs business and systems analysis and documentation Develops conceptual and dimensional data models for the enterprise data warehouse 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 Develops Requirements Specifications Develops Design Specifications Performs data analysis/predictive data modeling Mentors and educates team members on best practices and industry standards Mandatory: 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 relevant experience in relational data modeling and dimensional data modeling, statistical analysis, and machine learning supportive of key duties/responsibilities identified above. Desired: Expert level Kimball Dimensional Data Modeling experience Expert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle. Warm Regards.. Charu Sharma IT Technical Recruiter TEK Inspirations LLC | 13573 Tabasco Cat Trail, Frisco, TX 75035 Email: [email protected] Disclaimer : If you are not interested in receiving our e-mails then please reply with a " REMOVE " in the subject line to [email protected] . And mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience Keywords: information technology California Texas Data Modeler-Data Analyst|| Sacramento, Ca [email protected] |
| [email protected] View all |
| Mon May 06 21:14:00 UTC 2024 |