Data Warehouse Architect

Job Description

Job Description

Infinity Natural Resources (NYSE : INR), is an oil and gas exploration and production company deeply rooted in the Appalachian Basin. Headquartered in Morgantown, WV, we are committed to responsible energy development, operational excellence, and strong environmental stewardship across our growing operations in Ohio and Pennsylvania. We pride ourselves on a collaborative work environment, a team dedicated to innovation and safety, and our strong connection to the Appalachian Basin, the region we proudly call home and operate within.

The Opportunity

We are seeking an experienced Data Warehouse Architect to join our team. This role is responsible for designing, developing, and maintaining our data warehouse infrastructure and requires a proven track record of managing large-scale databases, ensuring high availability, and implementing robust backup and recovery strategies. You will play a critical role in transforming source data into valuable business insights by building scalable, high-performance data pipelines and data models. The ideal candidate has a strong understanding of data warehousing concepts, ETL processes, and database architecture.

Location

This role is a hybrid position based out of our office in Morgantown, WV and will be expected work onsite in the office three days per week.

What You Will Be Doing

• Design, develop, and optimize data warehouse architectures and data models to support business intelligence and reporting needs.
• Develop robust ETL / ELT processes to extract, transform, and load data from various sources into the data warehouse.
• Collaborate with data analysts and business stakeholders to understand data requirements and ensure data quality and accuracy.
• Maintain and optimize existing data pipelines for performance, scalability, and reliability.
• Ensure proper documentation, metadata management, and data governance practices are followed.
• Monitor data warehouse performance and troubleshoot issues as they arise.
• Implement data validation and data quality checks throughout the data lifecycle
• Work with Azure cloud platform and on-premise systems as needed.

Your Background

Working Conditions

Physical Requirements

Infinity Natural Resources is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.

If you need assistance or an accommodation due to a disability, you may contact us at humanresources@infinitynr.com.

Powered by JazzHR

jKDYXMase5