88812

Toronto, Ontario

Contract

21 hours ago

Role: Sr Data Engineer
Duratrion: 3 years
Location: Toronto, ON – Union Station (61 Front St W)
Work Model: Hybrid – minimum 2 days onsite

1.0 Description of Assignment

Data Engineer will be responsible for modeling, designing and developing data pipelines, and analytics ready data sets and business intelligence solution(s).

He/she will follow design & development methodologies and documentation standards.

Hybrid work environment according to office policy. Currently at Union Station (61 Front St W, Toronto) with minimum 2 days on site.

Qualifications

Mandatory Requirements
5+ years of experience in:

Database development or data engineering for enterprise level solutions
Hands-on experience working with:
- Microsoft Azure Synapse and/or SQL Data Warehouse and SQL Server 2016 or later.
- Microsoft Azure Data Factory and other related Azure Services
- Azure Databricks
- CI/CD pipelines (Azure DevOps)
SQL and Python programming
Developing Microsoft Power BI reports or other data visualization tools

Other Certifications / Skills

A university degree in Computer Science, or the equivalent, combined with directly related experience in a business or computer related discipline.
Optimize, analyze and improve data integration packages
Expert understanding and enterprise scale experience working with Data Warehouse (DW) and Business Intelligence (BI) implementations
Strong understanding of data modelling techniques and data warehouse/data lake design
Experience with data quality, data cleansing and data stewardship processes and techniques
Ability to solve complex data problems by analysis, develop appropriate solutions and clearly communicate those solutions to the team.
Ability to work efficiently and provide accurate time estimates for work to be undertaken.
Well-developed interpersonal, oral and written communication skills, strong analytical and problem-solving skills.

3.0 Assignment Duties

Work with the Enterprise Data project team in designing, developing and maintaining the client’s enterprise data warehouse, data marts, data lakes
Responsible for designing, developing and documenting SSIS and/or Azure Data Factory (ADF) packages to integrate data from multiple systems
Responsible for designing, developing and documenting complex T-SQL, stored procedures, views, triggers, indexes, etc.
Develop and maintain Databricks notebooks and jobs using Python (PySpark) and SQL for batch and streaming workloads
Build curated, analytics-ready datasets following layered patterns (e.g., bronze/silver/gold) and data product principles.
Implement Delta Lake best practices
Responsible for designing and implementing data quality processes
Assist in the data modelling of the data warehouse/data mart/data lake solution(s)
Advanced data analysis to provide meaningful data driven insights
Work closely with the business analyst(s), and other team members, to understand requirements
Convert business requirements to technical specifications.
Perform knowledge transfer meetings and sessions.
Research, propose, document, and share technical solutions with the team.
Recommend and implement improvements to data quality, automation, and workflows
Provide accurate time estimates for work to be undertaken

4.0 Deliverables

Detailed technical design and functional specifications.
Completed system components 'unit tested' and ready for System, QA and User Acceptance testing.
Technical support during the various stages of testing (system integration, QA, User Acceptance)
Implementation preparation.
Technical documentation
Post implementation support
Status Reports

The pay range that the employer reasonably expects to pay for this position is between CA$75.00 and CA$85.00

Our voluntary benefits offering includes medical, dental, vision and retirement benefits.

This posting is for an existing vacancy.

If you believe this post to be fraudulent, please report by clicking here

Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.

We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.

Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!