Data Engineer

The Job Reporting to the Corporate Controller, the Senior Accountant is a key contributor to the finance team providing exceptional planning, analytical, and reporting support. As the Senior Accountant, you will be responsible for helping to make business critical financial decisions by collecting, tracking and correcting the company’s finances. In addition, you will be responsible for reconciling bank statements, ensuring financial records are accurate and assisting with financial audits. You excel at maintaining accuracy and attention to detail, thrive under tight deadlines, and collaborate effectively across teams in a fast-paced, evolving environment.

Key Responsibilities :

1. Develop and maintain data pipelines for daily ETL processes, data collection and ingestion from external sources, and optimal data flow between different systems and environments, in Azure cloud and on premises.
2. Design, test and implement Data Marts and Data Warehouse using standard dimensional modeling techniques.
3. SQL development in MS SQL Server, including advanced tuning of queries, data structure design, troubleshooting of production issues, and providing technical assistance regarding problems and technical questions.
4. Define, develop, and maintain data presentation and visualization, including reports written in SSRS and Power BI.
5. Manipulate, store and extract information from non-structured data sets.
6. Participate in corporate data governance, providing foundational data consistency and assisting with business analysis.
7. Be highly responsive to critical production issues providing timely and effective solutions.
8. Participate in code reviews both as a reviewer and as a reviewee, in a respectful way that facilitates skill building for all team members.
9. Engage in all aspects of the Agile process, proactively contributing to improvements in the processes to minimize rework / waste and increase quality and velocity.
10. Keep abreast of software industry best practices, processes, and technologies. Actively encourage their adoption within the Sprint Team and us.

Core Competencies :

1. Communication – Able to clearly and articulately present information in both spoken and written word.
2. Collaboration – Develops positive relationships with others to build consensus, morale and commitment to goals and objectives.
3. Innovation – Displays the ability to think outside of the box to develop creative and new solutions that meets current and future needs.
4. Flexibility – Easily adapts to changing environment and resources.
5. Productivity – Strives to consistently achieve excellence in all tasks and goals.
6. Accountability – Takes personal ownership and responsibility for the quality and timeliness of work commitments and decisions.

Required Skills :

1. Experience with Data Warehouse theory, design, and ETL development.
2. Advanced TSQL skills including query tuning, database internals, and data structure design.
3. Ability to create and maintain reports with SSRS and Power BI.
4. Azure components and concepts (Data Factory, Data Lakes, Data Bricks, etc).
5. Exceptional communication skills including verbal, documentation, and presentation.
6. Ability to think creatively.
7. Nice to have: TDWI certification, SSIS package creation and maintenance, Powershell scripting, Python and/or R and Machine Learning, MDX/DAX/Tabular modeling.

Education :

1. Post-secondary education in Computer Science or related discipline.

Experience :

1. 3+ years development and maintenance of Data Warehouses and ETL processes.

What We Offer :

1. A competitive compensation package, including a comprehensive health benefits plan, Group RRSP, performance bonus, health and wellness benefits, and education sponsorship.
2. Four paid days annually to 'give back' to the community, along with your birthday off.
3. A vehicle rebate program of up to $400 per month.
4. The compensation range for this position is $105,000 - 125,000.