Senior Data Developer

UniUni; Richmond; On-site; CAD 85,000 - 100,000; Full time

Job summary

A logistics company is seeking a Senior Software Developer to architect and build data integration and ETL solutions. In this role, you'll transform raw data into reliable datasets, support various business units' analytics needs, and maintain technical documentation. The ideal candidate has a Bachelor's degree in computer science or related field and 5+ years of experience with ETL processes, data modeling, and SQL. A competitive salary and benefits package are offered.

Benefits

Dental insurance

Vision insurance

Medical insurance

Paid Holiday

Paid Time Off

Paid Sick Leave

Management training program

Qualifications

• 5+ years of experience developing data integration or ETL.
• Strong solution design experience including data modeling and visualization.
• Experience performing root cause analysis on data and processes.

Responsibilities

• Architect, build, and maintain data integration and ETL solutions.
• Design and develop metadata and data transformation processes.
• Work with stakeholders to support data infrastructure needs.

Skills

Data integration

ETL processes

SQL optimization

Data modeling

Data visualization

Analytic skills

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

AWS RedShift

PostgreSQL

MySQL

Job description

UniUni, a North American leader in last-mile logistics, delivers tens of millions of parcels annually across Canada, from coast to coast, and is rapidly expanding its footprint in the United States. Founded in 2019, UniUni is known for its tech-driven innovation and crowdsourced delivery model, providing fast, economical, and reliable services to local, national, and international e-commerce clients.

What Do We Offer?

At UniUni, we empower our employees with opportunities to achieve their professional goals. We value both lateral growth and vertical advancement, ensuring every role helps you develop your skills, broaden your expertise, and build a fulfilling career. We are looking for passionate professionals ready to work hard, embrace challenges, and enjoy being part of a dynamic, fun team.

About the role

• This Senior Software Developer role focuses on architecting and building end-to-end data integration and ETL solutions to support the company’s analytics and BI needs. The position is responsible for designing scalable data models, transforming raw data into reliable, high-quality datasets, and developing reusable data tools and analytical programs. You’ll collaborate closely with cross-functional teams—Finance, Operations, Program Managers, Executives, and more—to deliver efficient data provisioning and maintain essential technical documentation. This role is key in shaping our data strategy, improving data reliability, and providing technical support for BI projects, all while maintaining a mindset of continuous learning and improvement.

What you’ll do

• Architect, build, and maintain the solution of data integration or ETL pipeline
• Design and develop data models, data transformation processes, and metadata that converts raw data to formats suitable for consumption in BI platforms, including reporting, data mining, machine learning, forecasting, advanced analytics, etc.
• Design, implement and support data provisioning to meet the analytics needs of various business units while following and enhancing BI standards and best practices across the organization
• Continuous improve data reliability, efficiency, and quality.
• Work with stakeholders including Program Manager, Executive, Finance, Operation, and Quality Control teams to support their data infrastructure needs.
• Develop analytical tools and programs
• Build and maintain reusable data tools for data integration and ETL
• Custom script development, data migration, or manipulation to support the BI team
• Propose and maintain data solution strategies and roadmaps
• Developing and maintaining the essential technical documents.
• Offering technical support for BI project and product.
• Keeping mindset of continuous learning

Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• 5+ years of experience developing data integration or ETL using AWS RedShift, PostgreSQL, or MySQL
• Advanced working knowledge with relational databases, query authoring (SQL), and SQL optimization
• Strong solution design experience including data modeling, data presentation, data visualization, the definition of key performance indicators, and ETL processing
• Good knowledge of data warehouse, relational databases and SQL language
• Experience integrating data from different sources (API, Databases, files, etc.)
• Experience performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement.
• Physical and logical design of database architecture for relational databases, data warehouses, and data lakes Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with structured or unstructured datasets.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Strong communication for working with internal and external stakeholders
• Dental, Vision, Medical insurance, Paid Holiday, Paid Time Off, Paid Sick Leave, Management training program
• Salary range $85,000 to $100,000 CAD

The pay range for this role is: