Azure Data Engineer, Manager (Security clearance required)
Ottawa - 99 Bank Street
Full Time Mid-level / Intermediate Clearance required CAD 68K - 160K *
PwC
We are a community of solvers combining human ingenuity, experience and technology innovation to help organisations build trust and deliver sustained outcomes.Line of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
MicrosoftManagement Level
ManagerJob Description & Summary
*What to consider before applying:As a requirement, a Secret Security Clearance is mandatory for all staff who’ll be engaged on these assignments. Prior to applying, please review the Government of Canada website to ensure you meet the eligibility requirements to obtain this clearance. This will become a condition of your employment with PwC should you receive an offer from us.
A career within our Microsoft Cloud Practice will provide you with the opportunity to help leading organizations develop and implement strategies that transform their technology capabilities and solve their most critical business challenges. We take a “cloud first” approach when building assets and delivering technology with an agile operating model. Our mindset is to always look for opportunities to automate technology and business processes. We assist our clients in embracing next-generation sourcing strategies to drive success and get “fit for the cloud”.
Joining this dynamic team will allow you the opportunity to shape and contribute to a group of highly skilled cloud and data professionals. You will be able to combine your consulting, technical, and industry expertise to build and deliver innovative cloud data solutions.
With a focus on Cloud Data Engineering and DevOps, you will collaborate with internal teams and clients to implement data solutions on Azure, leverage cloud services, and ensure a solid foundation to run, manage, and scale their data-driven applications.
Meaningful work you’ll be part of and key responsibilities
As an Azure Data Engineer, Manager, you’ll work as part of a team of problem solvers, helping to solve business issues, deliver high quality client service and operational efficiency. Responsibilities include but are not limited to:
Project Delivery and Client Engagement
- Collaborate with cross-functional teams to design and implement cloud-based data solutions that meet client requirements.
- Assist in developing proposals and statements of work, providing technical input and ensuring feasibility.
- Work closely with clients to understand their business needs and translate them into technical solutions.
- Contribute to the development of reference architectures and best practice approaches to optimize clients’ data adoption, performance, security, and cost models.
- Participate in meetings and discussions with internal and external stakeholders to align on project objectives and deliverables.
Implementation and Technical Expertise
- Implement and scale cloud-based data projects, leveraging Azure services.
- Analyze business and technical requirements and translate them into effective data designs and implementation plans.
- Develop data pipelines and workflows using Azure Data Factory, Databricks, and other relevant tools.
- Ensure data solutions are secure, reliable, and optimized for performance.
- Support data migration efforts from on-premises to cloud environments.
Collaboration and Team Leadership
- Lead and mentor junior team members, fostering a collaborative and supportive team environment.
- Participate as a technical team lead on multiple concurrent cloud-focused data projects.
- Promote knowledge sharing and best practices within the team and across the organization.
- Facilitate effective communication among team members, stakeholders, and clients.
Experiences and skills you’ll use to solve
- Demonstrated experience working as a data engineer or in a related capacity.
- Demonstrated experience in cloud data technologies (especially Azure), project execution, and data architecture.
- Experience implementing and scaling cloud-based data projects, focusing on:
- Cloud data technology architectures and solutions, including data warehousing, data lakes, and hybrid cloud deployments.
- Data integration and ETL/ELT processes.
- Data modernization strategies and tooling.
- Migrating data from legacy systems to modern cloud platforms.
- Working in waterfall, scrum, agile, and other methodologies.
- Strong problem-solving skills with the ability to analyze complex business and technical requirements.
- Excellent communication skills, both oral and written, with experience in a consulting environment.
- Leadership abilities with experience mentoring and guiding junior team members.
- As a requirement, a Secret Security Clearance is mandatory for all staff who’ll be engaged on these assignments. Prior to applying, please review the Government of Canada website to ensure you meet the eligibility requirements to obtain this clearance. This will become a condition of your employment with PwC should you receive an offer from us.
Technical experience in many of the following areas:
- Cloud Data Technology Expertise: Proficiency with Azure data services, including Azure SQL Database, Azure Synapse Analytics, Azure Data Lake Storage, and Azure Cosmos DB.
- Data Integration and ETL/ELT: Experience using tools like Azure Data Factory, Databricks, and Logic Apps for data ingestion, transformation, and orchestration.
- Big Data and Analytics: Familiarity with big data technologies such as Hadoop, Spark, and implementing scalable analytics solutions on Azure.
- Business Intelligence and Reporting: Knowledge of Power BI and experience designing and implementing BI solutions.
- Data Governance and Security: Understanding of data governance practices, data quality management, and implementing security best practices in Azure.
- Infrastructure as Code (IaC): Experience with tools like Terraform, Ansible, Bicep, and ARM templates for automating data infrastructure deployment and management.
- DevOps for Data: Knowledge of CI/CD pipelines for data solutions using tools like Azure DevOps or GitHub Actions.
- Scripting and Automation: Proficiency in scripting languages such as Python, SQL, or Scala for data processing and automation.
- Networking and Security: Understanding of cloud networking concepts as they relate to data solutions, including private endpoints, firewalls, and encryption.
Why you’ll love PwC
We’re inspiring and empowering our people to change the world. Powered by the latest technology, you’ll be a part of diverse teams helping public and private clients build trust and deliver sustained outcomes. This meaningful work, and our continuous development environment, will take your career to the next level. We reward your impact, and support your wellbeing, through a competitive compensation package, inclusive benefits and flexibility programs that will help you thrive in work and life. Learn more about our Application Process and Total Rewards Package at: https://jobs-ca.pwc.com/ca/en/life-at-pwc
Education (if blank, degree and/or field of study not specified)
Degrees/Field of Study required:Degrees/Field of Study preferred:Certifications (if blank, certifications not specified)
Required Skills
Optional Skills
Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Application Software, Business Model Development, Business Process Modeling, Business Systems, Coaching and Feedback, Communication, Creativity, Developing Training Materials, Embracing Change, Emerging Technologies, Emotional Regulation, Empathy, Enterprise Integration, Enterprise Software, Implementation Research, Implementation Support, Implementing Technology, Inclusion, Innovative Design, Intellectual Curiosity, IT Infrastructure {+ 20 more}Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship?
NoGovernment Clearance Required?
YesJob Posting End Date
At PwC Canada, our most valuable asset is our people and we grow stronger as we learn from one another. We’re committed to creating an equitable and inclusive community of solvers where everyone feels that they truly belong. We understand that experience comes in many forms and building trust in society and solving important problems is only possible if we reflect the mosaic of the society we live in.We’re committed to providing accommodations throughout the application, interview, and employment process. If you require an accommodation to be at your best, please let us know during the application process.To learn more about inclusion and diversity at PwC Canada: https://www.pwc.com/ca/en/about-us/diversity-inclusion.html. Be a part of The New Equation.Chez PwC Canada, notre atout le plus précieux, c’est notre personnel. Et c’est en apprenant les uns des autres que nous devenons plus forts. Nous avons à cœur de créer une communauté équitable et inclusive de professionnels de la résolution de problèmes, dans laquelle chacun se sent vraiment à sa place. Nous savons que l’expérience peut prendre diverses formes et, pour nous, donner confiance au public et résoudre des problèmes importants n’est possible que si notre milieu de travail reflète la diversité de la société dans laquelle nous vivons.Nous tenons à répondre à vos besoins tout au long du processus de demande d’emploi, d’entrevue et d’embauche. Si vous avez besoin de mesures d’adaptation pour être parfaitement à l’aise, faites-le-nous savoir à l’étape de la demande d’emploi.Pour en savoir plus sur l’inclusion et la diversité chez PwC Canada: https://www.pwc.com/ca/fr/about-us/diversity-inclusion.html. Faites partie de La Nouvelle équation.* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Ansible Architecture Azure Big Data Business Intelligence CI/CD Consulting Cosmos DB Databricks Data governance Data pipelines Data quality Data Warehousing DevOps ELT Engineering ETL GitHub Hadoop ML models Pipelines Power BI Python Research Scala Scrum Security Spark SQL Terraform
Perks/benefits: Career development Competitive pay
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.