

Data Modeler
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Modeler with an 8+ year background in data modeling, SQL, and ETL solutions. Contract length is unspecified, with a competitive pay rate. Remote work is allowed. Industry experience in Oil and Gas is preferred.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
-
ποΈ - Date discovered
July 17, 2025
π - Project duration
Unknown
-
ποΈ - Location type
Unknown
-
π - Contract type
Unknown
-
π - Security clearance
Unknown
-
π - Location detailed
United States
-
π§ - Skills detailed
#SaaS (Software as a Service) #Documentation #Java #SQL Server #Computer Science #Compliance #SSIS (SQL Server Integration Services) #Azure #"ETL (Extract #Transform #Load)" #Oracle #SQL (Structured Query Language) #DevOps #Databases #Azure DevOps #Business Analysis #Snowflake #MS SQL (Microsoft SQL Server) #.Net #Informatica #Migration #R #Data Modeling #Data Warehouse #UAT (User Acceptance Testing)
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
The focus of the work is intended to be data-related, including data modeling, data bridging, root cause analysis of data errors, and data flow documentation. Requires knowledge and background in Microsoft SSIS, MS SQL Server, and Oracle as well as awareness of the full environment technical stack of Informatica, MuleSoft, COBOL, Java, Salesforce, .NET, Oracle, Snowflake and GoAnywhere. Work will be to review or develop written documentation for coding or correction of ETL solutions between Microsoft SSIS and Oracle platforms, among other work.
Duties involve use of multiple methods in gathering, developing, and documenting requirements; the review, assessment, and development of business processes; the creation and validation of user acceptance testing; and research and special project support provided to users. This role will work under limited to minimal direction, with considerable latitude for the use of initiative and independent judgment.
This position will be responsible for analysis and documentation in the implementation of multiple inter-related projects (including implementation of software applications in Software as a Service (SaaS) or Commercial off the Shelf (COTS), migration of data from the mainframe to the new systems and building a Data Warehouse). This position also ensures that deliverables and materials are produced and maintained in accordance with established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. May assign and/or supervise the work of others. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
II.Β Β Β Β Β Β Β Β Β Β Β Β Β Β CANDIDATE SKILLS AND QUALIFICATIONS
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.
Years
Required/
Preferred
Experience
8+
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.
8+
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 and SnagIt.
8+
Required
Hands-on requirements elicitation: client management and technical documentation including traceability, use cases, prototyping, and data modeling.
8+
Required
Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel.
8+
Required
Facilitating interactive sessions with business and cross functional teams.
8+
Required
Strong analysis experience and expertise in assessing Production Support issues related to system and/or data bridges to determine Root Cause and document items needed for data or system correction.
8+
Required
Developing/maintaining an understanding of key business drivers
/impacts, assisting clients with identifying and solving business-r elated system and data errors.
8+
Required
Facilitating analysis of business and functional requirements and design of technology specifications, working with business / functional personnel.
8+
Required
Defining functional design and systems specifications; preparing/ reviewing/delivering completed packages.
8+
Required
Participating in and providing guidance to Business and Functional Units in developing and completing user acceptance testing, training, and implementation-related activities.
4+
Required
Experience SQL, including MS SQL Server; SSIS and .Net development environments; Azure DevOps; Oracle; and analysis of da ta bridges.
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
Bachelorβs Degree in Computer Science, Business Administration or related discipline or equivalent work experience.