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
Senior Backend Engineer responsible for developing scalable backend solutions in Java at Bazaarvoice. Collaborating with cross - functional teams to optimize services for high consumer interaction.
Senior Java Developer at dLocal responsible for creating robust payment solutions in a dynamic fintech environment with a focus on high performance and innovation.
Engineer III building scalable solutions within trading engineering for Fanatics' sports platform. Contributing to real - time systems and collaborating with cross - functional teams in a dynamic environment.
Principal Quality Engineer leading post - market quality and compliance for infusion systems and temperature management products. Responsible for product quality improvements and regulatory compliance solutions.
Lead Engineer designing and managing network safety - critical software solutions for Honeywell's Aerospace Technologies. Collaborate with teams to exceed industry standards and innovate software solutions.
Lead engineer for electronics product development at Ralliant Corporation. Overseeing design, development, and team performance in a hybrid working environment.
Software Developer II supporting MJML technical ownership and contributing to the evolution of the Mailjet template editor at Sinch. Collaborate with engineering, product, and design teams for high - quality user experience.
Senior Engineer responsible for leading EUC solutions and IT support initiatives at Digital Realty. Collaborating with global IT teams to enhance infrastructure and support services.
Lead Software Architect defining and delivering next - generation frontend platform architecture for Resideo. Requires expertise in modern frontend technologies, AI practices, and strong leadership.