What are the responsibilities and job description for the Data Modeler position at Daman?
Job Title: Data Modeler
Job Location: Remote
Job type: 6 Months Contract
Client: Railroad Commission of Texas
Job Id: 455-25-25660
Job Description
• Thorough understanding of the software development lifecycle
• Determines and documents database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems to create or improve database solutions.
• Based on requirements, develops and implements data models for new projects, and maintains and/or enhances existing data models and data architectures.
• Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply.
• Develops data structures for transactional systems; and
• Provides guidance for business intelligence systems, as required.
• Implements new database solutions and/or corresponding database changes to support new and modified applications and ensures that new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.
• Creation of technical documentation for process and interface documentation
• Follows guidelines on creating data models and various standards relating to governed data. This includes the ability to appropriately classify personally identifiable information.
• Collects, queries, and analyzes data using standard database tools, applications, methods, and techniques for the purposes of creating normalized database solutions.
• Knowledgeable of Change Data Capture (CDC) for bulk data movement
• Ability to promote code from development environments to production
• Familiarity with GitHub or equivalent version control systems
• Experience with:
o Oracle databases
o SQLServer databases
o Database Modeling tools, like DBSchema
o Mainframe IMS hierarchical databases
• Knowledge of
o Informatica
o Microsoft SSIS
• Ability to provide status reports and project progress reports to stakeholders and project managers
• Performs related work as assigned
Required
• Business analysis experience with a focus on data modeling and data flow for software development projects; including the prepareation of project related documentation, data model and data flow documentation, and creation of database design documentation and structures for deployment
• Strong interpersonal, collaborative, analytical, written/verbal/ presentation communication skills in English (specifically technical writing); and well versed with MS Office suite of products and prototyping/screen mock-up tools such as Visio and SnagIt
• Hands-on requirements elicitation; client management and technical documentation including traceability, use cases, prototyping, and data modeling.
• Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel.
• Facilitating interactive sessions with business and cross functional teams.
• Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel.
• Defining functional design and systems specifications; preparing/ reviewing/delivering completed packages.
• Participating in and providing guidance to Business and Functional Units in developing and completing user acceptance testing, training, and implementation-related activities.
• Experience SQL, including MS SQL Server.
• Experience in SSIS and .Net development environments; Azure DevOps; Oracle; and analysis of data bridges.
