Send me more jobs like this

Sorry, This job is expired.


Keywords / Skills : MSBI, MS SQL, SSIS, Integration services, SQL server integration, SSRS, DTS

7 - 12 years
Posted: 2018-11-01

IT/Computers - Software
Team Leader/ Technical Leader
Datawarehousing Consultants
Posted On
1st Nov 2018
Job Ref code
Job Description
About Us
AgiliFI Technologies LLP is a subsidiary of F&I Administration Solutions, LLC one of the leading provider of software solutions for the administration of automotive F&I products such as vehicle service contracts, GAP, prepaid maintenance, appearance protection, paintless dent repair and more. Built specifically for automotive F&I product and service providers, F&I Admin’s SCS Auto platform is a fully integrated, web-based solution that automates and streamlines the entire F&I product administration process.

Services provided by SCS Auto include product configuration and design, channel (dealer and agent) management, contract management, claims management and risk management. In addition to the administration functions, SCS Auto provides a powerful reporting module that enables administrators to track payments, perform precise analyses and identify program inefficiencies.

About the Role
The Data Services team need a offshore MSBI Lead developer that will work with the Data Services Manager and the rest of the Data Services  team, supporting and developing various facets of the F&I Administration data and reporting suite, including the clearFI™ solution, using the Microsoft stack (SSAS, SSIS, SSRS), and T-SQL.
  • Deep understanding of Data Warehousing concepts.
  • Experience developing comprehensive presentation solutions (cubes, dashboards, visualizations, reports/extracts, etc.) to present data from multiple source systems or models, transform data according to Business Rules. 
  • Delay/failure in cube processing analysis and resolution. 
  • Should be able to debug cube issues for complex business data and functional issues. 
  • Experience with SSRS subscriptions 
  • Develop and enhance existing SSIS packages. 
  • Enhance, develop, configure and deploy multi-dimensional cubes in different environments. 
  • Experience in having designed and developed reports and dashboards. 
  • Identify the performance bottle-necks in the report and resolve the same. 
  • Developing, testing and deploying SSRS reports to production environments
  • 6+ years T-SQL, Stored Procedures, Views, Functions. 
  • Excellent skills in debugging and performance tuning large Stored Procedures. 
  • 6+ Years of Experience in SQL Server 2008 R2, SQL Server 2012 
  • Work overlap hours with USA Team; Ability to work across time zones and be flexible 
  • Manage offshore resources and provide day to day guidance
  • Self-Driven, results oriented and motivated
  • Strong analytical and problem solving skills
  • Excellent Communication skills. Should be able to communicate with Client Managers directly.

About Company

AgiliFI Technologies builds and maintains the full suite of software solutions provided by F&I Admin for the Finance & Insurance (F&I) industry in the automotive, power sports and other related markets. Our mission is to provide cutting edge development, QA, IT, and IT Ops services with a fast-paced, nimble, thoroughly professional culture that enables fast, reliable delivery of software solutions. As a Microsoft Silver Certified Partner, F&I Admin’s solution set offers deep opportunities to work with all the latest Microsoft SaaS technology stack, as well as exciting technologies from other vendors such as Sisense, Mesophers, Dockers, and more.

Walkin for you