Tech Lead

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:

• 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

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