Job Summary The Senior BI developer, in our BI team specializing in Microsoft SSIS, SSAS, DAX, SSRS, will play key role in developing and maintaining our BI capabilities.
The BI Developer will design, implement and maintain ETL processes, SSAS tabular model etc. using SQL Server BI tools to support business need in reporting and dashboards.
This position is required to report to the SHI Somerset NJ office location as determined by SHI management. About Us Founded in 1989, SHI International is an $11 billion global provider of IT solutions and services.
SHI currently has 5,000 employees worldwide. To learn more about SHI International Corp, visit our website : (url removed) What SHI Can Offer : World Class Facility includes on site gyms and cafeterias Ongoing opportunities for personal and professional growth and development due to our strong promote from within philosophy Work in an up-beat, creative, and fun environment Benefits including medical, vision, dental, 401K, and flexible spending Responsibilities Proactively identifying problems / issues concerning data accuracy, data integrity and relevance.
Designing, developing and optimizing complex SQL stored procedures to meet data management and data integration objectives.
Designing, developing and maintaining ETL processes that transform data and populates data warehouse. Designing, developing and maintaining SSAS tabular model and complex DAX calculations.
Designing, developing and maintaining SSRS reports. Creating and maintaining documentation that describes the solutions.
Qualifications Bachelor's degree in Computer Science, Information Science related field. 5+ years of extensive experience in data warehouse design, SQL Server SSIS, SSAS.
Solid experience in ETL package design, development, troubleshooting and performance tuning using SQL Server SSIS. Solid understanding of Kimball Dimensional Design methodology and solid experience in star schema modeling using the methodology.
Required Skills Solid understanding of relational database theory, principles and best practices. Highly proficient in T-SQL script development using stored procedures, views, user defined functions etc.
Strong ability to analyze data and identify data quality issues. Proficient in DAX. Ability to work with business users to understand business requirements and translate them into a implementation detail.
Excellent communication skills. Ability to identify business and technical impacts of user requirements and incorporate them into existing system.
Ability to work both independently and as part of team. Ability to multi-task, take initiative in solving problem. Preferred Skills Proficient in DAX.
Having Master degree in Computer Science , Math. Equal Employment Opportunity ? M / F / Disability / Protected Veteran Status Additional Information FLSA Status : Exempt Equal Employment Opportunity ?
M / F / Disability / Protected Veteran Status >