Hoodie Analytics supports Cannabis brands, consumers, and retailers with a comprehensive suite of analytics, apps, and data enabled services that provide marketplace intelligence on sales, distribution, price and promotion.
We are hiring a full-time engineer dedicated to supporting our efforts in source system integration and data enrichment. The ideal candidate will collaborate with a team to identify new and novel approaches to apply engineering solutions to improve quality and speed of work within a data warehouse while leveraging big data solutions, integrations and self-service tooling
Responsibilities
- Data modeling within a data warehouse
- Data cleansing using SQL, Python, and Bash scripts
- Propose and implement data cleansing/enrichment strategies
- Implement and Monitor a Data Quality framework, to ensure the best data quality is delivered to our customers
- Build new (ELT, ETL) data pipelines (Python, Bash, SQL, Prefect)
- Maintain high-quality code using Github and CICD with GitHub Actions
- Work within AWS and Snowflake to maintain and improve the data.
Qualifications
- 5+ years experience with ETL
- Comfortable with ELT vs. ETL.
- 5+ years experience working with data-centric/big data/data-warehousing projects
- Proficient with Git, Github including Actions, Basic Linux, and Bash scripting
- Expert in Python for data engineering, including using DBT
- Expert in SQL. Experience in >1 dialect is a plus, ideally Snowflake and Postgres.
- Data observability – Data testing – CI/CD – Continuous integration – DataOps and DevOps are terms that sound familiar
- Experience using Prefect for orchestration (Airflow experience can be useful)
- Well-versed in AWS. Lambda – SQS – EC2 – S3 – ECR – Batch – Glue – IAM
- Proficient in using APIs, both REST and GraphQL
- Experience using Docker as part of data pipeline architecture
Nice to haves:
- Familiarity with JavaScript and NodeJs
- Basic knowledge and/or experience with ML
- Experience and passion for generative AI
- Experience with any of the following technologies:
- Tableau Server
- CloudFlare
- Postgres
- Algolia
What's In It for You
- Competitive base salary, healthcare, PTO, stock options
- Work with other high-caliber engineers
- Working on really hard, unsolved problems in Big Data and Machine Learning and using cutting-edge technologies to do so
- Flexible working hours – as long as high-quality work gets done