Senior Data Architect

Company: OmniForce Solutions
Location: Houston
Posted on: January 27, 2023

Job Description:

Our client is one of the largest publicly traded partnerships and a leading North American provider of midstream energy services to producers and consumers of natural gas, natural gas liquids (NGLs), crude oil, refined products and petrochemicals. They have a beautiful office located in Downtown Houston and are looking to add an experienced Data Architect to their Big Data and Advanced Analytics team!

Summary:
The Data Architect will work closely with business domain experts to create a Data Lakehouse to support data analytic use cases for the Natural Gas Gathering, Processing, and Transformation business units.

Responsibilities:

• 
  
• Analyze business scenarios and translate into data flows and data models
  
• Advise on data interactions and data interdependencies between business functions and applications and recommend solutions to common business problems
  
• Develop and maintain conceptual and logical data models
  
• Design and implement a Data Lakehouse solution which accurately reflects business operations
  
• Assist with data platform performance tuning and physical data model support
  
• Provide guidance in data visualizations and reporting efforts to ensure solutions are aligned to business objectives
  
  
  Qualifications:
  
  • 
    
  • 10+ years of experience as a Data professional
    
  • 5+ years of experience as a Data Architect with experience in designing and maintaining conceptual, logical, and physical data models
    
  • Experience in data management practices including data catalog, data lineage, and master data management
    
  • Experience in business analysis and defining business performance metrics
    
  • Experience in software development practices such as Design Principles and Patterns, Testing, CI/CD, and version control
    
  • Expert knowledge of ANSI SQL, PLSQL, and TSQL
    
  • Experience in implementing a Data Lakehouse using Apache Iceberg or Delta Lake
    
  • Knowledgeable of common data visualization tools such as Power BI and Tibco Spotfire
    
  • Experience in presenting and explaining complex concepts to stakeholders
    
  • Experience in the Oil & Gas industry is preferred
    

Keywords: OmniForce Solutions, Houston , Senior Data Architect, Other , Houston, Texas