KTek Resourcing
Enterprise Data Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an Enterprise Data Architect in Houston, TX, on a 6+ month contract. Requires 12+ years in data architecture, 3+ years in insurance, and expertise in ETL, SQL Server, and data warehousing. USC, GC, and GC EAD only.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
December 17, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Houston, TX
-
🧠 - Skills detailed
#"ETL (Extract #Transform #Load)" #SQL Server #Data Architecture #Data Accuracy #BI (Business Intelligence) #Deployment #EDW (Enterprise Data Warehouse) #Informatica #RDBMS (Relational Database Management System) #Data Warehouse #Data Integration #MS SQL (Microsoft SQL Server) #SQL (Structured Query Language) #Physical Data Model
Role description
Enterprise Data Specialist/Architect (ETL, Informatica, Insurance)
Location: Houston, TX (Onsite, Other multiple location also)
Contract: 6+ months
Client: HCL America
USC, GC and GC Ead only
•
• Update LinkedIn ID Required
Requirement:
• Min 12+ 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 insurance domain.
• The Enterprise Data Specialist is a pivotal role focused on designing, modeling, and mapping data solutions for the enterprise data warehouse.
• This position requires a strategic approach to data architecture, ensuring robust data models and seamless data integration.
• The Enterprise Data Specialist will collaborate with business stakeholders and IT teams to drive data initiatives that enhance operational performance and support the development of an industry-leading data warehouse.
• 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.
• Collaborate with business stakeholders and IT teams to define and document data architecture and modeling needs.
• 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.
Enterprise Data Specialist/Architect (ETL, Informatica, Insurance)
Location: Houston, TX (Onsite, Other multiple location also)
Contract: 6+ months
Client: HCL America
USC, GC and GC Ead only
•
• Update LinkedIn ID Required
Requirement:
• Min 12+ 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 insurance domain.
• The Enterprise Data Specialist is a pivotal role focused on designing, modeling, and mapping data solutions for the enterprise data warehouse.
• This position requires a strategic approach to data architecture, ensuring robust data models and seamless data integration.
• The Enterprise Data Specialist will collaborate with business stakeholders and IT teams to drive data initiatives that enhance operational performance and support the development of an industry-leading data warehouse.
• 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.
• Collaborate with business stakeholders and IT teams to define and document data architecture and modeling needs.
• 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.
