What are the responsibilities and job description for the Data Architect position at ASCENDING?
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:
- Educational Background: Bachelor’s degree in Computer Science, Information Systems, or a related field.
- Professional Experience: At least 5 years of experience in ETL development, with a strong preference for candidates with experience in the financial services industry.
- 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.
- 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.