| Data Warehouse Architect Engineer at Remote, Remote, USA |
| Email: [email protected] |
|
From: Kartik, tek inspiration [email protected] Reply to: [email protected] Job Description - immediate interview for suitable profile Data Warehouse Architect/Engineer Gilbert, TX, Fully Remote Exp: 12+ years or Architect level Candidate with Healthcare industry experience required. with very strong DBT(Data Build tool) experience. Healthcare client exp is mandatory. Expert exp with: DBT, healthcare, data warehouse architecture, hands on experience working with CTO (Chief Technology Officer), redshift is a plus. Job Description Overview This role will work closely with the Business Intelligence team and stakeholders across the organization to design and optimize data infrastructure, ensuring efficient ETL processes and high-quality data integration. Key Responsibilities Design, develop, and maintain a scalable and reliable data warehouse architecture. Collaborate with business intelligence analysts, data scientists, and stakeholders to translate data requirements into optimized data models. Develop and manage ETL workflows to integrate healthcare data from EHR, EMR, claims data, and patient records into the data warehouse. Implement data quality controls to ensure accuracy, completeness, and consistency. Optimize data warehouse performance, improving query efficiency, latency, and scalability. Build and monitor automated systems for ingesting healthcare member, claims, and quality data. Integrate healthcare data sources while ensuring compliance with industry standards (HL7, FHIR, ICD-10, CPT). Conduct data analysis to identify and resolve data issues, ensuring clean and structured datasets. Maintain organized database structures to optimize storage, performance, and historical tracking. Perform additional duties as needed to support the organization's data infrastructure. Required Skills & Qualifications Bachelors degree in Computer Science or related field (or equivalent experience). 10+ years of experience supporting Cloud Data Warehouse environments (Snowflake, Google BigQuery, Azure Synapse, AWS Redshift preferred). 5+ years of experience working with healthcare industry data and standards (HL7, FHIR, ICD-10, CPT). Expertise in ETL processes, data integration, and data transformation using dbt. Strong knowledge of dimensional data modeling and data warehouse design principles. Advanced SQL skills with experience managing large datasets across multiple database systems. Excellent leadership, communication, and problem-solving skills, with the ability to work collaboratively in a fast-paced environment. Proficiency in Microsoft Suite, Adobe Suite, and Agile Project Management tools. Preferred Skills & Qualifications Experience with Azure DevOps, Jira, TFS, or similar Agile tools. Familiarity with AWS ETL tools (AWS Glue, Data Brew). Knowledge of business analytics and reporting tools (Tableau, Power BI, Looker). Keywords: business intelligence Texas Data Warehouse Architect Engineer [email protected] |
| [email protected] View All |
| 05:08 AM 11-Mar-25 |