Data Warehouse Architect

Morgantown, WV - USA

Monthly Salary: Not Disclosed

Posted on: 26 days ago

Vacancies: 1 Vacancy

Job Summary

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

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

Required Experience:

Manager

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

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

Required Experience:

Manager