Murphy's Pharmacies PEI
Job Summary:
Job Description:
Junior Data Engineer – Murphy’s Pharmacies
Are you a data engineering professional who is interested in being part of a growing organization? If so, we would love to speak with you.
We are looking for a Junior Data Engineer to develop and maintain data pipeline architecture, databases and data warehouses to support our clients. Also responsible for requirements gathering, data profiling, data mapping, and data aggregation. This will require proficiency in interpreting data, designing and building systems for collecting, storing, and analyzing data and technical expertise with SQL.
About Us:
Murphy’s Pharmacies is a 100% Island owned and operated business that has been serving Prince Edward Island communities for over 40 years, since opening our first Pharmacy in 1981.
As a Data Engineer you will:
· Use tools to create and maintain optimal data pipeline architecture and data warehouses to help provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics and reporting.
· Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
· Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, etc.
· Combine and aggregate data from various sources by designing, building and maintaining extraction, transformation and loading (ETL) of data into a data warehouse.
· Identify, assess, and resolve data quality issues.
· Analyze, document and validate the data needs of stakeholders.
· Work with stakeholders, data and analytics experts to strive for greater functionality in our data systems.
· Self-organize to pull on IT resources and client stakeholders as needed to ensure objectives/goals are successful.
· Drive improvements and standards across the IT team aimed at process optimization, cost reduction and agile strategies
Other duties as required
Our ideal candidate will have:
· A degree or diploma in computer science or other information technology related area
· Strong knowledge of SQL programming
· Strong knowledge for designing, building and maintaining relational databases, tables and schemas
· Knowledge of scripting languages (e.g., Python, Perl, PHP, etc)
· Knowledge of API development
· Demonstrated aptitude for being innovative and learning new technologies
· Ability to effectively communicate in English, both verbally and in writing
· Ability to manage time effectively, maintain schedules to meet deadlines, and work well within a team environment.
Additional Assets:
· Hands on experience with Workato ETL, and/or Snowflake DWH or similar tools
· Experience in an Agile/Scrum environment
· Experience working with financial and/or pharmacy dispensary data
Sound Interesting? Here’s What to Do Next….
If this sounds like you, and you’re interested in learning more about the role we’d love to hear from you!
Please submit your resume and cover letter by clicking the APPLY button.
In closing, thank you for taking the time to learn about this opportunity, and for considering us in your career journey. We wish you all the best and appreciate your interest in joining our team!