Data Engineer/Analyst

TEEMA Solutions Group; Brampton; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

A leading company in digital pharmacy is seeking a meticulous Data Engineer / Analyst to join their dynamic team. The role involves designing and developing data pipelines, maintaining a data warehouse, and ensuring data accuracy. Candidates should have a Bachelor's degree and 2+ years of experience in data engineering or analytics, with proficiency in SQL and Python. Enjoy a hybrid work environment with competitive benefits and a culture that values diversity and innovation.

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 or 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 using tools like Tableau or Power BI.

Skills

SQL

Python

Data Modeling

Data Analysis

Data Quality

Education

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

Tools

Databricks

Snowflake

Microsoft Fabric

Tableau

Power BI

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.