Description

Description/Responsibilities

Client seeking a qualified Data Modeler to work with IT professionals and business analysts to provide services in support of the development of Client future state data architecture and application modernization activities - 50% onsite, FTW.

Position Summary:

•           ability to determine when good is good enough to balance quality and delivery deadlines

•           comfortable in a sea of ambiguity

•           socratic method: ask a lot of Why, clarifying and probing questions

•           empathetic and curious

•           effective translator between technical and non-technical audiences

What You’ll Get to Do:

  • Design and maintain data models for operational and analytical systems with input from Solution Architects and Business Analysts
  • Design and maintain data schemas for event/message publishing and integration
  • Design and maintain data schemas for NoSQL platforms
  • Ensure data decisions are consistent and best practices are adhered to
  • Ensure data definitions, metadata management, business glossary, and data lineage are kept up to date and accessible
  • Champion enterprise data policies, procedures, and standards
  • Provide mentoring to team members

What You Must Bring:

  • 5 years’ data modeling experience
  • Experience at gathering and documenting requirements and translating them into data models
  • Experience in designing logical and physical relational data models
  • Designing data model structures for reuse
  • Experience with analytical modeling; Inmon and/or Kimball modeling techniques
  • Experience designing NoSQL data models using XML Schema (XSD), JSON Schema, and Avro.
  • Experience adhering to data naming standards and writing good data definitions
  • Solid knowledge of Data Governance and Management Concepts (MDM, Data Quality)
  • Experience in both waterfall and agile development practice
  • Demonstrate critical thinking, analytical skills, and employ judgment to offer thoughtful, concise input toward resolutions of problems
  • Pay attention to detail and is meticulous in their work

What You Should Bring:

  • Fluency in writing SQL
  • Design experience with Databricks Delta Lake and Teradata
  • Experience in designing data models for NoSQL environments such as Kafka, Cassandra, MarkLogic, and MongoDB
  • Basic understanding of REST API resources
  • Experience with data modeling tools such as PowerDesigner and Hackolade
  • Experience with working with GitHub repositories is highly desirable.
  • Knowledge of the railroad and/or freight transportation industry

Professional/Personal Skill Requirements:

  • Exceptional and clearly understandable English in support of both verbal and written communication requirements
  • Effective communication at different levels (i.e. junior team members, peers, management, senior management) of the organization
  • Ability to facilitate small groups of application development and/or business users during data requirements and design sessions
  • Able to work independently and in a team
  • Strong leadership skills
  • Strong problem-solving skills
  • Excellent interpersonal skills


 

Education

Any Gradute