Avanade

Data Engineer (Azure Synapse & Azure Purview & Azure Data Factory)

Posted 19 January 2023
LocationMalaysia
Job type Permanent
DisciplineData Management, Electrical & Electronics Engineering
Reference61392

Company's Benefits

  • Paid Parental Leave

    Paid Parental Leave

  • Flexible Working Arrangements

    Flexible Working Arrangements

  • Mentorship Program

    Mentorship Program

  • Leadership Development Program

    Leadership Development Program

  • Raise Numbers Of Women In Leadership

    Raise Numbers Of Women In Leadership

  • Internal Women's Networking Group

    Internal Women's Networking Group

Job Description

​Data Engineer (Azure Data Factory, Azure Synapse Analytics, SQL, Microsoft Purview, Databricks, DevOps, SSMS)


As a Data Engineer, you will support the implementation of projects focused on collecting, aggregating, storing, reconciling, and making data accessible from disparate sources to enable analysis and decision making. This role will also play a critical part in the data supply chain, by ensuring stakeholders can access and manipulate data for routine and ad hoc analysis. Additionally, you will support the full lifecycle of data from ingesting through analytics to action.

Key Role Responsibilities:

  • Day-to-day you will:

  • Translate business requirements to technical solutions leveraging strong business acumen 

  • Analyze current business practices, processes and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data & Analytics PaaS Services

  • Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments.

  • Deliver of architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies.

  • Design and Build Modern Data Pipelines and Data Streams.

  • Design and Build Data Service APIs.

  • Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics.

  • Expose data to end users using PowerBI, Azure API Apps or any other modern visualization platform or experience

  • Implement effective metrics and monitoring processes.

Skill & Capability Requirements:

  • Around 3-5 years of working experience as a Data Engineer 

  • Demonstrated experience in turning business use cases and requirements into technical solutions 

  • Experience in business processing mapping of data and analytics solutions. 

  • The ability to apply such methods to solve business problems using one or more Azure Data and Analytics services in combination with building data pipelines, data streams, and system integration.

  • Ability to leverage a variety of programming languages & data crawling/processing tools to ensure data reliability, quality & efficiency

  • Experienced in Cloud Data Transformation using ETL/ELT tools such as Azure Data Factory, Azure Synapse Analytics, Databricks

  • Experienced in writing well-versed SQL scripts/Stored Procedures to achieve desired transformation

  • Experienced in working with SSMS

  • Experienced in Dev-Ops processes (including CI/CD) and Infrastructure as code fundamentals.

  • Experienced in Data Governance tools like Microsoft Purview, Master Data Management (MDM) and Data Quality tools and processes

  • Knowledge of business intelligence tools such as Power BI, Tableau, Qlik, Cognos TM1

  • Knowledge of Azure Data Lake, Azure SQL DW, and Azure SQL, Azure App Service is required. Azure IoT, Azure HDInsight + Spark, Azure Cosmos DB & Azure Stream Analytics are a plus.

  • Knowledge in data modeling and database management, such as performance tuning of the Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments, and support the integration of those systems with other applications 

  • Knowledge of Python is a plus.

  • Experience preparing data for Data Science and Machine Learning.  

  • Experience preparing data for use in Azure Machine Learning / Azure Databricks is a plus. 

  • Experience preparing data and building data pipelines for AI Use Cases (text, voice, image, etc). 

  • Designing and building Data Pipelines using streams of IoT data. 

  • Knowledge of Lambda and Kappa architecture patterns.

  • Strong team collaboration and experience working with remote teams.  

  • Working experience in Visual Studio, PowerShell Scripting, and ARM templates.

  • Azure certifications (AZ-900, AZ-200, and 201), Databricks certification, DevOps certifications are plus


What we offer you

Come for the distinctive experiences you have helping forward-thinking corporations, non-profits, and governments push the boundaries of digital innovation. Stay for the limitless learning opportunities that encourage you to master Microsoft and pursue big ideas. Enjoy ambitious growth for yourself as part of Avanade’s people-first culture with benefits like employee share purchasing, flexible work arrangements, a commitment to diversity and inclusion, and competitive pay.