Job Title: Data Modeler II
Location: Houston, TX or Calgary, AB (Hybrid – work from home on Wednesdays and Fridays)
Type: W2 Contract (USA)/INC or T4 (Canada)
Work Setup: Hybrid (On-site with flexibility to work from home two days per week)
Industry: Oil & Gas
Benefits: Health, Dental, Vision
Job Summary
We are seeking a Data Modeler II with a product-driven, innovative mindset to design and implement data solutions that deliver measurable business value for Supply Chain operations. This role combines technical expertise with project management responsibilities, requiring collaboration with IT teams to develop solutions for small and medium-sized business challenges. The ideal candidate will have hands-on experience with data transformation, AI integration, and ERP systems, while also being able to communicate technical concepts in clear, business-friendly language.
Key Responsibilities
- Develop innovative data solutions leveraging knowledge of Supply Chain processes and oil & gas industry value drivers.
- Design and optimize ETL pipelines for scalable, high-performance data processing.
- Integrate solutions with enterprise data platforms and visualization tools.
- Gather and clean data from ERP systems for analytics and reporting.
- Utilize AI tools and prompt engineering to enhance data-driven solutions.
- Collaborate with IT and business stakeholders to deliver medium and low-level solutions for local issues.
- Oversee project timelines, resources, and stakeholder engagement.
- Document project objectives, requirements, and progress updates.
- Translate technical language into clear, non-technical terms for business users.
- Support continuous improvement and innovation in data engineering and analytics.
Basic / Required Qualifications
- Bachelor’s degree in Commerce (SCM), Data Science, Engineering, or related field.
- Hands-on experience with:
- Python for data transformation.
- ETL tools (Power Automate, Power Apps; Databricks is a plus).
- Oracle Cloud (Supply Chain and Financial modules).
- Knowledge of ERP systems (Oracle Cloud required; SAP preferred).
- Familiarity with AI integration and low-code development platforms.
- Strong understanding of Supply Chain processes; oil & gas experience preferred.
- Ability to manage projects and engage stakeholders effectively.
- Excellent communication skills for translating technical concepts into business language.
Required Knowledge / Skills / Abilities
- Advanced proficiency in data science concepts, including statistical analysis and machine learning.
- Experience with prompt engineering and AI-driven solutions.
- Ability to clean and transform data for analytics and reporting.
- Strong documentation, troubleshooting, and analytical skills.
- Business-focused mindset with technical expertise.
- Ability to think outside the box and propose innovative solutions.
Special Job Characteristics
- Hybrid work schedule (Wednesdays and Fridays remote).
- Ability to work independently and oversee own projects.