• IMAGE: Return to Main
  • IMAGE: Show All Jobs

Position Details: Systems Administrator Lead IV - 16171

Location: Downtown, IL
Openings: 1
Job Number:



Position Purpose: We are seeking a talented Lead MSBI developer in Data Management and Architecture to join our Insurance Solutions team. This position requires strong hands on experience in SQL, SSIS, SSRS and ETL development and support and involvement in large data management & reporting activities for an Insurance client.

Essential Job Responsibilities:
 Engage with Business users to gather requirements and translate requirements into data conversion mappings, batch processing, design ETL Architecture, DB Structures, reports, views and BI query objects.
 Develop ETL using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) from heterogeneous data sources utilizing strong understanding of source and target data structures, ETL processes and Data warehouse schemas.
 Develop complex batch solutions using T-SQL/ PL-SQL
 Well versed with new MSBI technologies to support dynamic and intelligent solutions.
The above statements are intended only to describe the general nature of the job, and should not be construed as an all-inclusive list of position responsibilities.

Required Qualifications:
 Bachelor's degree in Computer Science, Software Engineering, or equivalent
Job Related Experience:
 Minimum 10 years of hands on development experience in creating MSBI & Reporting solutions on the Microsoft SQL Server Platform and strong hands-on SQL queries.
 Real time development experience in T-SQL/ PL-SQL. Must have strong hands on experience in building complex SQL Stored procedures, views.
 Must have strong hands on experience in building high scalable SSIS and SSRS packages.
 Must have strong hands on experience in working on large-scale database architectures including Conversions and Migrations
 Strong hands on experience on SQL Server 2012/2014 especially T-SQL, ETL, conversions, Reporting etc.
 Strong hands on experience in SSRS reports, SSAS, Cubes, MDX queries.
 Strong query optimization and performance experience, Troubleshooting BI tool problem, Performance tuning.
 Experienced in new technology research and implementation.
 Strong communication skills with Customer facing experience.
 Strong problem-solving and analytical skills with strong business sense
 Strong experience with performance optimization and tuning with database applications is a must.
 Mature, confident team player motivated by a fast paced environment.

Additional Skills/Knowledge:
 Good to have Warranty Insurance domain knowledge
 Self-starter with excellent interpersonal, facilitation, and motivational skills. Must be focused with the ability to work independently and in teams.
 Ability to logically identify and resolve issues using root cause analysis.
 Proven track record of producing high quality deliverable against plans and schedules that are being met consistently.
 Quick learner, eager to leverage new technologies in a dynamic team environment.                                                                           

Perform an action:

IMAGE: Apply to Position
mautic is open source marketing automation

Powered by: CATS - Applicant Tracking System