Enterprise Data Specialist collaborating on data architecture for enterprise data warehouse solutions. Involves working with IT and business stakeholders for optimal data integration and reporting.
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
Source 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
Requirements
10+ years of data architecture and design experience
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
Technical Lead for Testing Services responsible for automation testing and developing test frameworks. Collaborating with BA, developers, and users to enhance RAG GenAI applications.
Lead Engineer developing AI - driven solutions for asset management at Hypha. Collaborating with stakeholders and mentoring engineers while owning product areas from concept to delivery.
Staff Forward Deployed Software Engineer designing scalable automation solutions for various businesses at TriEdge Investments. Leading technical direction while remaining hands - on in code and architecture.
Full - Stack Engineer developing features on an AI - native platform focusing on healthcare and real estate. Collaborating with team lead and design partners to deliver user - ready experiences.
Senior Engineer managing project reporting and controls for construction projects in India. Focusing on data analysis, optimization, and stakeholder collaboration in large - scale projects.
Infrastructure Engineer at Sentry designing and maintaining systems to help teams build reliable software. Focused on creating tools that improve reliability and developer experience within a hybrid work culture.
Lead Software Architect responsible for Teamcenter PLM implementation and enhancements at Baker Hughes. Collaborating with diverse teams to drive digital transformation initiatives across global operations.
Junior Softwareentwickler developing software components for demodulation and decoding of radio signals in diverse applications. Collaborating in an agile team at PROCITEC to innovate signal processing solutions.
Junior Software Engineer developing software for demodulation and decoding of radio signals. Collaborating with a team on projects using C++ and Python.