Title: Data Architect / ETL Lead

Full time / Perm - Open for H1B Transfer

Must be onsite at Rancho Cucamonga CA from Day 1

Responsibilities:

Data Architect is responsible for the design and development of Data Systems solutions; Design and develop ETL solutions/procedures to acquire, harmonize, and consolidate various data assets/sources;

Create process for automation and enhancement of data quality.

Required Skills:

• Three (3) years’ experience in data systems technical architectures, ETL, data structures, and reporting tools and environments. 
• Expertise in healthcare systems and healthcare databases.
• 7 years’ experience performing data systems development, modification, and support.
• 7 years with SQL Server, SSIS, ETL, SQL,
• Must have hands on experience in
• Logical, rational, dimensional, and physical data modeling. 
• Code development, testing for QA, and data profiling.
• Perform SQL queries tuning activities. 
•  Normalized, dimensional, star schema and snow flake schematic models.
• Developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications
• Software engineering practices and best practices for the full SDLC, including coding standards, code reviews, source control management, build processes, testing, and operations. 
• Strong technical documentation skills.