Apply on Employer Site

Birlasoft · 21 hours ago

Sr Technical Lead-Enterprise Apps

Middlesex County, NJ

Full-time

Hybrid

Senior Level, Lead/Staff

10+ years exp

Birlasoft is seeking a Sr Technical Lead-Enterprise Apps to focus on designing, modeling, and mapping data solutions for the enterprise data warehouse. This role requires collaboration with business stakeholders and IT teams to drive data initiatives that enhance operational performance and support the development of an industry-leading data warehouse.

Software

H1B Sponsor Likely

Responsibilities

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

Qualification

Data architectureData warehousingETL processesSQL ServerInsurance domain experienceGuidewire applicationsRDBMS knowledgeData modelingBusiness collaborationData validation

Required

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

Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications

B.S. Degree in Computer Information Science, Information Management, or Statistics

Company

Birlasoft

Glassdoor3.6

Founded in 1995, Birlasoft is a Global IT Services provider and part of the 150 year old, multi-billion dollar CK Birla Group.

Founded in 1995

Noida, Uttar Pradesh, IND

10001+ employees

http://birlasoft.com

H1B Sponsorship

Birlasoft has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (195)

2024 (202)

2023 (180)

2022 (250)

2021 (259)

2020 (262)