**360training** is a leader in regulatory-approved online training and certification across a wide range of industries and professions in the United States. Since 1997, the company has delivered best-in-class training content for workforce compliance, continuing education, professional development, and career certification across all its brands, including OSHAcampus and Learn2Serve.
Our people are our biggest asset, and we care about each other as family. We **promote a culture of excellence** that fosters the success of our people, while maintaining a team-centric environment, inspiring them to do their absolute best.
With a **growth-driven environment**, we encourage you to come up with big ideas, test out new concepts, and grow your skillset. When you work here, you'll be equipped with tools you need to excel both inside and outside the office.
We are a strong believer on driving Results & Doing the right thing, those are our values.
We are **opening our operations** in Costa Rica at American Free Zone in Heredia; this amazing complex offers amazing facilities as: Soccer Field, Tennis court, spinning classes, transportation service, Food Court areas, outdoor activities and so many other, for you to enjoy.
**JOB DUTIES**:
- Gather business requirements and create 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 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