Data Engineer
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.
Duties:
- 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, in order to ensure the best data quality is delivered to our customers
- Build new data pipelines (Python, Bash, SQL, Prefect)
- Maintain high quality code using Github and CICD with Github Actions
- Work within AWS to maintain and improve the data pipelines
Qualifications:
- 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.
- Comfortable with ELT vs. ETL.
- Data observability - Data testing - CI/CD - Continuous integration - DataOps are terms that sounds 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
- Familiarity with NodeJs is a plus
- Basic knowledge and/or experience with ML is a plus
- Experience architecting data solutions utilizing Bl tools like Looker, Tableau, AtScale, PowerBI, or any similar is a plus.
- Experience with big data technologies like Hadoop, Spark, Cassandra, MongoDB or other open source big data tools is great but not required.
Company
This job is remote or hybrid if you live in the Chicagoland area. For remote workers we expect a significant degree of competency in working on remote or hybrid teams. We use all the modern tools you'd expect to communicate, plan and build. Our stack is something we consistently get compliments and raves about from our engineers, especially new ones as they are able land, make sene of things and get to work fast!