Overview
On Site
Hybrid
BASED ON EXPERIENCE
Full Time
Contract - W2
Contract - Independent
Skills
Data Quality
Data Management
Data Engineering
Data Structure
Reporting
Data Warehouse
Health Care
Database
Systems Engineering
Microsoft SQL Server
Microsoft SSIS
Extract
Transform
Load
Electronic Health Record (EHR)
HL7
IBM Rational
Physical Data Model
Development Testing
Quality Assurance
Data Profiling
SQL
Star Schema
Snow Flake Schema
Transact-SQL
DDL
DML
Stored Procedures
Software Engineering
Software Development Methodology
Version Control
Management
Testing
Technical Writing
Job Details
Title: ETL Architect -W2 Only (Healthcare)
Location: Rancho Cucamonga, CA (Hybrid)
Required Skills:
Location: Rancho Cucamonga, CA (Hybrid)
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:
- Minimum ten (10) years of relevant experience In Data management and governance in Data engineering.
- Three (3) years experience in data systems technical architectures, ETL, data structures, and reporting tools and environments.
- Overall 10+ years industry expereince focusing on Datawarehouse projects using ETL (SSIS)
- Must have exp in healthcare domain and 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,
- Experience in EHR or EMR or FHIR
- Knowledge of HL7
- 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.
Infowave Systems is an equal opportunity employer that is committed to diversity and inclusion in the workplace.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.