Data Engineer & Data Architect - Google Cloud Platform / AWS / ETL / SQL / NLP / Data Warehouse

SHIRO Technologies LLC; Plano (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

SHIRO Technologies LLC is seeking experienced Data Engineers, Data Architects, and ETL Testing professionals to design, develop, and maintain enterprise data platforms, data pipelines, and data warehouse solutions for healthcare analytics and conversational AI applications.

Ideal candidates will have cloud data engineering, ETL/ELT development, SQL, data modeling, data validation, and knowledge pipeline experience, with hands-on work in Google Cloud Platform and AWS, NLP, and conversational AI

Qualifications

• Experience in designing and maintaining enterprise data platforms.
• Experience with cloud-based data architectures and pipelines.
• Strong SQL skills and data modeling capabilities.
• Knowledge of HIPAA-compliant healthcare data handling is a plus.
• Experience with NLP and conversational AI data workflows is desirable.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Build cloud-based data solutions on GCP and AWS.
• Develop data models using Star and Snowflake schemas.
• Design data warehouse architecture and data integration strategies.
• Define traditional and cloud-based ETL processes.
• Develop and optimize SQL queries and data transformations.
• Build data pipelines supporting conversational AI applications.
• Prepare and optimize datasets for NLP use cases.
• Support NLP data activities and conversation design operations.
• Design and execute ETL testing strategies and test cases.
• Automate data validation and perform source-to-target testing.
• Validate data accuracy, completeness, and transformation rules.
• Identify and troubleshoot data quality and pipeline issues.
• Perform data platform performance tuning and optimization.
• Collaborate with AI/ML, data science, QA, and business teams.

Skills

Data Engineering

Data Architecture

ETL/ELT development

Cloud data engineering

SQL

Data modeling

Data warehouse

ETL testing

Python programming

NLP data processing

Conversational AI data engineering

Knowledge pipeline engineering

Tools

MongoDB

Cassandra

Job description

We are seeking experienced Data Engineers, Data Architects, and ETL Testing professionals to design, develop, and maintain enterprise data platforms, data pipelines, and data warehouse solutions supporting healthcare analytics, reporting, and conversational AI applications.

The ideal candidates will have experience in cloud data engineering, data architecture, ETL/ELT development, SQL, data modeling, data validation, and knowledge pipeline engineering. Experience with Google Cloud Platform, AWS, NLP, and conversational AI data solutions is highly desirable.

Candidates will collaborate with data engineering, AI/ML, analytics, and business teams to deliver scalable, secure, and high-quality healthcare data solutions.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Build cloud-based data engineering solutions using Google Cloud Platform and AWS.
• Develop and maintain data models using Star and Snowflake schemas.
• Design enterprise data warehouse architecture and data integration strategies.
• Define and implement traditional and cloud-based ETL processes.
• Develop and optimize SQL queries and data transformation workflows.
• Build data and knowledge pipelines supporting conversational AI applications.
• Prepare, transform, and optimize datasets for NLP and conversational AI use cases.
• Support conversation design operations and applied NLP data activities.
• Design and execute ETL testing strategies and test cases.
• Automate data validation and perform source-to-target testing.
• Validate data accuracy, completeness, consistency, and transformation rules.
• Identify and troubleshoot data quality and pipeline issues.
• Perform data platform performance tuning and optimization.
• Collaborate with AI/ML, data science, QA, and business teams.

Required Technical Skills

• Data Engineering and Data Architecture.
• ETL/ELT development and data integration.
• Cloud data engineering – Google Cloud Platform and/or AWS.
• Advanced SQL and ANSI SQL.
• Data modeling, including Star and Snowflake schemas.
• Data warehouse architecture and development.
• Traditional and cloud-based ETL tools.
• MongoDB and Cassandra.
• Python programming and data processing.
• ETL testing and data validation.
• Test automation and scripting.
• Knowledge pipeline engineering.
• Applied NLP data processing.
• Conversational AI data engineering and conversation design operations.

Preferred Qualifications

• Experience designing and supporting enterprise-scale data platforms.
• Experience with healthcare analytics and reporting solutions.
• Knowledge of conversational AI and NLP data workflows.
• Experience with data quality frameworks and automated testing.
• Knowledge of CI/CD practices for data platforms.
• Strong problem-solving and communication skills.

Experience Working In Healthcare Or Other Regulated Environments.

• Working knowledge of HIPAA and PHI data handling.

Healthcare Domain Requirements

• Understanding of healthcare data and reporting processes.
• Knowledge of HIPAA compliance requirements.
• Experience handling Protected Health Information (PHI) securely.

Additional Information

This is an onshore healthcare technology opportunity in the United States. Candidates should have relevant hands-on experience in one or more of the above data engineering, data architecture, conversational data, or ETL testing technology areas.

Work Authorization

Must be legally authorized to work in the US. H-1B transfers supported for qualified candidates. All applicants considered without regard to citizenship status or national origin.

Equal opportunity employer.