Data Engineer
*Preference given to someone who has previous experience as a software engineer or back-end developer*
Orion Audit Limited has been conducting Drug, Extended Health, Dental and Disability Group benefits claims audits since 2005. We have quickly emerged as the industry leader and have a reputation for bringing strong governance and accountability to benefit plans across Canada.
We are seeking an innovative and energetic individual with impressive experience and a proven track record to join us and contribute to our standard of excellence in the expansion and development of our data products. You are an ideal candidate if you enjoy providing actionable insights, sharing your technical knowledge, and are proud of the work you deliver by ensuring accuracy and validity. You work well in a collaborative environment, while performing technical tasks independently, and understand how to hustle when deliverables to stakeholders are on the line. You are an individual who values contributing innovative solutions to data challenges, improving data outcomes, and thrives on making a difference.
As a boutique firm, we strongly value individual contributions from each team member, providing autonomy in creating, developing and overseeing your technically skilled work. As a member of this specialized team, you can expect to be challenged in a meaningful way, allowing your creativity and passion for data to shine.
Role Summary
The Data Engineer will form the backbone of all data-related processes at Orion. You have a passion for programming and solving problems with code. A primary component is to prepare data for analytical or operational use. Your strong foundation in data and software engineering, database design, and data analysis will be valuable in helping us meet ever growing demands of big data. It is an expectation that knowledge of best practices is used to identify efficient ways of collecting and storing data, deploying data products, and ensuring that our data is reliable, accessible, and secure.
What You Will be Doing
- Build infrastructure required for optimal extraction, transformation, and integration of data from different data sources using SQL and cloud-based data programs.
- Actively contribute to design and governance of our data platform including architecting our data warehouse and development of machine learning.
- Continued development and design of scripts/queries to retrieve accurate data and provide to our analysts in a meaningful way.
- Ensure fully automated testing by designing and writing automated unit and integration tests.
- Responsible for facilitating the team to meet deadlines and deliver working data solutions, including overall end to end accountability for all working solutions.
- Contributing to development of new data processes and applicable process documentation.
- Assisting the team with other data tasks as needed.
What You Bring to This Role
- Bachelors’ degree in computer science, computer engineering, or related technical discipline
- Knowledge of applied mathematics, statistics, or physics
- Knowledge of database management, algorithms, and data structures
- 3+ years of experience in data engineering and back-end software engineering with experience writing complex SQL queries to extract and integrate data
- Excellent working knowledge of relational databases (SQL) and statistical programming languages (Python)
- Advanced knowledge of SQL databases, data warehousing, data modelling, data tools, data validation and integrity
- Ability to communicate effectively with people who are both technical, and non-technical alike
- Experience with AWS and/or Microsoft Azure
- A passion for improving efficiency and helping others
- Ability to work with little direction and make the best of situations
Assets
- Experience with Business Intelligence tools
- Previous work experience as a back-end software engineer
- Experience with Microsoft Office, Outlook etc. or similar products like Google Suite
- Strong written and verbal communication skills
What We Bring to The Table
At Orion, we understand there are no short cuts to any place worth going, which is why we recognize the dedication and unique contributions of our team members. Our success is largely attributed to our diverse team of specialists, one of the reasons we offer competitive salaries. Since compensation isn’t just focused on salary, we also provide:
- Flexibility to customize compensation including vacation time based on what matters to you most.
- Flexible work hours, since we know life can still happen between 9-5.
- Flexible work from home options. As a result of the COVID-19 pandemic, we provide employees the flexibility of working remote from home, your cottage or anywhere you find productive. Position is based out of our St. Jacobs office, where some in office time will be required in the future. Occasional travel to our Vaughan office may also be required.
- Comprehensive Health Benefits package, since a healthy employee is a happy one.
- Retirement contributions; we believe in planning for your future as much as you do!
- Allowances for continued learning and educational expenses.
- Reimburse expenses such as your cell phone and reasonable office supplies.
- Opportunity to design, create, and develop this role further.
- Opportunities for growth and to take on progressively increasing responsibilities.
- Be part of an encouraging, collaborative, and high-performing team.