Senior Software Engineer
Company Name:
FM Global
FM Global is a leading property insurer of the world's largest businesses, providing more than one-third of FORTUNE 1000-size companies with engineering-based risk management and property insurance solutions. FM Global helps clients maintain continuity in their business operations by drawing upon state-of-the-art loss-prevention engineering and research; risk management skills and support services; tailored risk transfer capabilities; and superior financial strength. To do so, we rely on a dynamic, culturally diverse group of employees, working in more than 100 countries, in a variety of challenging roles.
In addition to being capable of designing and building state of the art business applications and preparing technical specifications based on evaluation of business specifications for complex business requirements, the person filling this position will be an expert in SSIS ETLdesign and development. He/she will be responsible for analyzing source data against business requirements, then designing, developing and implementing highly efficient, highly scalable ETL processes.
This Senior Software Engineer will take a big-picture view of the company's data situation, understand what the business wants to accomplish with its data, and then design the best possible ETL process around those goals.
He/she will:
Design, develop, maintain and support SSIS packages related to the extraction, transformation and loading (ETL) process with SQL
Server Integration Services (SSIS) 2008/2012;
Write T-SQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletes;
Be responsible for data profiling, source-target mappings, SQL tunings and optimization;
Provide business and technical analysis, development and project management expertise for business and technology initiatives
focusing on Data Warehouse and Business Intelligence solutions;
Develop detailed technical specifications and ETL documentation in collaboration with data analysts and Business Intelligence
developers;
Design ETL audit control and scheduling processes;
Collaborate with quality assurance specialists and develop testing and implementation strategy, conduct appropriate functional and
performance testing to identify and resolve process bottlenecks and data quality issues;
Collaborate with Business Analysts and Business Intelligence Developers throughout the Solution Development Life Cycle process
for requirements gathering, feedback on proposed designs and models, and acceptance testing.
4
years of in-depth experience in object oriented business application design and development in a complex client server environment with a focus on integration services.
Bachelor degree in Computer Science, Information technology, or a related discipline, or equivalent work experience and technical training with a non-related Bachelor degree.
Must possess the following technical skills:
ETL Tools: SSIS
Databases & Utilities: Microsoft SQL Server 2008/2012
Platforms: Primarily Microsoft, some Unix
SQL Language
Experience with:
Business Intelligence and Data Warehousing Concepts including Microsoft Excel BI Took Kit and Power BI;
Star and Snowflake schemas;
Writing technical documentation;
. Software Development Life Cycle;
Domain knowledge in the following areas:
Information Technology;
Insurance Analytics.
Date: 2014-09-16
Country: US
State: RI
City: Johnston
Postal Code: 02919
Category: Information Services - Software Engineer
Job Type: Regular Full-TimeEstimated Salary: $20 to $28 per hour based on qualifications.
FM Global
FM Global is a leading property insurer of the world's largest businesses, providing more than one-third of FORTUNE 1000-size companies with engineering-based risk management and property insurance solutions. FM Global helps clients maintain continuity in their business operations by drawing upon state-of-the-art loss-prevention engineering and research; risk management skills and support services; tailored risk transfer capabilities; and superior financial strength. To do so, we rely on a dynamic, culturally diverse group of employees, working in more than 100 countries, in a variety of challenging roles.
In addition to being capable of designing and building state of the art business applications and preparing technical specifications based on evaluation of business specifications for complex business requirements, the person filling this position will be an expert in SSIS ETLdesign and development. He/she will be responsible for analyzing source data against business requirements, then designing, developing and implementing highly efficient, highly scalable ETL processes.
This Senior Software Engineer will take a big-picture view of the company's data situation, understand what the business wants to accomplish with its data, and then design the best possible ETL process around those goals.
He/she will:
Design, develop, maintain and support SSIS packages related to the extraction, transformation and loading (ETL) process with SQL
Server Integration Services (SSIS) 2008/2012;
Write T-SQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletes;
Be responsible for data profiling, source-target mappings, SQL tunings and optimization;
Provide business and technical analysis, development and project management expertise for business and technology initiatives
focusing on Data Warehouse and Business Intelligence solutions;
Develop detailed technical specifications and ETL documentation in collaboration with data analysts and Business Intelligence
developers;
Design ETL audit control and scheduling processes;
Collaborate with quality assurance specialists and develop testing and implementation strategy, conduct appropriate functional and
performance testing to identify and resolve process bottlenecks and data quality issues;
Collaborate with Business Analysts and Business Intelligence Developers throughout the Solution Development Life Cycle process
for requirements gathering, feedback on proposed designs and models, and acceptance testing.
4
years of in-depth experience in object oriented business application design and development in a complex client server environment with a focus on integration services.
Bachelor degree in Computer Science, Information technology, or a related discipline, or equivalent work experience and technical training with a non-related Bachelor degree.
Must possess the following technical skills:
ETL Tools: SSIS
Databases & Utilities: Microsoft SQL Server 2008/2012
Platforms: Primarily Microsoft, some Unix
SQL Language
Experience with:
Business Intelligence and Data Warehousing Concepts including Microsoft Excel BI Took Kit and Power BI;
Star and Snowflake schemas;
Writing technical documentation;
. Software Development Life Cycle;
Domain knowledge in the following areas:
Information Technology;
Insurance Analytics.
Date: 2014-09-16
Country: US
State: RI
City: Johnston
Postal Code: 02919
Category: Information Services - Software Engineer
Job Type: Regular Full-TimeEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
