**Position: Data Warehouse Engineer**
Location: San Jose, CR (Onsite)
**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
- 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
- Minimum 5 years of experience in writing SQL Code: Stored Procedures, Functions, Queries, Query Optimization by Indexing
**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
**Education**:
- Bachelor's (preferred)
**Experience**:
- Azure Data Factories: 5 years (preferred)
- writing ETL in any other tool: 5 years (preferred)
- writing SQL Code: 5 years (preferred)
Ability to Commute:
- San José, Provincia de San José (required)
Ability to Relocate:
- San José, Provincia de San José: Relocate before starting work (required)