Roth Staffing is looking for Data Architect III for the client (life insurance company). This is an exciting opportunity to work for a global leader in life insurance company with a strong corporate culture and competitive pay.

JOB DESCRIPTION

* Responsible to plan, design, develop and maintain the data architecture, data models and standards for various Data Engineering projects.

* Ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view.

* Develop and maintain documentation of the data architecture, data flows and data models of the data warehouse appropriate for various audiences.

* Provide direction on adoption of Cloud technologies (AWS, Snowflake etc.) and industry best practices in the field of data warehouse architecture and modeling.

FACTORS FOR SUCCESS /Qualifications

* Bachelor's degree in Information technology or related field, with a Master's degree in Computer science or data science preferred

* 10 years of experience in end-to-end data modeling, designing and building multi-dimensional enterprise data warehouses using Snowflake, Oracle or similar platforms

* Excellent communication, technical documentation and collaboration skills

* Strong experience using data modeling tools, such as Erwin or ER/Studio

* Strong SQL skills and knowledge of database objects such as stored procedures, materialized views, synonyms, and indexes

* Experience working with multiple databases such as Oracle, SQL Server, DB2, and/or MySQL

* Experience working with AWS technologies (S3, Redshift, Glue, Athena, Spectrum) and Snowflake is strongly preferred

* Experience with dbt, Matillion, Control M, is a plus

* Experience in the domain of financial services preferred

Must Have

* An enterprise data architect

* Data Modeling skills

* Hands on work experience with Snowflake

* SQL

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.