Data Warehouse Architect

Infinity Natural Resources • Morgantown, WV

70d • Hybrid

About The Position

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. 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.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field required. Will consider an equivalent combination of relevant education and experience.
• 3+ years of experience in data warehouse development and ETL processes.
• Experience with data modeling techniques (e.g., star schema, snowflake schema).
• Solid understanding of SQL Server and PostgreSQL database systems.
• Strong proficiency in SQL, ETL tools, Python, and cloud APIs for data extraction.
• Familiarity with version control systems like Git.
• Understanding of data governance and data security best practices.
• Ability to work independently and as part of a team.
• Excellent organizational and time management skills, with the ability to prioritize tasks and meet deadlines in a fast-paced environment.
• Excellent communication skills with the ability to interact professionally with employees, contractors, vendors, and key stakeholders.

Responsibilities

• 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.

What This Job Offers

• Career Level: Mid Level
• Industry: Oil and Gas Extraction
• Education Level: Bachelor's degree
• Number of Employees: 51-100 employees