Data Engineer

Position Summary: Apex Health Solutions is leading a healthcare transformation through our partnerships with physicians and healthcare insurers.
Through our unique models, Apex empowers physicians to truly manage a patient’s health, delivering high quality, affordable care in a modern, patient focused approach.
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 through use of 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 to 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 as well as 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.
Delivery of architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies.
Design and build modern data pipelines, data streams, and system integration.
Creation of 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.
Ongoing management of 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 database.
Expose data to end users using PowerBI.
Implement effective metrics and monitoring processes.
Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
The requirements listed below are representative of the knowledge, skill, and/or ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
In addition to the qualifications below, the qualified candidate must have: Strong relational database and scripting languages (T-SQL, Python) with experience in Azure SQL DW.
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 data 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.
Excellent problem solving, analytical, and critical thinking skills.
Familiarity with working in a regulated industry, preferably in health care.
Microsoft Azure certifications are a plus.
Competencies: To perform the job successfully, an individual should demonstrate the following: Adaptability - Adapts to changes in the work environment.
Manages competing demands.
Accepts criticism and feedback.
Changes approach or method to best fit the situation.
Communication - Expresses ideas and thoughts verbally.
Expresses ideas and thoughts in written form.
Exhibits good listening and comprehension.
Keeps others adequately informed.
Selects and uses appropriate communication methods.
Dependability - Responds to requests for service and assistance.
Follows instructions, responds to management direction.
Takes responsibility for own actions.
Commits to doing the best job possible.
Keeps commitments.
Meets attendance and punctuality guidelines.
Quality - Demonstrates accuracy and thoroughness.
Displays commitment to excellence.
Looks for ways to improve and promote quality.
Applies feedback to improve performance.
Monitors own work to ensure quality.
Quantity - Meets productivity standards.
Completes work in timely manner.
Strives to increase productivity.
Works quickly.
Achieves established goals.
Teamwork - Balances team and individual responsibilities.
Exhibits objectivity and openness to others' views.
Gives and welcomes feedback.
Contributes to building a positive team spirit.
Puts success of team above own interests.
Education/Experience: Bachelor of Computer Science, MIS or equivalent degree.
3+ years of experience implementing data pipelines and cloud data transformation processes using latest technologies and techniques, including Azure Data Factory, Event Hub, Azure Devops, Databricks, Azure Storage/Data Lake, Azure SQL Database.
Experience in data modeling and advanced SQL techniques.
Experience working in an environment using Agile/SCRUM methodologies and principles.
Certificates and Licenses: None Supervisory Responsibilities: None Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is usually quiet.
Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear.
The employee is occasionally required to stand and walk.