Data Engineer II

The Role You Will Have:

• Gather requirements, understand the big picture, create detailed proposals in technical specification documents.
• Proof of concept evaluations of new technologies, new features, patterns, frameworks, API.
• Productizing data ingestion from various sources, data delivery to various destinations, and the creating well-orchestrated data pipelines.
• Consolidate and modernize the codebase.
• Continuously improve monitoring and alerting coverage.
• Communicate effectively with upstream / downstream stake-holders, with clear understanding of data contracts or dependencies.
• Conduct SQL data investigations, data quality analysis and optimizations.
• Work in a transparent, and agile team environment, supporting the peers.
• Perform maintenance of existing infrastructure, improving efficiency and costs.
• Contribute in peer code reviews, and help the team produce high quality code.

What You Will Bring:

• Bachelors or Masters degree in Computer Science/Engineering.
• Excellent communication skills.
• Strong SQL proficiency, and preferably SQL query optimization experience.
• Programming expertise in Python, Scala, and/or Java.
• Experience in databases like Postgres, MySQL, Oracle or SQL Server.
• Familiarity with one of the Cloud data-warehouses like Snowflake, Google BigQuery, AWS Redshift, Azure Synapse, Databricks.
• Good understanding of data modeling, database design, relational/non-relational concepts.
• Good understanding of data engineering fundamentals, ELT / ETL, latency, observability, lineage, distributed storage and distributed computing.
• Familiarity with software production engineering practices, version control, code peer reviews, automated testing, and CI/CD.
• Cloud ecosystem experience within AWS, GCP, or Azure experience, is a plus.
• Experience with modern orchestration platforms, such as Airflow, is a plus.
• Familiarity with docker, kubernetes containerization strategies and optimization, is a plus.
• Working knowledge of dbt and jinja macros, dbt docs, dbt test is preferred, but not required.
• Any experience collaborating with business intelligence, data analytics, data science stake-holders, is a plus.

What We Have to Offer:

• Competitive salary + bonus + equity
• Generous PTO + 11 company holidays
• Open sick time
• Medical, Dental & Vision 
• RRSP w/matching
• Paid professional development
• Leadership & growth opportunities
• Virtual company and team building events