What are the responsibilities and job description for the Data Warehouse Developer position at iLocatum?
About The Company
Our Client is headquartered in Morgantown, WV. Their success is built on a collaborative culture, where innovation, safety, and a deep connection to the communities they serve are at the heart of everything they do.
The Role
Our Client is searching for an experienced Data Warehouse Developer who thrives on building reliable, scalable data solutions that power business insights. In this role, you’ll own the architecture, development, and maintenance of the data warehouse ecosystem, ensuring mission-critical systems are fast, secure, and resilient. You’ll be instrumental in turning raw data into actionable intelligence, directly supporting decision-making and business growth.
Location
This is a hybrid role based in Morgantown, WV. The selected candidate will work onsite three days a week, with flexibility for remote work on other days.
Key Responsibilities
This is an opportunity to contribute to a forward-thinking energy company that values innovation, sustainability, and community connection. You’ll be joining a team where your work truly makes an impact—transforming data into knowledge and driving smarter business decisions in a fast-paced, evolving industry.
Our Client is headquartered in Morgantown, WV. Their success is built on a collaborative culture, where innovation, safety, and a deep connection to the communities they serve are at the heart of everything they do.
The Role
Our Client is searching for an experienced Data Warehouse Developer who thrives on building reliable, scalable data solutions that power business insights. In this role, you’ll own the architecture, development, and maintenance of the data warehouse ecosystem, ensuring mission-critical systems are fast, secure, and resilient. You’ll be instrumental in turning raw data into actionable intelligence, directly supporting decision-making and business growth.
Location
This is a hybrid role based in Morgantown, WV. The selected candidate will work onsite three days a week, with flexibility for remote work on other days.
Key Responsibilities
- Architect, build, and maintain high-performance data warehouse solutions tailored to business intelligence and reporting needs.
- Design and optimize ETL/ELT pipelines to integrate diverse data sources into a unified warehouse environment.
- Partner with analysts and business stakeholders to translate requirements into effective data models and ensure accuracy, integrity, and accessibility of data.
- Monitor, troubleshoot, and tune systems for reliability and speed.
- Establish strong data governance, validation, and documentation practices to support compliance and security.
- Leverage both Azure cloud platforms and on-premise systems to deliver flexible, modern solutions.
- Bachelor’s degree in Computer Science, IT, or a related field (or equivalent experience).
- 3 years of proven success in data warehouse development and ETL process design.
- Expertise in data modeling (e.g., star and snowflake schema).
- Strong working knowledge of SQL Server, PostgreSQL, and advanced SQL techniques.
- Hands-on experience with ETL tools, Python, and cloud-based APIs.
- Familiarity with Git or other version control systems.
- Deep understanding of data governance and security principles.
- Exceptional problem-solving, time management, and collaboration skills.
- Excellent written and verbal communication skills, with the ability to engage effectively across technical and business teams.
This is an opportunity to contribute to a forward-thinking energy company that values innovation, sustainability, and community connection. You’ll be joining a team where your work truly makes an impact—transforming data into knowledge and driving smarter business decisions in a fast-paced, evolving industry.
