Data Engineer
Bright Cellars
What You’ll Do:
- Design, develop, test, implement, and support reliable, performant, and scalable database application solutions with a strong focus on the customer and delivering business value, including data warehouse and data mart
- Work cross functionally with the team and stakeholders to gather requirements and implement data-enabled solutions
- Develop, maintain, and support data ETL/ELT processes to populate the data warehouse from various data sources
- Perform database performance tuning, deployments and engage in performance management tasks including administrative, maintenance tasks, backup/recovery and tuning
Experience We’re Looking For:
- Proficient with Python, MySQL, and PostgreSQL
- Working knowledge of AWS cloud service (e.g. EC2, RDS, S3)
- Hands-on experience in designing and building data pipelines using tools like Stitch Data and dbt
- Experience in working with workflow management tools (e.g Apache Airflow)
- Strong knowledge in data warehouse concepts, dimensional modeling, Data modeling, Data ETL/ELT and data mart
- Knowledge of Agile software methodology and ability to work in a fast-paced environment
- Experience in a DevOps culture with focus on continuous integration, test automation, automated deployments, and monitoring/alerting telemetry
- Knowledge on cloud Data Warehouse databases (e.g. Snowflake, Redshift)
- Strong cross-functional communication skills that help simplify and move complex problems forward with business partners
Who You Are:
- You’re an Innovator - You enjoy working with new technologies ranging from the frontend to backend, and are particularly passionate and an expert in multiple stacks
- You’re A Problem Solver - You have strong experience with various technologies, and know how to pick the right tool for any job
- You’re a Team Player - You love to collaborate closely with the team to brainstorm ideas, gather requirements, and review and improve code
- You’re Driven - You have the ability to take initiative and work with minimal supervision
- You’re Curious - You are naturally curious and have an interest in learning new things.