In this position, the Data Engineer will play a key role in understanding of Data Engineering requirements, design, development of data pipelines and framework using SQL, Python, GCP (Dataflow, Dataproc, BigQuery). This is a technical position providing hands-on delivery role for data analytics projects working with a cross-functional team ensuring excellent delivery relationship.
Job Role
- Work closely with clients, product owners and other stakeholders to understand their information needs and develop technical solutions; liaison between clearing house and other Healthcare EDI partners
- Application administrator for Claims Adjudication System
- Oversee and troubleshoot EDI transaction monitoring and claim related issues
- Provide expert support for EDI related issues, including but not limited to claims, clearinghouse data, demographic interfaces and all transaction code standards.
- Help build and maintain Bi-directional data models to support the infrastructure
- Write complex SQL and stored procedures for analyzing and reporting datasets
- Unit test reports to ensure the highest quality deliverable
- Develop procedures and technical documentation to enhance use of our systems; reporting and query capabilities to improve efficiency and accuracy; document deviations for client set-up
- Develop innovative approaches to manipulate data sets in a way that enables clients to see patterns and trends
- Support, troubleshoot and resolve issues, request and inquiries from end users; Monitor compliance with federal and state guideline addressing issues in a timely manner
- Maintain new code sets and fee schedules
Technical Skills:
- Bachelor’s degree in Computer Science, Bioinformatics or related field
- 6-8 years as a Data Analyst professional
- 5+ years’ experience with reporting tools
- 5+ years’ experience with relational databases (SQL Server, MySQL) to analyze and manage data
- Proven experience programming/implementing projects in existing databases and software products using SQL
- In depth knowledge of claims management, adjudication and pricing methods, required
- Knowledge of security requirements of PHI data would be an added advantage
- Proficiency with compliant HIPAA transaction/code set standards (820,834,835,837,P/I/D), processes and operations development is required
- Experience in designing and managing all EDI transactions Strong knowledge of industry best practices around data architecture in both clouds based and on prem solutions.
- Strong analytical and numerical skills are essential, enabling easy interpretation and analysis of large volumes of data.
- Excellent problem solving and data modelling skills (logical, physical, sematic and integration models) including; normalization, OLAP / OLTP principles and entity relationship analysis
- Experience working in a healthcare environment