About Sterling Brokers

Sterling Brokers is disrupting the Group Benefits and Retirement landscape in Canada through our innovative application, integrating with the largest insurance carriers in Canada and global HRIS platforms, to administer a streamlined solution. We are the largest independently owned and operated Third Party Administrator (TPA) and Broker in Canada, and 4th largest overall. Established in 2014, SCB is growing rapidly and looking for talented individuals to join our team.

About The Role

The Full Stack Data Engineer is a software development role, focused on data engineering, data pipelines, and business analytics with opportunities to work on statistical analysis, machine learning, data presentation visualization projects . Full stack in this context means being responsible from data ingestion (either machine readable or via OCR type technologies), storing, analyzing, and reducing data to actionable information. The team is currently tiny but mighty, comprised of one other full stack engineer, an engineer focused on presentation (Tableau/Power BI), and a program manager, so you will be involved in all aspects of our data platform.

Sterling Capital Brokers' headquarters is in Toronto. The development team is currently split between Vancouver and Toronto. You can live/work from anywhere in Canada, if you are willing to adjust your working hours to match the team you are working in.

What You'll Do

Maintain, augment, and establish data pipelines from multiple sources into our data warehouse/data lake Databricks
Play a strong role in the design and architecture of the data infrastructure
Ensure performance, scalability, and reliability of our data environment
Interact with business and other development teams
Debug and fix issues across the entire application stack and underlying systems
Set technical standards, and collaborate on technical direction
Establish ownership of one or more areas of our data infrastructure, including documentation, operational monitoring, and servicing our customers
Help answer questions from the business, as well as formulate and pose your own questions, such as “how do we predict customers likely to churn,” or “where do our best customers come from?”
Lead and teach others about good data model practices
Continuously learn new technologies

Requirements (what You Need To Be Successful)

Strong written and verbal communication skills
Familiar with Databricks / Amazon EMR or AWS Glue or their equivalent services on Azure and GCP/Apache Spark
Able to program in Python using Software Development best practices
Strong SQL skills, both querying, creating views, and understanding how to generate re-usable data models based on often messy sources
Have experience creating ETL/ELT pipelines
Interest in data analysis, presentation, and visualization
Able to work independently and asynchronously
Have to ability to deal with ambiguous problems, manage priorities and help set the pace for a team to execute successfully on a shared vision
Be a self-starters, passionate about data analysis, using traditional and advanced ML tools
Experience developing in Jupyter notebooks (or commercial equivalents such as Databricks or Mode)
Illustrate experience with third party services via API calls, such as AWS Textract
Statistics knowledge, experience with R
Have experience with reporting tools and presentation layers (such as PowerBI or Tableau)
Familiarity with tools such as AutoML
Experience with “real money,” or mission critical applications
Comfortable with multidimensional data
Experience with data privacy, security, and anonymization techniques (up to and including differential privacy)
Experience with pipeline orchestrators (we use Databricks Workflows and Airflow)

Sterling Brokers

New Jobs

Full Stack Data Engineer