Senior Data Warehouse Analyst

IT Business Intelligence Kennesaw, Georgia

  • Job Category:

    IT Business Intelligence

  • Location:

    Kennesaw, Georgia

  • Job Type:


  • Number of Openings:



Position at Tokio Marine HCC

Tokio Marine HCC (TMHCC) brings 50 years of service to the specialty insurance industry, today offering over 100 products to commercial customers in 180 countries around the world.  Organic growth and over 60 successful acquisitions have grown our 2022 Gross Written Premium (GWP) to $5 Billion.  Our workforce has grown to 4,300 worldwide … big, but not so big that you cannot make a difference.  Our Good Company values, including integrity, empowerment, and commitment to customer service, and a culture of innovation, communication, and collaboration make TMHCC a great place to work.   
TMHCC Stop Loss, a $2 Billion division within TMHCC, leads the way in providing medical stop loss insurance sold to employers. Medical Stop Loss provides an added layer of insurance protection to employers who choose to self-fund their health benefit plans. Self-funding can incur risks from catastrophic claims, and Medical Stop Loss insurance from Tokio Marine HCC is designed to protect employers from that risk.

This is a Hybrid work position with 3 days at our Kennesaw, GA Office and 2 days remote. 


Position Summary:
With limited supervision, designs, develops, installs, maintains, and supports an enterprise data warehouse system (and corresponding data marts), inclusive of an understanding and experience with end user tool sets utilized to access an Enterprise Decision Support System.  
Key Responsibilities:  
  • Own and develop relationships with end users, working with them to optimize and enhance existing reports and integrations
  • Design and improve current ETL processes by writing code for database access, modifications, and construction including stored procedures and extract/transfer/load (ETL) packages to integrate new or existing data sources.
  • Create and modify SISS Packages as needed (C# scripting language used)
  • Write and modify SSRS Reports
  • Determine logical and physical architecture requirements necessary to integrate new or existing sources into an Enterprise Business Intelligence (data warehouse) system.
  • Create logical and physical models for new database development and/or changes to existing ones.
  • Review, evaluate, design, test, implement, and maintain company database(s) to support the organizations data needs for Business Intelligence Architecture and Data Integration.
  • 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 for Business Intelligence, and Data Integration to adhere to corporate IT standards.
  • Integrate Change Data Capture software to monitor transaction data from source systems.
  • Integrate new data with existing warehouse structure and continuously improves how the system functions.
  • Deliver Business Intelligence Solutions using Microsoft technology such as SharePoint, Excel, Analysis Services, Reporting Services, and others.
  • 4 Year Bachelors Degree in Computer Science, a related field, or the equivalent education and/or experience
  • 8 years relevant and progressive professional experience
  • Possess and have ability to apply broad knowledge of principles, practices, and procedures
  • Excellent written and verbal communications skills with an emphasis on confidentiality, tact, and diplomacy
  • Exceptional organizational and analytical skills; demonstrated ability to manage multiple tasks simultaneously
  • Knowledgeable of industry changes, legal updates, and technical developments related to applicable area of the Company's business to proactively respond to changing business environment
  • Intermediate proficiency and experience using Microsoft Office package (Excel, Access, PowerPoint, Word)
  • Strong SQL knowledge and experience with SQL Performance Tuning including Microsoft SQL Server 2012 or above, Transact-SQL, and business Intelligence Development Studio (SSAS, SSIS, SSRS, Visual Studio)
  • Strong experience with data analysis
  • Power BI Experience preferred
  • Familiarity with MDX
  • Accounting knowledge helpful but not required
  • Operational Data Warehouse experience

Additional Information:  

  • Hybrid work position with 3 days at our Kennesaw Office and 2 days remote.
  • Overtime hours may be required to fulfill job responsibilities
  • May be required to remain stationary for extended periods of time
  • May be required to move up to 10 pounds
  • Must be able to operate a computer and other devices
  • Close vision and ability to adjust focus, such as required to read a computer screen
  • Occasional travel (up to 10% of time)
Tokio Marine offers a competitive salary and benefits package, including:   
  • Generous paid time off (PTO), 12 paid company holidays,
  • 401(k) Retirement Plan with 6% company match.
  • Health and dental insurance, and vision plan available.
  • Company-provided long-term disability and life insurance.
  • Opportunities for advancement in a successful and growing organization.
  • Flexible work schedules and a great work/life balance.
  • Paid Parental Leave.
  • Volunteer Time Off.
  • Enjoy casual dress and work in a modern, comfortable office with free parking.
  • Hybrid work schedule
The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefits package. We are a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals. The Tokio Marine HCC Group of Companies is an equal opportunity employer. Please visit for more information about our companies.