Data Warehouse Engineer

**Data Warehouse Engineer**

**Job Duties**:

- Gather business requirements and create and document designs for Business Intelligence solutions.
- Develop new and support existing ETL processes utilizing Azure data factory, logic apps, etc.
- Document mappings of data points, describing various sources and targets, error handling, logging, etc.
- Provide support to the organization's reporting requirements. Create ad hoc reports as requested.
- Supports business teams in utilizing the Data warehouse effectively by identifying gaps in data, work on enriching Data warehouse and enable business to perform self-service functions.
- Assist with data migration for company acquisitions.

**Job Requirements**:

- Bachelor's degree in information technology, Science or Engineering
- Minimum 5 years of experience in writing SQL Code: Stored Procedures, Functions, Queries, Query Optimization by Indexing
- Experience in collecting and translating the business requirements and converting them into logical/physical data models.
- Experience in creating ETL involving heterogeneous data sources (IBM DB2, SQL Server, MySQL, Excel files, CSVs, Azure Blobs, XML, JSON, etc.):

- Minimum of 2 years using Azure Data Factories, Data Flows, Logic Apps, Azure Functions, calling REST APIs.
- Minimum of 3 years writing ETL in any other tool

**Nice To Have**:

- Experience designing and developing new reports creating data driven subscriptions, maintaining, and enhancing existing reports using SQL Server Reporting Services
- Experience in source control systems like Git, TFS
- Experience in core Azure services related to data and analytics and deploying Azure components using PowerShell Scripting, Azure ARM Templates
- Experience with Agile development methodology and familiarity with tools such as Atlassian JIRA