Data Warehouse Developer
Infinity Natural Resources
- Morgantown, WV
- Permanent
- Full-time
We are seeking an experienced Data Warehouse Developer 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.
- 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.
- 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.
- 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.