Apex Health Solutions
Data Engineer
Apex Health Solutions, Houston, Texas, United States, 77246
Description
Summary:
The Data Engineer will support the implementation of projects focused on collecting, aggregating, storing, reconciling, and making data accessible from disparate sources to enable analysis and decision-making. In this role, the Data Engineer will play a critical role in connecting our partners and enabling our critical solutions using actionable data and empowering processes through harmonized data across the entire spectrum from care provision, claim payment, and process visibility. Join our fast-paced, experienced team of healthcare leaders and re-shape healthcare.
Essential Duties and Responsibilities:
Translate business requirements into technical solutions leveraging strong business acumen. Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows. Analyze current business practices, processes, and procedures, identifying future business opportunities for leveraging Microsoft Azure Data & Analytics PaaS Services. Support the planning and implementation of data design services, providing sizing and configuration assistance, and performing needs assessments. Deliver architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies. Design and build modern data pipelines, data streams, and system integrations using Azure Data Factory. Create procedures and code to facilitate the movement of data to and from files and formats using ETL/ELT processes. Ensure code can be deployed using Azure DevOps. Design and build data service APIs. Manage data processing jobs and routines within an Azure/SQL Server environment. Develop and maintain data warehouse schematics, layouts, architectures, and relational/non-relational databases for data access and advanced analytics. Support and research issues across all application layers and databases. Expose data to end users using Power BI. Implement effective metrics and monitoring processes. Identify patterns and trends in data to provide actionable insights. Write and optimize stored procedures for performance and scalability. Education/Experience
Bachelor of Computer Science, MIS or equivalent degree. 3+ years of experience implementing data pipelines and cloud data transformation processes using the latest technologies and techniques, including Azure Data Factory, Event Hub, Azure DevOps, Databricks, Azure Storage/Data Lake, and Azure SQL Database. Strong proficiency in relational databases and scripting languages (T-SQL, Python) with experience in Azure SQL DW. Experience in data modeling and advanced SQL techniques. Knowledge in database management, such as performance tuning of the Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments, and support the integration of those systems with other applications. Knowledge of emerging healthcare data and security standards, such as FHIR and HIPAA. Familiarity with HL7 or other healthcare-related EDI protocols and both clinical and administrative healthcare data sources. Experience working in an environment using Agile/SCRUM methodologies and principles. Excellent problem-solving, analytical, and critical thinking skills. Familiarity with working in a regulated industry, preferably in healthcare. Microsoft Azure certifications are a plus.
About Apex Health Solutions
Apex Health Solutions powers payers and providers choosing to engage in value-based risk contracting. Apex's unique solutions create alignment between payers and providers, generating unparalleled value. Combined with Apex's experienced and successful industry leadership, our focal point remains on improvement in patient quality, satisfaction and overall cost of care.
Summary:
The Data Engineer will support the implementation of projects focused on collecting, aggregating, storing, reconciling, and making data accessible from disparate sources to enable analysis and decision-making. In this role, the Data Engineer will play a critical role in connecting our partners and enabling our critical solutions using actionable data and empowering processes through harmonized data across the entire spectrum from care provision, claim payment, and process visibility. Join our fast-paced, experienced team of healthcare leaders and re-shape healthcare.
Essential Duties and Responsibilities:
Translate business requirements into technical solutions leveraging strong business acumen. Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows. Analyze current business practices, processes, and procedures, identifying future business opportunities for leveraging Microsoft Azure Data & Analytics PaaS Services. Support the planning and implementation of data design services, providing sizing and configuration assistance, and performing needs assessments. Deliver architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies. Design and build modern data pipelines, data streams, and system integrations using Azure Data Factory. Create procedures and code to facilitate the movement of data to and from files and formats using ETL/ELT processes. Ensure code can be deployed using Azure DevOps. Design and build data service APIs. Manage data processing jobs and routines within an Azure/SQL Server environment. Develop and maintain data warehouse schematics, layouts, architectures, and relational/non-relational databases for data access and advanced analytics. Support and research issues across all application layers and databases. Expose data to end users using Power BI. Implement effective metrics and monitoring processes. Identify patterns and trends in data to provide actionable insights. Write and optimize stored procedures for performance and scalability. Education/Experience
Bachelor of Computer Science, MIS or equivalent degree. 3+ years of experience implementing data pipelines and cloud data transformation processes using the latest technologies and techniques, including Azure Data Factory, Event Hub, Azure DevOps, Databricks, Azure Storage/Data Lake, and Azure SQL Database. Strong proficiency in relational databases and scripting languages (T-SQL, Python) with experience in Azure SQL DW. Experience in data modeling and advanced SQL techniques. Knowledge in database management, such as performance tuning of the Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments, and support the integration of those systems with other applications. Knowledge of emerging healthcare data and security standards, such as FHIR and HIPAA. Familiarity with HL7 or other healthcare-related EDI protocols and both clinical and administrative healthcare data sources. Experience working in an environment using Agile/SCRUM methodologies and principles. Excellent problem-solving, analytical, and critical thinking skills. Familiarity with working in a regulated industry, preferably in healthcare. Microsoft Azure certifications are a plus.
About Apex Health Solutions
Apex Health Solutions powers payers and providers choosing to engage in value-based risk contracting. Apex's unique solutions create alignment between payers and providers, generating unparalleled value. Combined with Apex's experienced and successful industry leadership, our focal point remains on improvement in patient quality, satisfaction and overall cost of care.