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.
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,
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.
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.