Principal Data Modeler & Architect

Job Title: Principal, Data Modeler & Architect

Location: NYC, Bridgewater, NJ or Cary, NC (Hybrid - minimum of 3 days in office)

About The Company

A Fortune-recognized global financial services leader with operations in more than 40 markets worldwide. We provide insurance, annuities, employee benefits, and asset management to individual and institutional customers. We are committed to helping our colleagues, customers, communities, and the world at large create a more confident future. Our culture is guided by core values of winning together, doing the right thing, delivering impact over activity, and thinking ahead.

Job Summary

We are looking for a Principal (Director-level), Data Modeler & Architect to join our newly consolidated Data and Analytics (D&A) organization supporting our U.S. Business. The ideal candidate will be a highly technical individual contributor with deep expertise in both traditional and modern data management, engineering, data modeling, visualization, Salesforce, and cloud technologies. This role will involve playing a critical role in the data and analytics life cycle and significantly contributing to the architecture and design of data and analytics solutions across all business lines.

Key Responsibilities

• End-to-End Data Architecture Design: Design and solution end-to-end data architecture for data hubs/data products and Salesforce data all the way from source systems to consumption via Salesforce, web applications, and reporting & analytics solutions. Solve complex problems using data and advanced technologies.
• Data Modeling & Pipeline Design: Own and approve data models for data domains within the U.S. Group Benefits business. Design data pipelines for analytical and operational needs. Build, optimize, and troubleshoot ETL/ELT pipelines to ingest and store large volumes of structured and unstructured data for batch/real-time processing.
• Innovation & Framework Development: Ideate, solution, and lead the building of reusable data frameworks for enterprise use. Lead POCs to evaluate new technologies, data products, Salesforce products, and solutions as needed.
• Governance & Standards: Provide oversight for ongoing initiatives and ensure adherence to defined architecture, quality, security, and compliance guidelines, policies, and standards. Define and develop data standards, guidelines, patterns, and recommendations to be used across the organization.
• Collaboration & Leadership: Collaborate with multiple partners from Business, Technology, Operations, and D&A capabilities including Data Governance, Data Quality, Data Modeling, Enterprise Architecture, Data Science, DevOps, and BI & Insights. Independently lead design, solutioning, and estimations.
  
  

Requirements

• Education: Bachelor's degree in computer science, information technology, or equivalent educational qualification
• Experience: 8 years of overall related experience in data architecture, data engineering, or similar roles
• Skills: Data architecture expertise in both traditional systems (Oracle, SQL Server) and modern platforms (AWS, Azure). Knowledge of Salesforce data architecture patterns. Data modeling for OLTP & OLAP systems using various data modeling techniques. ETL pipeline design and development; solutioning and estimation. Knowledge of data quality and governance practices. Knowledge of BI Tools (Tableau, Power BI, etc.). Experience with Big Data and Cloud Frameworks including Apache Spark, Hadoop, and Hive. Exposure to Azure data factory, Synapse and/or Databricks. Expertise in core data management processes.
• Certifications: Not specified
• Other: Strong understanding of data warehouses, data marts, and data lakes. Data integration strategies using APIs and ETL tools. Willingness to work hybrid schedule with minimum of 3 days per week in office.
  
  

Preferred Qualifications

• Exposure to Gen AI technology and tools
• Performance tuning, optimization, and data quality validation
• Real-time and batch data processing, streaming pipelines with Spark
• Banking, Financial Services, and Insurance domain knowledge
• Experience with EventHub and Azure functions, Azure data factory, Synapse, and Databricks
• DevOps practices: Git, Azure DevOps, CI/CD pipelines
• Unix shell scripting, Kafka, MongoDB, Nifi, containerization
  
  

Benefits

• Competitive Salary: $160,000 to $195,000, with eligibility for annual short-term incentive compensation
• Health and Wellness: Comprehensive health plan including medical/prescription drug and vision, dental insurance, no-cost short- and long-term disability, company-paid life insurance and legal services, and digital mental health programs
• Work-Life Balance: Flexible hybrid work arrangement, parental leave, volunteer time off, and Employee Assistance Program (EAP)
• Professional Development: Tuition assistance and opportunities to work with cutting-edge technologies
• Additional Perks: Retirement pension funded entirely by employer and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance