Azure Data Engineer
ey
Job Description
Your key responsibilities
- Responsible for managing multiple client engagements.
- Understand and analyse business requirements by working with various stakeholders and create the appropriate information architecture, taxonomy and solution approach
- Work independently to gather requirements, cleansing extraction and loading of data
- Translate business and analyst requirements into technical code
- Create interactive and insightful dashboards and reports using Power BI, connecting to various data sources and implementing DAX calculations.
- Design and build complete ETL/Azure Data Factory processes moving and transforming data for ODS, Staging, and Data Warehousing
- Design and development of solutions in Data Bricks, Scala, Spark, SQL to process and analyze large datasets, perform data transformations, and build data models.
- Design SQL Schema, Database Schema, Stored procedures, function, and T-SQL queries.
Skills and attributes for success
- Collaborating with other members of the engagement team to plan the engagement and develop work program timelines, risk assessments and other documents/templates.
- Able to manage Senior stakeholders.
- Experience in leading teams to execute high quality deliverables within stipulated timeline.
- Skills in PowerBI, Azure Data Factory, Databricks, Azure Synapse, Data Modelling, DAX, Power Query, Microsoft Fabric
- Strong proficiency in Power BI, including data modelling, DAX, and creating interactive visualizations.
- Solid experience with Azure Databricks, including working with Spark, PySpark (or Scala), and optimizing big data processing.
- Good understanding of various Azure services relevant to data engineering, such as Azure Blob Storage, ADLS Gen2, Azure SQL Database/Synapse Analytics
- Strong SQL Skills and experience with of one of the following: Oracle, SQL, Azure SQL.
- Good to have experience in SSAS or Azure SSAS and Agile Project Management.
- Basic Knowledge on Azure Machine Learning services.
- Excellent Written and Communication Skills and ability to deliver technical demonstrations
- Quick learner with “can do” attitude
- Demonstrating and applying strong project management skills, inspiring teamwork and responsibility with engagement team members
To qualify for the role, you must have
- A bachelor's or master's degree
- A minimum of 4-7 years of experience, preferably background in a professional services firm.
- Excellent communication skills with consulting experience preferred