Data Engineer/Analyst

Pillway; Brampton; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Pillway is seeking a meticulous Data Engineer/Analyst to design and develop scalable data pipelines and maintain a centralized data warehouse. The ideal candidate will ensure the accuracy of data reports and collaborate with the team to automate new reports. Join us to shape the future of digital healthcare with a competitive salary and a flexible work environment.

Benefits

Hybrid Work

Competitive Benefits and Compensation

Flexible Work Environment

Inclusive and Dynamic Culture

Qualifications

• 2+ years of hands-on experience in data engineering or analytics roles.
• Experience working with APIs, cloud storage, and data lake architectures.
• Familiarity with orchestration tools such as Airflow, DBT, Azure Data Factory.

Responsibilities

• Design and develop scalable data pipelines and maintain a centralized data warehouse.
• Validate and ensure the accuracy of automated and manual data reports.
• Develop and maintain dashboards for data visualization.

Skills

SQL

Python

Data Modeling

Data Analysis

Education

Bachelor’s degree in Computer Science, Data Science, Engineering, or related field

Tools

Databricks

Snowflake

Microsoft Fabric

Tableau

Power BI

Job description

Join to apply for the Data Engineer/Analyst role at Pillway

Get AI-powered advice on this job and more exclusive features.

Job Description

We are seeking a meticulous and skilled Data Engineer / Analyst to join our dynamic team. The ideal candidate will be responsible for designing and developing scalable data pipelines, building and maintaining a centralized data warehouse, and ensuring the accuracy and integrity of both automated and manual data reports.

Key Responsibilities

• Validate and ensure the accuracy of automated and manual data reports.
• Architect and implement robust data warehouse solutions.
• Use pandas and other data analysis tools to clean and process data.
• Handle change requests for existing automated reports.
• Collaborate with the team to automate new reports based on client requirements.
• Develop and maintain dashboards for data visualization using tools like Tableau, Power BI, or similar.
• Create and manage data pipelines for automated streaming of data into clients’ data lakes.
• Ensure consistency and reliability of data sources for manual reports.
• Conduct regular data audits to maintain data integrity.

Requirements

• Bachelor’s degree in Computer Science, Data Science, Engineering, or related field.
• 2+ years of hands-on experience in data engineering or analytics roles.
• Proficiency in SQL, Python, and data modeling techniques.
• Hands-on experience with Databricks, Snowflake, or Microsoft Fabric (at least one is mandatory; familiarity with others is a plus).
• Strong understanding of data warehouse architecture and ETL/ELT processes.
• Experience working with APIs, cloud storage, and data lake architectures.
• Familiarity with orchestration tools such as Airflow, DBT, Azure Data Factory, or similar.
• Experience in building dashboards using Power BI, Tableau, or equivalent.
• Knowledge of data quality frameworks and data observability tools is a plus.

Preferred Qualifications

• Experience in a similar role within a fast-paced environment.
• Knowledge of additional programming languages (e.g., Python, R).
• Understanding of database management, data warehousing, and data lakes.
• Familiarity with reporting tools (e.g., Tableau, Power BI, Looker).
• Exposure to healthcare or regulated environments is an advantage.

Why Work With Pillway?

Joining Pillway means becoming part of a pioneering team dedicated to revolutionizing digital pharmacy in Canada. Here's why you should consider us:

• Hybrid Work: Enjoy the flexibility and comfort of working from home.
• Competitive Benefits and Compensation: We offer market-aligned salaries, comprehensive health benefits, and the potential for participation in our Employee Stock Option Plan over time.
• Flexible Work Environment: Our culture thrives on flexibility, allowing you to balance work and personal life seamlessly.
• Inclusive and Dynamic Culture: Be part of a great workplace culture that values diversity, innovation, and teamwork.

Interview Process

• Initial Screening: Shortlisted candidates will be contacted by our Head of Development for the first interview.
• Leadership Meet-and-Greet: Successful candidates will have a 30-minute interview with our CEO, offering a unique opportunity to understand our vision directly from the top.
• Cross-Functional Team Interview: Engage with various team members across the organization to ensure a mutual fit.
• Final Steps: The ideal candidate will be selected after a comprehensive review. We are an equal opportunity employer and will reach out to those who best fit the qualifications for this role.

Join us at Pillway for a chance to shape the future of digital healthcare, where your work impacts lives daily, and innovation meets inclusivity.

Seniority level

• Entry level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Hospitals and Health Care