What are the responsibilities and job description for the Data Modeler Data Architect Production Optimization position at Bright Mind Solutions LLC?
Job Title : Data Modeler / Data
Architect Production Optimization
Location : Spring TX 77389
Job Type : 12 Months ( Long Term Contract )
Job Role Summary :
Clients Upstream Data Office has a mission to develop Upstream enterprise data products in support of the Upstream business strategies to treat data as an asset to maximize business value. The Data Architect will work closely with other Data Architects IT Platform Architects subject matter experts (SMEs) data engineers and developers to contribute to the design of data products and consult with Upstream projects to ensure data architecture is aligned with enterprise data principles and standards. The data architect will work with business contacts in the Product Optimization team and focus on data within this domain.
J ob Requirements :
Masters or Bachelors degree in business computer science engineering systems analysis or a related field
Minimum 3 years of experience in data design / architecture and strong willingness to continue learning
Minimum 3 years of experience in Upstream Oil and Gas Production Optimization Production Volumes and Production Revenue Accounting
Recent experience developing reference data architecture data modeling (conceptual logicalphysicaland Type 2 Dimensional Modelling) data profiling data quality analysis building business data glossaries and data catalogs
Knowledge regarding data governance and master / reference data management programs
Experience using Snowflake SQL query language and E / R Studio data modeling tool
Able to design solutions around RoleBased Access (RBA)
Experience working with agile delivery teams
Effective planning communication collaboration and persuasion skills to drive needed change across the company
Expert written and verbal communication skills; familiarity with SharePoint team sites to collaborate; selfstarter takes initiative and is able to work in a fastpaced environment
Preferred Skills & Experience :
Experience and knowledge of Upstream Oil & Gas Production Optimization Production Volumes and Production Revenue Accounting business processes and business terms
Experience with tools such as TAMR Collibra and ER Studio
Understanding of large data store technologies (Data Lakes Data Warehouse Data Hubs etc.) Specifically Snowflake
Experience with Type 2 Dimensional Modelling
Knowledge of JSON Python GIT; understanding of API concepts and integration architecture
Knowledge of TOGAF Framework and DAMA DMBoK v.2 desirable
Knowledge and experience working with Rolebased access
Leadership : Strong interpersonal skills with ability to influence without direct authority; able to effectively interact with large and diverse user community
Strong background in data analytics systems and tools : good working knowledge of OSDU Graph ADX NoSQL and other modern data storage solutions and related data extraction tools
Familiarity with Upstream Data common workflows and data sources / repositories
Job Responsibilities :
The UDO Data Architect Production Optimization will work towards building and / or providing knowledge in support of the overall Upstream Data Office mission and data strategy. To achieve these goals the Data Architect will be required to analyze current state data architectures and conceive desired future state data architectures and identify activities needed to close the gap to achieve the future state within Production Optimization. Some examples of these activities / deliverables are :
Develop and maintain UDO conceptual and logical data models type 2 dimensional models data flow diagrams and conceptual data architecture designs in support of the Production Optimization Business Capability which include production volumes and production revenue accounting processes and terms.
Collaborate with Data and IT Architects in defining UDO architectural standards by developing UDO Architectural Decision Records (ADRs)
Provide data architectural and modeling support guidance and mentorship to data engineering product teams to ensure they can successfully deliver support and where applicable standardize data products
Partner with IT to ensure Upstream Data Foundation Data Platforms and related tooling satisfies UDOs business needs
Work with Data Governance teams to ensure business glossaries data dictionaries and data catalogs are created and maintained
Drive strategies / approaches and principles for data management (including master / reference data and identification of key data domains data governance framework data integration etc.)
Ensure data architecture of solutions delivered by data engineering teams support proper data security retention and classification and are aligned with existing data architectural standards data models and data flows
Partner with data product owners data engineers business SMEs data stewards data custodians and data governance groups to support business data needs
If you are interested or have any references please share resume at
