50% onsite at BNSF in Fort Worth Tx.
Senior Data Modeler -NoSQL and SQL
Position Summary:
BNSF Railway is seeking a qualified Data Modeler to work with IT professionals and business analysts to provide services in support of the development of BNSFs 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 BNSF is an analytical and creative thinker who is not intimidated by roadblocks and challenges. Characteristics of a successful Data Modeler at BNSF 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

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178 .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.