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 drives insights for financial products. This remote role involves collaboration across teams and expects expertise in SQL, Python, and data pipeline management. The position offers competitive pay, full health coverage, and opportunities for growth in a dynamic environment.

Benefits

Competitive salary and stock options

100% paid medical, dental, and vision insurance

Flexible PTO

Opportunities for professional growth

Qualifications

• 4+ years experience writing complex SQL queries.
• 2+ years experience with datasets in Python (pandas/numpy/dask).
• Experience with data pipeline construction.

Responsibilities

• Build and scale data pipelines for the enterprise data warehouse.
• Ensure effective data management and drive data quality.
• Design and distribute key data metrics and reports.

Skills

SQL

Python

Data Engineering

Data Pipeline

Communication

Analytical Skills

Troubleshooting

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