Data Warehouse Architect

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

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

Working Conditions

- Regular use of a computer and other office equipment is necessary.

- Interaction with team members and external contacts is a regular part of the job.

Physical Requirements

- Sitting for extended periods while working on a computer or conducting meetings.

- Occasional lifting of objects or materials up to 15 pounds.

- Ability to communicate verbally and in writing.

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.

jKDYXMase5