Business Intelligence Database Developer
IBA InfoTech Inc.
Las Vegas, United States of America
7 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Las Vegas, United States of America
Tech stack
Sql Server Data Tools (SSDT)
Databases
ETL
Database Queries
Database Schema
IBM Cognos Business Intelligence
Microsoft SQL Server
Software Tools
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Tableau
T-SQL
Indexer
Information Technology
SQL Server Management Studio (SSMS)
Spotfire
Job description
- Develop and maintain our SQL Server Database and ETL packages
- Support business intelligence solutions and applications, including reports and dashboards
- Must be able to translate business requirements into technical solutions
- Manage and develop database automation, optimization, scalability and integrity
- Anticipate all senior management needs and requests
Requirements
- Experience with the following technical languages:
- Expert with T-SQL
- Experience with the following Software:
-
SQL Server Development (4+ years) o Create Views, Complex Queries, Dynamic SQL, Tables, Stored Procedures, Database Objects, UDFs, Triggers etc. o New Database implementations/modeling o Optimization, Statistics & Indexing
-
ETL via SSIS/SSDT (2+ years in SSIS or similar software)
Preferential:
- Software Skills:
- SQL Server Administration
- Familiarity with BI technologies (Tableau, Spotfire, Cognos BI etc.)