Adecco Group

Modis - Sr. SQL BI Developer

US-See Below for Location
Modis, Inc.


Sr. SQL BI Developer



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.


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


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