Tokio Marine HCC
Data Warehouse Analyst - 3 days in-office
Tokio Marine HCC, Meridian, Idaho, United States, 83642
Data Warehouse Analyst
At WorldTrips, a proud member of the Tokio Marine HCC group of companies, we believe in more than just businesswe 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 three years by IndyStar! Our renovated office, located in Carmel, IN, is only steps away from the Carmel City Center for shopping, dining, and entertainment. This is a hybrid position (3 days in office). 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.
At WorldTrips, a proud member of the Tokio Marine HCC group of companies, we believe in more than just businesswe 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 three years by IndyStar! Our renovated office, located in Carmel, IN, is only steps away from the Carmel City Center for shopping, dining, and entertainment. This is a hybrid position (3 days in office). 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.