Data Engineer/Analyst

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.

Pillway is a pioneering team dedicated to revolutionizing digital pharmacy in Canada. They offer a hybrid work environment, competitive benefits and compensation, a flexible work environment, and an inclusive and dynamic culture.