Data Warehouse Analyst

At WorldTrips, a proud member of the Tokio Marine HCC group of companies, we believe in more than just business-we believe in empowering our people. As a global leader in specialty travel medical and trip protection insurance, we are passionate about preparing travelers for the unpredictable while fostering a work environment where bold ideas and transformative solutions are valued at every level. Our mission, "To Be a Good Company," reflects our commitment to people and community, recognizing the importance of giving back and driving positive change.

We are proud to be named as a Top Workplace Winner for the past two years by IndyStar! Our renovated office, located in Carmel, IN, is only steps away from the Carmel City Center for shopping, dining, and entertainment.

The Adventure Ahead:

As the Data Warehouse Analyst, you will design, develop, install, maintain, and support an enterprise data warehouse system. Ensure data accuracy and consistency, delivering actionable insights to support business decisions.

• Determine logical and physical architecture requirements necessary to integrate new or existing sources into an Enterprise Business Intelligence (data warehouse) system and continuously improve how the system functions
• Review, evaluate, design, test, implement, and maintain company database to support the organizations data needs
• Install and configure relevant software components to ensure the success of Business Intelligence Architecture and Data Integration processes, accessibility, and availability
• Consult with clients and team members to obtain requirements needed for constructing business intelligence architectures
• Create standards for installation, operational support, and information security to adhere to corporate IT standards.
• Write code for database access, modifications, and construction including stored procedures and extract/transfer/load (ETL) packages to integrate new or existing data sources
• Integrate Change Data Capture software to monitor transaction data from source systems
• Deliver Business Intelligence Solutions using Microsoft technology such as SharePoint, Excel, Analysis Services, Reporting Services, and others

Skills and Experience Needed:

• Bachelors degree in a related field, or the equivalent education and /or experience
• Minimum of two years of relevant and progressive professional experience
• Demonstrated ability of exceptional attention to detail to manage multiple tasks simultaneously; exceptional organizational and analytical skills
• Demonstrated ability of excellent written and verbal communication skills with an emphasis on confidentiality, tact, and diplomacy

We offer a competitive salary and benefits package including:

• Hybrid position (3 days in-office) with a flexible work schedule
• Full benefits (Medical, Dental, Vision, 401k)
• Eleven company paid holidays plus 20 PTO days
• Casual dress environment

WorldTrips is an equal opportunity employer. Join a team where your success is our priority.

#LI-CM2

#LI-Hybrid

#INDWT