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
Director of Software Engineering at Acuity leading AI - enabled digital commerce platform development and transforming user experience with modern architecture.
Senior Product Engineer leading application and integration of protection and control solutions by Hubbell. Collaborating with engineering, sales, and customer support to deploy tailored technical solutions.
Software Engineer leading a team to develop high quality software solutions for DoD training systems. Supporting the JTSE program at Joint Staff Complex in Suffolk, VA.
Lead Principal Engineer Specialist at SAE facilitating aviation standards through technical management and collaboration. Recruiting and mentoring volunteers while driving continuous improvement initiatives in a hybrid work environment.
Product Engineer overseeing the technical lifecycle of screening and biomass handling products for Valmet. Collaborating with global teams and providing engineering expertise across the product lifecycle.
Lead ETL Developer responsible for ETL solutions involving data integration and automation. Working in a hybrid environment at Canada Life with a strong emphasis on collaboration.
Senior Software Engineer developing high - quality software solutions for Savanta. Collaborating with cross - functional teams in a hybrid work environment to deliver impactful products.
Technical Lead developing and evolving iTakeControl, a clinical trial patient engagement platform at Red Nucleus. Leading in - house product development with a focus on compliance and mentoring engineers.
Principal Software Engineer developing and enhancing secure software systems for Northrop Grumman's CHORD portfolio. Focused on collaboration, team empowerment, and personal responsibility in a complex technical environment.
Software Engineer developing Python applications on Linux for Northrop Grumman's Space Sector. Collaborating with cross - functional teams to deliver secure, scalable software in a SCIF environment.