Data Engineer

Join our dynamic technology team as a Data Engineer and take on a crucial role in integrating, processing, and managing data. We seek a skilled professional who excels in backend development, especially in integrating with external systems through APIs. You will work closely with our team to design, implement, and optimize data capture processes, ensuring smooth data flow for analysis and reporting.

Duties include the following. Other duties may be assigned.

• 
  
  
  
  • Collaborate with the operations and business intelligence teams to design and implement robust data capture processes
  • Develop and manage ETL (Extract, Transform, Load) pipelines to ensure efficient data movement from various sources, including external systems
  • Integrate with external systems using APIs, ensuring secure and reliable data synchronization
  • Design and maintain scalable database solutions using Postgres SQL, focusing on data integrity and performance optimization
  • Work with stakeholders to understand data requirements and deliver insightful analytics and reporting solutions
  • Optimize existing data processes and systems to improve efficiency, scalability, and reliability
  • Maintain comprehensive documentation of data processes, system architectures, and API integrations
  • Foster a workplace that upholds Holistic Industries' aim to be the Best Place to Work, Shop and Invest in Cannabis
  • Other duties as assigned, or any reasonable request from any member of management
  
  
  
  

• 
  

  General

  
  
  
  
  • Regulations require that incumbent be at least 21 years of age and able to obtain and maintain medical marijuana work credentials - applicable marijuana licensing regulations may disqualify individuals with certain criminal convictions.
  
  
  
  

  Education/Experience:

  
  
  
  
  • Bachelor's degree in a technology-related field is preferred, or equivalent experience
  • At least 3 years of experience in enterprise software development is required
  • Cannabis industry experience is strongly preferred
  
  
  
  
  

  Required Knowledge and Skills:

  
  
  
  
  • Postgres - Expertise in designing, implementing, and optimizing complex SQL queries and database structures.
  • AWS - Experience with AWS services like RDS, Redshift, Glue + Athena, S3, and ECS/Lambda for data storage, processing, and management.
  • ETL Processes - Proven experience in developing and managing ETL pipelines for data transformation and movement.
  • API Integration - Strong experience in integrating with external systems via APIs, including RESTful services.
  • Backend Development - Proficiency in backend development, with a focus on data integration and synchronization (experience with .NET is preferred)
  • Experience with PowerBI is a plus
  • Version control experience - Git is a plus
  • Able to maintain confidentiality
  • Ability to work collaboratively in a team environment