Azure Data Engineer Job Description
The Azure Data Engineer is responsible for building, implementing, and supporting Microsoft BI solutions to meet market and/or client requirements.
They apply knowledge of technologies, applications, methodologies, processes, and tools to support a client, project, or entity.
We are currently looking for programmers or experienced programmers with strong technical expertise in the Microsoft BI Stack (T-SQL, SSIS). Additional skills such as SAP BI or Power BI reporting are a plus.
As part of a collaborative team, and under the supervision of a project lead, the candidate will be responsible for designing and developing software products to implement new features and support existing applications.
Responsibilities:
- Create ER diagrams and write relational database queries
- Create database objects and maintain referential integrity
- Configure, deploy, and maintain databases
- Participate in the development and maintenance of Data Warehouses
- Develop ADF pipelines utilizing various activities for data ingestion and transformation
- Apply knowledge of Python scripting and Spark APIs
- Understand Azure Pass/SAAS and Azure Stream Analytics
- Knowledge of Azure Storage Account
- Design, develop, and deploy SSIS packages
- Create and deploy reports
- Provide technical design and coding support to the team to meet project deliverables
- Communicate with clients to gather business requirements
Skills:
- Azure Data Factory
- Azure Databricks
- Azure Synapse Analytics
- Azure Functions
- Azure Blob Storage
- Azure Logic Apps
- C# and .NET, SQL Server
- Azure Synapse
- Azure DevOps
- Azure Storage/Data Lake
- ETL processes
- Analytics development
- Report development
- Relational databases and SQL language