SQL-ETL Developer

Austin, Texas
Not Specified
Sep 29, 2016
Nov 28, 2016
Job Type
Not Specified
Career Level
Not Specified

Assurant Specialty Property is looking for experience Software Developer with experience in SQL-ETL development. The successful candidate will:

- Design, develop, implement, and maintain ETL workflows

- Design, develop, implement, and maintain Data Warehouse objects

- Design, develop, implement, and maintain SSRS Reports

- Design, implement and support data warehousing projects

- Interact with the business stakeholders to understand data warehousing and BI requirements

- Implement business rules via stored procedures, middleware, or other technologies

- Write stored procedures and perform RDL optimization

- Write relational and multidimensional database queries

- Maintain and ensure data integrity and accuracy

- Follow the Data Warehouse and BI Development Team coding standards and processes

- Process errors and bugs in the existing Data Warehouse, and BI process flows

- Assist DBA teams in performing Data Warehouse tuning, collection of statistics and SQL code performance.

Basic Qualification

- 5 years of experience developing SQL-ETL

- 3 years of experience working with ETL tools such as Microsoft SSIS

- 3 years of experience with MS SQL CDC

Other Requirements

- Experience with Reporting Tools such as SSRS

- Knowledge of data warehousing and OLAP standard concepts, structures, practices, and procedures

- Experience with recent versions of Microsoft SQL Server

- Flexible and Dynamic Individual that can adjust rapidly to change

- Excellent written and verbal communication skills

Preferred Skills

- Cubes and reports using SQL Server Analysis Services (SSAS) via Tableau

- Tabular and Multidimensional Modeling

- Reporting and analytics solutions using SQL Server Reporting Services (SSRS) integrated with SharePoint

- Bachelor Degree


More jobs like this