Data Warehouse Intern/Hybrid

Marketing Statement:
Tokio Marine North America Services (TMNAS) provides professional support services to Tokio Marine Group companies in the United States, including Tokio Marine America, First Insurance Company of Hawaii, and Philadelphia Insurance Companies. Customer service is our focus and our passion! Tokio Marine North America Services adds value in all that we do, providing the best professional service to our business partners, allowing them to achieve their goals. Our talented team delivers actuarial, audit, corporate communications, financial and investment, human capital services, information technology, legal, and payroll expertise to our customers.
The TMNAS Data Warehouse Intern is an operational and functional resource role within the TMNAS IT department.
The successful candidate will have the opportunity to gain experience across multiple areas including database coding, ETL development, Python development, and other more advanced data warehousing tools. Additionally, the candidate will gain hands on experience in analyzing business processes, technical documentation, managing change within an organization's IT systems, and practical property and casualty insurance knowledge.
Job Responsibilities
Specific job responsibilities for the intern are based on need but can include:

• Developing new and maintaining existing TSQL code.
• Creating and maintaining technical documentation.
• Analyzing business processes and automating them.
• Collecting and reporting performance metrics.
• Performance tuning of SQL queries and processes.
• Working with and developing Python scripts.
• Interacting with and presenting data from Snowflake.
• Documentation of standard operating procedures.
• Complying with proper internal controls as necessary to conduct job functions.
• Performing special projects and/or activities as may be assigned.

Degree / Licenses and Professional Certifications

• Coursework in Computer Science or Information Technology

Experience

• Basic experience working within an IT, administrative or equivalent corporate function.

Knowledge

• Knowledge of the basics of database management systems, data manipulation and data retrieval preferred
• Strong background in mathematics. Exposure to statistics or quantitative analysis a plus
• Knowledge of Microsoft Office (Excel, Word, SharePoint) and/or other general spreadsheet / word processing tools.
• Entry-level programming skills preferred
• Must be actively enrolled in an undergraduate program with a related major

Skills

• Basic database skills, including knowledge of SQL. TSQL experience a plus.
• Strong collaborative and teamwork skills.

• Strong writing and verbal communication skills.
• Strong customer service orientation.
• Strong analytic skills.
• Strong interpersonal skills: able to work with a variety of people and groups in a constructive and collaborative manner.
• Strong time management skills.

Abilities

• Ability to pay close attention to details.
• Ability to work to deadlines and set correct priorities.
• Ability to work independently and focus on task-level goals.

EEO Statement:
Tokio Marine Group of Companies (including, but not limited to the Philadelphia Insurance Companies, Tokio Marine America, Inc., TMNA Services, LLC, TM Claims Service, Inc. and First Insurance Company of Hawaii, Ltd.) is an Equal Opportunity Employer. In
order to remain competitive we must attract, develop, motivate, and retain the most qualified employees regardless of age, color, race, religion, gender, disability, national or ethnic origin, family circumstances, life experiences, marital status, military status, sexual orientation and/or any other status protected by law.