Senior Data Developer

Upgrade, Inc.; Canada; Remote; CAD 90,000 - 120,000; Full time

Job summary

Upgrade, Inc. is seeking a Senior Data Developer to architect and maintain a data warehouse that supports financial products. This remote role requires expertise in SQL and Python, with responsibilities including building scalable data pipelines and ensuring data quality across the organization. Attractive benefits include a competitive salary, comprehensive insurance, and opportunities for professional growth.

Benefits

Competitive salary and stock option plan

100% paid medical, dental and vision insurance

Flexible PTO

Opportunities for professional growth and development

Qualifications

• 4+ years of experience with SQL in a data warehousing environment.
• 2+ years with dataframes in Python (pandas/numpy).
• Experience with building data pipelines and task orchestrators.

Responsibilities

• Design and maintain data pipelines for the enterprise data warehouse.
• Drive data quality and set up effective data management tools.
• Develop metrics, reports, and dashboards for business visibility.

Skills

SQL

Python

Data Analysis

Data Quality

Communication

Analytical Thinking

Tools

Redshift

Snowflake

Airflow

Apache Spark

Docker

Kubernetes

Job description

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.
• 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