Data Modeler

Top Skills: Must have: • Hands on OLTP (on line transaction processing) modeling • PowerDesigner, Erwin, or similar modeling tool • RDBMS - Oracle, Postgres required (Cockroach gets you to the front of the line) • NoSQL database experience (dynmamo, mongo, aerospike) Nice to have: • Advanced SQL for data analysis and querying • greenfields work in a POC modeling project • DB2 z/OS because that's what we're moving away from Job Description: The Expertise and Skills You Bring • 10+ year’s of experience and a Bachelor’s Degree or equivalent in a technology related field (e.g. Computer Science, Engineering, etc.) with a focus on data analysis, data structures and data modeling • Understanding of different database platforms (e.g. Oracle, Postgresql, CockRoachDB, NoSQL, Snowflake) with a focus on modeling for OLTP recordkeeping applications • Practical knowledge of data lineage from OLTP Recordkeeping to ODS to Data Lakes. • Understanding of modeling strategies (Relational, Dimensional, Unstructured). • Demonstrable experience with data modelling tools (e.g. SAP Power Designer, Erwin). • Experience in executing projects in an Agile environment. • Actively participate in requirements and analysis sessions with business and technical staff to analyze data requirements and recommend appropriate solutions • Delivery of physical data base design from logical models to physical models, including DDL scripts • Outstanding interpersonal and verbal and written communication skills and can collaborate and influence across all levels of the organization • Capable and adept at juggling multiple requests and projects at a time while meeting the various deadlines The Value You Deliver • Participate in helping to drive a Data Driven Culture. • Design and delivery of robust data models for large transactional applications. • Collaboration with team members, DBAs, architects, squad leaders, developers to create scalable data models. • Ensure that database designs and modeling standards are in alignment with Enterprise modeling best practices • Use creativity in helping to solve interesting and challenging design problems