* Support data design services and perform needs assessments
* Deliver architectures for data transformations and modernizations
* Design and build data pipelines, streams, and service APIs
* Develop and maintain data warehouse schematics and databases
* Implement effective metrics and monitoring processes

Skills and experiences

* Confident communicator who is able to explain technical terms to non-technical audiences and mentor junior colleagues
* Demonstratable end-to-end experience in Data Engineering, including large-scale projects
* Experience turning business use cases into technical solutions and experience in business process mapping for data and analytics solutions
* Ability to conduct data profiling, cataloging, and mapping
* Knowledge of Azure Data Factory, Azure Data Lake, Azure SQL DW, and Azure SQ, experience with Git/TFS/VSTS and mastery of .NET C# and T-SQL; familiarity with U-SQL
* Demonstrable end-to-end experience in Data Engineering, strong team collaboration skills, experience working with remote teams and experience leading large development teams and large-scale projects

About you

Characteristics that can spell success for this role

You are either a Canadian citizen, Permanent Resident of Canada or a United States citizen
You have a MINIMUM of 10 years of consecutive residency in Canada and eligible to obtain Secret Security Clearance
You reside in Ottawa and are able to commute to Ottawa based client locations
Analytical, curious, agile, you are a team player and good communicator
Problem-solver, patient, quality-driven
Self-motivating, with an innovative mindset

Enjoy your career

Some of the best things about working at Avanade

* Opportunity to work for Microsoft's Global Alliance Partner of the Year (18 years in a row), with exceptional development and training (minimum 80 hours per year for training and paid certifications)
* Real-time access to technical and skilled resources globally
* Collaborate with some of the brightest "Microsoft minds"
* Build your expertise, solve problems, learn, and develop

Find out more about some of our benefits [1] here.

A great place to work

As you bring your skills and abilities to Avanade, you'll get distinctive experiences, limitless learning, and ambitious growth in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and our communities. You'll join a community of smart, supportive collaborators to lift, mentor, and guide you, and lean on your expertise. You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live. It's all here, so take a closer look!
We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Visit our [2] Inclusion & Diversity page.

Create a future for our people that focuses on
• Expanding your thinking
• Experimenting courageously
• Learning and pivoting

Inspire greatness in our people by
• Empowering every voice
• Encouraging boldness
• Celebrating progress

Accelerate the impact of our people by
• Amazing the client
• Prioritizing what matters
• Acting as one

Learn more
To learn more about the types of projects our Data Engineering team works on check out these case studies:
[3] thyssenkrupp Materials Services uses data to help strike a delicate operational balance
[4] What matters to SSE Renewables is innovating for a sustainable future

Interested in knowing what's going on inside Avanade? Check out our blogs:
[5] Avanade Insights - exchange ideas that drive tomorrow's innovation
[6] Inside Avanade - explore what life is like working at Avanade

References

Visible links
1. https://www.avanade.com/en-gb/career/benefits
2. https://www.avanade.com/en-us/about-avanade/inclusion-and-diversity
3. https://www.avanade.com/en-gb/clients/thyssenkrupp
4. https://www.avanade.com/en-gb/clients/sse-renewables-ai
5. https://www.avanade.com/en/blogs/avanade-insights
6. https://www.avanade.com/en/blogs/inside-avanade