Senior Data Modeler -NoSQL and SQL
Location: Fort Worth, TX (50% onsite)
Contract Length: Up to 24 Months
Contract Type: W2
Visas Accpeted: USC or GC (GC-EAD is okay)
Position Summary:
The client is seeking a qualified Data Modeler to work with IT professionals and business analysts to provide services in support of the development of client's future state data architecture and application modernization activities. The candidate will be in an expert role and work closely with Business DBA ETL and Data Management teams providing solutions for complex data related initiatives.
An ideal Data Modeler at is an analytical and creative thinker who is not intimidated by roadblocks and challenges. Characteristics of a successful Data Modeler include:
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
Knowledge of the railroad and/or freight transportation industry- Experience with working with GitHub repositories is highly desirable.
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
Requirement: Bachelor's degree in Computer Science, IT, or a related field with at least 3 years of related work experience.