About the Role: 

We are in search of a Senior Data Developer to design, architect, and maintain Upgrade’s DW that supports our data and analytical needs for our rapidly evolving suite of financial products. This role will partner closely with our Data Platform, Backend, TechOps, Product, Marketing, Finance, and Risk Teams. This is a fully remote position that can be located anywhere in Canada.

What You’ll Do:

• Quickly gain a deep understanding of the business and how data flows through the organization and through the data engineering codebase while playing a key role in building an efficient and scalable data and reporting layer for the organization.  
• Build and scale awesome data pipelines to enrich our Enterprise Data warehouse.
• Set up tools and processes for effective data management and drive data quality across data in the data warehouse.
• Own the design, development, maintenance, and distribution of key data and business metrics and reports. Take a proactive approach to defining new metrics, reports, and dashboards to improve the visibility into data as well as business operations.

What We Look For:

• 4+ years of recent hands-on experience writing complex SQL queries on large data sets in a data warehousing environment.
• 2+ years working with datasets/dataframes in Python (pandas / numpy / dask).
• Experience with columnar database table design and building data pipelines (Redshift and/or Snowflake).
• Experience with building data pipelines with task orchestrators such as Airflow/Google Dataflow/Luigi etc.
• Excellent verbal and written communication skills – Ability to synthesize complex ideas and communicate them in very simple ways.
• Highly analytical and detail-oriented.
• Ability to troubleshoot and fix issues quickly in a fast-paced environment.

Nice to Have:

• Worked with real time big data pipelines using distributed data processing systems using Apache Spark/AWS Glue/Beam.
• Worked with containerization using Docker and Kubernetes.
• Financial services experience.
• Reporting and data visualization skills.

What We Offer You:

• Competitive salary and stock option plan
• 100% paid coverage of medical, dental and vision insurance 
• Flexible PTO
• Opportunities for professional growth and development  
• Paid parental leave
• Health & wellness initiatives

#BI-Remote #LI-Remote