Job ID: TX-455-25-25660 (911090214)
Remote TX Govt Data Modeler/BA (15+) with RTM, use cases, prototyping, SQL Server, SSIS, .Net, Azure DevOps, Oracle, mainframe, Informatica, MuleSoft, COBOL, Java, Salesforce, Snowflake, GoAnywhere, and Oil/Gas industry experience
Location: Austin, TX (RRC)
Duration: 5 Months
Position: 1
Skills:
7+ Required Business analysis experience with a focus on data modeling and data flow for software development projects; including the prepar ation 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 documenta tion, using DBSchema or similar (specify in response)
Preferred Familiarity with mainframe environments, including hierarchical d atabases and their limitations; relational databases; Informatica, MuleSoft, COBOL, Java, Salesforce, Snowflake and GoAnywher e.
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 Bachelor’s Degree in Computer Science, Business Administration or related discipline or equivalent work experience.
Job Description – Proposed
The position would perform data modeling which includes data analysis and data architecture
work along with designing and developing/enhancing database systems for software projects
included in the Mainframe Transformation Program at the Railroad Commission of Texas
(RRC). The focus of the work is to elicit requirements and analyze existing data and systems
for the purpose of creating or enhancing existing database solutions to transform legacy
systems data to modern normalized database solutions. 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.
Duties involve the use of multiple methods in gathering, developing, and documenting
requirements; the review, assessment, and development of data models/designs, which
includes design documentation; the creation and validation of user acceptance testing; and
research and special project support provided to users. This role will work under minimal to
moderate direction, with latitude for the use of initiative and independent judgment.
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 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