Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world.
Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world’s fastest growing insurance organizations, capable of writing in 128 countries on 6 continents.
Starr Companies is a global insurance and investment organization, established in 1919 and built on 100 years of international literacy and operational knowledge. The Data Operations group is seeking an experienced SQL / .Net Developer who is passionate about data and understanding data relationships and analytics. This addition to staff will be part of an existing team of programmers/developers who will be responsible for supporting and enhancing one of Starr's key Premium Processing Systems and related source databases. The Developer will work in collaboration with the other engineers, business analysts and key stakeholders to design robust and scalable data extraction, transformation and loading solutions.
Essential Functions:
SQL Development & Data Management
- Implement and maintain ETL/ELT solutions ensuring proper database coding standards, and quality assurance procedures using SQL and .Net.
- Implement and maintain effective mapping of multiple source and target systems in support of accurate premium feeding/reporting in Starr.
- Employ new and existing systems in the creation of ETL processes, and data quality validation techniques.
- Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
- Able to write effective unit, integration, and e2e tests
- Ensure data standards are reused and enforced across all data-driven initiatives.
Effective Communication and Team Collaboration
- Translate technical activities and objectives in a manner appropriate for various audiences and stakeholders during 1-on-1 interactions, meetings and/or conference calls.
- Proactively seek guidance on issues requiring additional clarity or instruction from other team members or management.
- Review designs by other team members and give constructive feedback in meetings or written form when required.
- Share accrued knowledge through the use of meetings, walk-thrus, conference calls and other appropriate methods.
- Follow departmental workflow processes and work in a transparent manner.
Position Requirements:
- Bachelor’s Degree (major in information technology or related field preferred)
- Minimum 5 years of SQL and 3 years of .Net programming experience in a corporate environment
- Recent experience in developing ETL
- Performance tuning experience a PLUS
- JSON experience a PLUS
- Insurance or Financial Services industry background a PLUS
For individuals assigned and/or hired to work in New York, Starr Insurance Companies is required by law to include a reasonable estimate of the compensation range for this role. The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets: experience and training: licensure and certifications: and other business and organizational needs. A reasonable estimate of the current range is $120,000-$130,000
Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.