Data Architect

Responsibilities

• Assess current SQL Server (Atlas) and Snowflake usage to identify structural gaps
• Design a formal Operational Data Store (ODS) featuring a centralized data dictionary and key entity model
• Define data architecture standards and governance practices aligned with domain-driven design
• Map existing batch data flows to FDR APIs as part of a batch-to-API migration roadmap
• Collaborate with domain teams to model customer, loan, payment, and interaction data entities
• Provide guidance on Snowflake best practices, distinguishing between analytical and operational usage
• Serve as a strategic thought partner to the client's internal Chief Data Architect

Requirements

• 10+ years of experience in data architecture roles
• Deep expertise in ODS design, data modelling, and data dictionaries
• Hands-on experience with Snowflake implementation and management
• Strong understanding of ETL/ELT pipelines and batch processing (Informatica experience is a plus)
• Proven experience within the financial services or lending domain
• Familiarity with API-based data integration patterns

Preferred Qualifications

• Experience with FDR or similar loan servicing platforms
• Knowledge of data mesh or domain-oriented data ownership models
• Familiarity with AI/ML data pipeline requirements
• Experience with data governance tooling such as Collibra or Alation
• Background in student lending or consumer finance

Benefits

• Competitive compensation ranging from USD 72,000 to USD 252,000 based on experience
• Medical, vision, and dental benefits
• 401k retirement plan
• Variable pay and incentives
• Paid time off and paid holidays

About the Company

Photon helps customers bring structure and intentionality to their data ecosystems, supporting modernization and AI-driven initiatives through expert architectural guidance.