Data Architect / Developer

Forrest T. Jones & Company, Inc., and its affiliates (“FTJ”), provide insurance and insurance related services to clients, corporations, employers, and individuals. These services include providing benefits through innovativelife and health insurance plans, financial services, and customized insurance products for niche markets.

Position Summary

The Data Architect defines and drives FTJ’s enterprise data strategy and architecture, ensuring data is governed, secure, consistent, and usable across the organization. The role establishes enterprise data standards and provides leadership for data quality, integration, normalization, reporting, analytics, AI readiness, and modernization. A key focus is creating repeatable methods for profiling, mapping, converting, and validating data from acquired books of business while defining the future-state roadmap for FTJ’s enterprise data warehouse and analytics platforms.

Key Responsibilities

• Develop and maintain FTJ’s enterprise data strategy, target architecture, standards, and multiyear modernization roadmap.
• Establish a practical governance framework covering data ownership, stewardship, quality, classification, retention, lineage, access, and usage.
• Define canonical models, business definitions, authoritative systems of record, and normalization standards for critical insurance and corporate data domains.
• Create a repeatable methodology for profiling, mapping, cleansing, converting, validating, and integrating acquired books of business.
• Lead architecture for the future data warehouse and related Microsoft Fabric, Power BI, reporting, analytics, and AI capabilities.
• Define standards for conceptual and logical models, ETL/ELT, APIs, pipelines, metadata, master/reference data, and system integration.
• Establish measurable data-quality controls and partner with business owners to resolve material issues and conflicting definitions.
• Maintain data flow, lineage, integration, and architecture documentation for critical systems and processes.
• Partner with the Enterprise Architect, Principal Software Architect, Azure Architect, DBAs, Security, PMO, application teams, and business leaders; mentor teams and provide oversight for conversions, integrations, application replacements, and modernization initiatives.
• Identify data risks, dependencies, technical debt, privacy, regulatory, audit, retention, and access-control requirements; recommend solutions based on business value, scalability, maintainability, risk, and cost.

Qualifications

• Bachelor’s degree in information systems, computer science, data management, or a related field, or equivalent experience; eight or more years of progressive data architecture, data management, or data engineering experience.
• Demonstrated success developing enterprise data strategies, governance practices, architecture roadmaps, and complex data migration, conversion, normalization, or acquisition-integration solutions.
• Strong knowledge of data modeling, quality, integration, warehousing, metadata, master/reference data, relational databases, cloud data platforms, ETL/ELT, APIs, pipelines, security, privacy, retention, and regulatory compliance.
• Ability to translate business needs into actionable architecture and establish accountability across technical and business teams.

Preferred: Insurance or financial-services experience; acquired book-of-business integration; Microsoft SQL Server, Azure data services, Microsoft Fabric, Power BI, Purview, and Azure Data Factory; DAMA-DMBOK, TOGAF, or relevant Microsoft/DAMA certification.

We offer comprehensive benefits to full-time employees including company-paid medical, STD, LTD and life insurance plus voluntary dental, vision, life/AD&D insurance, 401(k) with company matching, generous paid time off and much more.

We encourage applicants of all ages and experience, as we do not discriminate on the basis of an applicant’s age.

ALL OFFERS OF EMPLOYMENT ARE CONTINGENT UPON THE PASSING OF A DRUG SCREEN AND BACKGROUND CHECK.