Hybrid, 3x per week
Location: Newport Beach, CA

We are currently seeking a highly skilled and experienced Data Architect to join our team in Newport Beach, CA. The ideal candidate will have a strong background in data architecture, particularly within the financial services industry, and possess a blend of technical skills and strategic thinking. This role demands proficiency in ETL development, Python programming, and Snowflake, with additional experience in AWS being a significant advantage.

Key Responsibilities:

• Design and implement effective database solutions and models to store and retrieve company data.
• Examine and identify database structural necessities by evaluating client operations, applications, and programming.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Install and organize information systems to guarantee company functionality.
• Prepare accurate database design and architecture reports for management and executive teams.
• Oversee the migration of data from legacy systems to new solutions.
• Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
• Recommend solutions to improve new and existing database systems.
• Educate staff members through training and individual support.
• Offer support by responding to system problems in a timely manner.

Essential Requirements:

1. Educational Background: Bachelor’s degree in Computer Science, Information Systems, or a related field.
2. Professional Experience: At least 5 years of experience in ETL development, with a strong preference for candidates with experience in the financial services industry.
3. Technical Proficiency:
   • Expertise in API integration using Python.
   • Proficiency with ETL tools such as Airflow, Informatica, SSIS, or Talend.
   • Strong knowledge of SQL and relational databases.
   • Familiarity with Snowflake; understanding of AWS is a major plus.
4. Knowledge and Skills:
   • Deep understanding of data warehousing concepts and methodologies.
   • Familiarity with financial data and systems.
   • Excellent problem-solving skills and attention to detail.
   • Strong communication and teamwork skills.