Business Data Analyst

guidewire policy center, claims center, etl
Full Time
Depends on Experience
Work from home not available Travel not required

Job Description

Business Data Analyst

HTC A brief profile

Established in 1990, HTC Inc., a CMM Level 5 company with headquarters in Troy, Michigan, is a leading global Information Technology solution and BPO provider. HTC assists clients across multiple industry verticals, offering turnkey project lifecycle in, e-business, data warehousing, embedded systems, ECM, SCM, CRM, and ERP solutions. HTC Inc. offers ConnectIT, our Global Delivery Methodology that enables seamlessly delivery of outsourced IT services. HTC has global delivery centers across the globe.

About the Job

HTC is seeking to hire a Business Data Analyst Expertise.

Location: Frankenmuth, MI


Duration: Long Term


Skills Required:


  • Develop data mapping document for flow of data from Policy Center/Claims Center(source) to EDW(Target)
  • Define fact table and dimension table mappings
  • Work as a liaison between Data warehouse and portal teams to ensure reporting requirements are met for analytics
  • Statistical Reporting to NISS on personal lines and ISO for commercial lines with appropriate codes
  • Work with large data sets, write and execute SQL queries to extract, review, and present reports to business units
  • Develop Data hub specs, EDW ETC tech Mapping and field mapping spread sheets
  • Maintain project documentation, procedures, training manuals with version control on the shared drive
  • Work on projects by co-coordinating across multiple teams by constantly updating with changes and updates which
  • impact deliverables
  • Perform analysis of the required data from the source systems and identify business rules that will be applied during
  • the ETL
  • Develop user requirements for reports and validate them using SAP business objects
  • Mule Soft, Policy Center, Billing Center (Guidewire), Claims Center, SAP Business Objects, Beyond Compare



HTC s competitive package includes besides compensation health, dental, vision, Disability cover, both Short and Long term, Life Insurance, Flexible Spending, 401k and paid vacation

Candidates should e-mail resume to VASU.GANNAMANENI@HTCINC.COM.


Posted By

3270 W Big Beaver Rd. Troy, MI, 48084

Dice Id : 10122753b
Position Id : 6302285
Originally Posted : 1 month ago
Have a Job? Post it

Similar Positions

Data Analyst
  • Qstride
  • Troy, MI
Sr. Data Scientist
  • Systems Technology Group Inc. (STG)
  • Auburn Hills, MI
DMPE - Technical Business Analyst
  • V2Soft
  • Auburn Hills, MI
Data Analytics Supervisor
  • Make Corporation
  • Southfield, MI
Data Analyst
  • C-Vision Inc.
  • Warren, MI
Data Warehouse Analyst with EDI
  • OrbITpeople
  • Troy, MI
Business/Data Analyst
  • Experis
  • Warren, MI
Digital Business/Marketing Specialist
  • Stefanini, Inc.
  • Auburn Hills, MI
Sr. Data Analyst
  • JDM Systems Consultants Inc
  • Warren, MI
Data Architect - R
  • Next Step Systems
  • Farmington Hills, MI
Data Warehouse Developer
  • Coverys
  • Lansing, MI
Data Analyst, Compensation
  • Quicken Loans Inc.
  • Detroit, MI
Sr. Business Analyst
  • IPS Technology Services, LLC
  • Troy, MI