Country:

United Kingdom

Cities:

London

Area of expertise:

Analytics

Job Description

About Avanade

Avanade provides business technology solutions and managed services that connect insight, innovation and expertise in Microsoft technologies to help customers realise results.

Avanade is a young, growing, fast-paced company that retains the entrepreneurial spirit with which it was founded. We attract smart, passionate people and have an open, collaborative, results-oriented culture.

An open, intensely collaborative workplace, we all look to the cutting edge of our field and leverage our communities to create the best outcomes for customers. We put customers first and draw on learning’s from around the world to drive innovation.

People who are a great fit for Avanade are passionate about using technology to help customers solve business problems in ways that make a real difference. We are experts in Microsoft technology. Puzzle-solvers and team players, we love to share knowledge and are willing to go above and beyond with our colleagues and for our customers.


About the Role

Data Engineers at Avanade are responsible for delivering high quality data solutions using modern data sourcing, integration and modelling techniques, to enable significant data-driven insight for our clients.

Experts with data engineering tools, architectures, and platforms, our Data Engineers are passionate about technology and are proficient in a wide range of skills to be able to deliver the right solution to meet requirements. 

They bring a strong technical understanding of Azure data services and hands-on experience in distributed computing, big data, ETL/ELT, dimensional modelling, databases and data visualisation. They are also experienced in the end to end solution delivery cycle, from design and build through to Production release and enhancement.

In this role, you will help design, build, scale and maintain complex solutions built on cloud-based data systems, from collection and storage through to modelling, and analysis.


Responsibilities

  • Work with client teams and business analysts to translate business requirements into technical solutions, using strong business insight.
  • Support the design, development and management of data storage and processing solutions.
  • Enabling and supporting the monitoring and optimisation of these data solutions.
  • Delivery of the solution through development and testing and into production environments.
  • Extending beyond the technical delivery and encompassing data governance, security, compliance, change control and continuous improvement.
  • Delivery of architectures for integration and transformation of enterprise data solutions using Azure cloud data technologies.
  • Working in a team environment, interacting with multiple groups on a daily basis (very strong communication skills).
  • Involved with client and testing teams to ensure alignment to requirements, data verification and usability testing.
  • Identify future business opportunities for leveraging Microsoft Azure Data & Analytics PaaS Services.

Key Role Skill & Capability Requirements

Technical skills:

Required

·       Experience with Azure Data Factory, Azure Data Lake, Azure SQL DW / Azure Synapse Analytics, and/or Azure SQL DB is required.

  • Experience with querying languages including, but not limited to SQL (pref. T-SQL). Ability to write, analyse, and debug SQL queries.
  • Experience with Data Warehouse design, ETL/ELT, architecting efficient solution designs for a data warehouse platform.
  • Hands-on experience in Python, R, Scala or Apache Spark in production environments.
  • Experience working with Azure DevOps - Knowledge of DevOps processes (including CI/CD) and Infrastructure as code fundamentals.
  • Experience with Git/TFS/VSTS.
  • Knowledge of Power BI or similar BI tools.

Advantageous

·       Knowledge of Cosmos DB, Databricks, Azure IoT, Azure HDInsight or Azure Stream Analytics.

  • Data preparation for use in Azure Machine Learning and/or Azure Databricks.
  • Demonstrated experience preparing data and building data pipelines for AI Use Cases (text, voice, image, etc.…).
  • Previous experience in the Microsoft SQL BI stack (SSIS, SSRS, SSAS).
  • Familiarity with object-oriented programming languages such as C#.
  • Working experience with Visual Studio, PowerShell Scripting, and ARM templates.
  • Designing and building Data Pipelines using streams of IoT data.
  • Knowledge of Lambda and Kappa architecture patterns.
  • Knowledge of Master Data Management (MDM) and Data Quality tools & processes.

Non-technical skills:

  • Excellent written and oral communication skills.
  • Ability to handle deadlines and multiple priorities, including challenging demands.
  • Must be a self-starter, work well with minimal supervision, and accept responsibility.
  • Team participation and effectiveness - Must have ability to collaborate across functions, to form strong working relationships.
  • Experience in business process mapping of data and analytics solutions.
  • Strong team collaboration and experience working with remote teams.
  • Ability to conduct data profiling, cataloguing, and mapping for technical design and construction of technical data flows.

Qualifications & Experience

  • Bachelor’s degree or equivalent experience ideally in Computer Science or a related technical field but otherwise in mathematics.
  • 3+ years of relevant work experience.
  • Clearly demonstrated business-related problem solving and organisational skills.
Apply now

Share this job:

Share Facebook Twitter Email

About Avanade

Avanade leads in providing innovative digital services, business solutions and design-led experiences for its clients, delivered through the power of people and the Microsoft ecosystem. Our professionals combine technology, business and industry expertise to build and deploy solutions to realize results for clients and their customers. Avanade has 29,000 digitally connected people across 23 countries, bringing clients the best thinking through a collaborative culture that honors diversity and reflects the communities in which we operate. We welcome all, and seek talented individuals who can bring their whole self to work, build inclusive teams and encourage diversity inside and outside the organization. Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com.