Data Engineer Position Summary: As a Data Engineer you will get to play a key and a collaborative role in the delivery of powerful data-driven products that support our mission of providing high-quality and low-cost healthcare to its union members. The Data Engineer will be responsible for providing internal analysts with accurate datasets by implementing best practices in data collection, movement, storage, and transformation of large datasets. This individual will work with both current ETL/Data Warehousing and provide direction for future development of data storage, streaming and pipeline architectures. *We are looking for someone who can build out a data warehouse specific to our client's health funds.? We need someone who has experience working with healthcare data, ideally healthcare claims data. ? Essential Duties and Responsibilities: ? Work with Health Fund analytics, Operations and IT to implement new data infrastructure and migrate existing data from disparate sources into a robust data warehouse ? Using SQL, and other data transformation tools as well as languages such as Python and R, develop automated processes for transforming incoming data from multiple vendors and loading it into a centralized data warehouse for use by Health Fund Operations and Analytics ? Design, build, and manage automated test frameworks and scripts that support a continuous integration/continuous delivery (CI/CD) approach ? Generate subsets of data, and provide APIs and variables needed for interfacing with internal tools as well as public-facing websites ? Working with IT and Operations, to evaluate business cases for use of scalable cloud solutions such as Azure and Dynamics 365 ? Interface with internal teams and vendors? IT to work through data quality issues and champion HIPAA compliant best practices in data handling and transfer ? Create clear documentation (user guides, quick starts, schemas, and data dictionaries) of established data structures and use cases ? Provide tutorials and working sessions to empower analysts in creating queries and accessing right level of data and establish oneself as an expert resource on internal and external data sources and management ? Qualifications: ? Bachelor?s degree in Computer Science or a related discipline; Advanced degree preferred ? 5+ years of full-time experience or demonstrated accomplishments in relevant subject areas ? Prior experience in working with healthcare claims is a must ? Strong knowledge of SQL with hands-on industry experience is a must ? Knowledge of methods for handling non-relational JSON and XML formatted data ? Familiarity with database performance optimization techniques
? Associated topics: data administrator, data architect, data engineer, data integration, data integrity, data manager, data warehouse, erp, mongo database, mongo database administrator
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.