| Data Modeler, Level 2 at Remote at Remote, Remote, USA |
| Email: [email protected] |
|
Hi Good Morning, Hope you are doing well We have a position for the below requirement. Role: Data Modeler, Level 2 Location: Remote Experience: 12 Years & Above Job Id: State of TX- Railroad Commission of Texas Duration: 6-12 Months The position requires knowledge and background in MS SQL Server, Oracle, and Mainframe IMS Hierarchical databases, significant experience in development of data modeling documentation, as well as awareness of the full environment technical stack of Microsoft SSIS, Informatica, MuleSoft, COBOL, Java, Salesforce, .NET, Oracle, Snowflake and GoAnywhere. Responsibilities and Skills include: 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 SQL Server 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. Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | Actual Years Experience | Years Experience Needed | Required/ Preferred | Skills/Experience | 7+ | Required | Business analysis experience with a focus on data modeling and data flow for software development projects; including the preparation of project related documentation, data model and data flow documentation, and creation of database design documentation and structures for deployment. | 7+ | Required | 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 an d SnagIt | 7+ | Required | Hands-on requirements elicitation; client management and technical documentation including traceability, use cases, prototyping, and data modeling | 7+ | Required | Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel | 7+ | Required | Facilitating interactive sessions with business and cross functional teams. | 7+ | Required | Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel | 7+ | Required | Defining functional design and systems specifications; preparing/ reviewing/delivering completed packages. | 7+ | Required | Participating in and providing guidance to Business and Functional Units in developing and completing user acceptance testing, training, and implementation-related activities | 7+ | Required | Experience SQL, including MS SQL Server | 4+ | Required | Experience in SSIS and .Net development environments; Azure DevOps; Oracle; and analysis of data bridges. | Preferred | Experience in data model development and data flow documentation, using DBSchema or similar (specify in response) | Preferred | Familiarity with mainframe environments, including hierarchical databases and their limitations; relational databases; Informatica, MuleSoft, COBOL, Java, Salesforce, Snowflake and GoAnywhere | Preferred | Experience with process improvement strategies and methodologies | Preferred | Proven ability to lead change and design more efficient processes. | Preferred | Experience in Oil and Gas industry as well as general compliance and enforcement related projects as a Business Analyst with a focus on data, databases, and data bridges | Preferred | Proven ability to work compatibly within multifaceted teams; resolve conflict; and deal with challenging situations | Preferred | Bachelors Degree in Computer Science, Business Administration or related discipline or equivalent work experience | Best Regards, Jason Technical Recruiter 832.937.7008 | [email protected] 02/04/25, 03:41:42 PM | -- Keywords: information technology microsoft Idaho Texas Data Modeler, Level 2 at Remote [email protected] |
| [email protected] View All |
| 02:13 AM 05-Feb-25 |