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.
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.
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.