Adecco Group

Modis - Sr. SQL BI Developer

US-See Below for Location
Category
Modis, Inc.

Overview

Sr. SQL BI Developer

 

Responsibilities

Job Duties:

 

  • Leading application development;
  • Mentoring junior developers;
  • Developing complex views and cubes for the OLTP and OLAP data needed for business purposes;
  • Developing complex ETL solutions using Shell scripts for migrating data into Cloud from existing legacy Enterprise Data Warehouse (EDW);
  • Identifying the dimension, fact tables and designing the data warehouse using Star Schema;
  • Using Oracle data and landing the data tables on the production SQL Server with process indexing and considering other constraints;
  • Building the ETL process;
  • Processing and calculating sales related metrics using the sales data in order to provide useful SSRS reports to business users;
  • Creating volatile tables and partitioning the tables;
  • Supporting existing projects using Teradata SQL Assistant Tool;
  • Writing complex SQL queries, stored procedures, triggers, views, cursors, joins, constraints, DDL, DML, and User Defined Functions to implement the business logic and creating clustered and non-clustered indexes;
  • Developing and optimizing Stored Procedures, Views, and User-Defined Functions for the Application;
  • Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor;
  • Migrating data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints;
  • Generating periodic reports based on the statistical analysis of the data from different timeframes and divisions using SQL Server Reporting Services (SSRS);
  • Developing various operational Drill-through and Drill-down custom reports using .Net framework 3.5 within SSRS;
  • Developing different kinds of reports such as Sub Reports, Charts, Matrix Reports, and Linked Reports;
  • Using cascaded parameters to generate reports from two different Data Sets;
  • Supporting production, troubleshooting and debugging in a high volume transaction processing environment utilizing a large quantity of XML;
  • Developing the .NET project, migrating to an upgraded IT supported reporting server, and handling all issues that arise;
  • Working within Agile environment;
  • Utilizing Jira storyboard, Git Hub and extreme programming methodologies for projects.

Qualifications

Job Requirements: 

 

  • Bachelor’s Degree in a Computer Science, Engineering or related field and 5 years of progressive experience, or a Master’s Degree in Computer Science, Engineering or related field and 3 years of experience, in the job offered or in a related role working on BI development using SSRS, SSIS, SSAS, T-SQL, PL/SQL, SQL Server, Teradata SQL Assistant and Star Schema within a .NET environment, and developing complex views and cubes for OLTP and OLAP data retrieval.
  • Current assignment through Modis’ Jacksonville, FL headquarters to a worksite in Atlanta, GA, but must be willing to travel and/or relocate within commuting distance of various unanticipated worksites throughout the U.S. for long or short-term projects.

 

Qualified applicants may apply for this position with Modis, Inc. by submitting resumes to tori.johnson@adeccona.com.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed