Data Modeler

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