Data Engineer
Denver, CO, United States
Position Description:
The Data Engineer will be responsible for all aspects of data management that support CCMCN’s production services. Candidate must have experience in relational database development (SQL), data integration, ETL (extract, transform and load) tools and methods, analytics, reporting, and documentation. The position will be a team member of a department providing data management, integration, and reporting services for multiple external and internal consumers.
Essential Functions:
· Provide development and maintenance support for data integrations between systems.
· Provide development and maintenance support for the EDW and supporting databases.
· Provide automated solutions whenever possible and proactively suggest alternative solutions.
· Assist in the development of new databases and associated processes as necessary.
· Provide data analytics report development for specific projects as needed.
· Develop data validation reports and analysis where applicable.
· Develop technical documentation of data integrations and processes.
· Communicate and collaborate with other team members and clients to develop innovative data solutions.
· Remain knowledgeable in healthcare data standards, measures and code sets as well as applicable data privacy practices and legal requirements.
Required Skills and Experience:
· Experience working in a SQL environment, especially with data transformation, stored procedures, and query development.
· Experience in Python, JavaScript, and/or C#, and familiarity with REST API connections
· Experience working with a variety of ETL tools
· Knowledge of data warehousing best practices, concepts and processes.
· Knowledgeable in healthcare data standards, measures and code sets as well as applicable data privacy practices and legal requirements.
· Utilize up-to-date knowledge of database content and structure as well as data quality best practices to produce effective solutions.
Additional Preferred Skills:
· Knowledge of healthcare data standards such as HL7, FHIR, CCD, CCR and claims data.
· Knowledge of standard healthcare code sets like LOINC, ICD9/10, CPT4 and SNOMED.
· Strong business and technical writing abilities.
· Experience working in Snowflake Cloud Database
· Knowledge of IHI triple aim, clinical quality improvement, and primary care operations/workflow.
Salary Range: $70,000 - $85,000 annually (DOE)
Benefits: CCMCN provides a generous, comprehensive benefits package that includes:
· Health, dental, and vision insurance plans.
· FSA, DCA, and employer sponsored HRA.
· Life, AD&D, short-term and long-term disability insurance plans.
· 401K retirement plan with employer match.
· Employee Assistance Program (EAP).
· Paid leave including vacation, sick, and holiday, including one floating holiday.
CCMCN is an equal opportunity employer and is committed to a diverse and inclusive work environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
#J-18808-Ljbffr