Job Description
Senior technical lead
Job Summary
-
Location: New York
-
Project role: Senior technical lead
-
Skills: ETL
- Secondary Skills:
- SQL
- Python
-
No. of positions: 1
-
Pay Range Minimum: $88000
-
Pay Range Maximum: $134000
Job description:
Role: Enterprise Data Specialist
No. of Positions: 1
Hiring Mode: Contract (TP)
Location: [On-site]
Alpharetta, GA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS
Client: Sampo Insurance
Bill Rate: $75-$85/hr max. all inclusive C2C [Based on exp. & location rate may vary]
Job Description:
- Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications.
- 10+ years of data architecture and design experience working with development team to extract data directly from source applications and loading to an enterprise data warehouse.
- 3+ years of experience within the Insurance and reinsurance domain.
- Advanced experience with extracting data from Insurance applications.
- Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks.
- Capable of creating and tuning Semantic layer Reporting Views.
- Capable of facilitating data discovery sessions involving business subject matter experts.
- Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL.
- Architect and design comprehensive solutions for the enterprise data warehouse. Sourcing data from multiple Insurance and Reinsurance Policy, Treaty, Claim and financial systems.
- Design and implement Source to Target mappings optimized for high-volume data integration.
- Create logical and physical data models and implement them on SQL Server platforms.
- Work closely with the development team to ensure accurate translation of mappings into code.
- Develop strategies for data collection and ingestion and write SQL based solutions to validate data accuracy and integrity in the data warehouse.
- Analyze and design enterprise data models for optimal reporting. Support reporting teams in understanding and utilizing the data warehouse model effectively.
- Participate in release planning and validate changes post-deployment.
- Develop SQL Server views for reporting and dashboard development. Troubleshoot and optimize SQL and Informatica mappings and stored procedures.
Compensation and Benefits
A candidate’s pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.
Disclaimer
HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@hcltech.com for investigation.