Data Engineer

Title: Programmer Analyst VI – Senior Lead Developer, Data Engineer Location: Lansing, MI (Hybrid) Note: This is a W2 contract role – C2C, 1099, & 3 rd party candidates WILL NOT be considered This position is responsible for providing ongoing maintenance and support for a system currently going through modernization to enhance stability and functionality of the system, with phase 1 already completed. The resource in this role will be integral to developing, maintaining, and enhancing phase 1, making sure automated processes are functioning, streamlining critical business processes, data integrity, compliance, and securing the application. This resource will also perform as a technical lead, providing technical guidance to the other developers in the department. As a technical lead, the resource will participate in a variety of analytical assignments that provide for the enhancement, integration, maintenance, and implementation of projects. The resource will also provide technical oversight to other developers in the team that support other critical applications. Job Duties: · Lead the design and development of scalable and high-performance solutions using AWS services · Write clean, maintainable, and efficient code in Python/Scala · Implement and manage Elastic Search engine for efficient data retrieval and analysis · Execute full Software Development Lifecycle (SDLC), including gathering requirements and writing functional/technical specifications for complex projects · Develop database objects including stored procedures and functions · Develop software design documents and work with stakeholders for review and approval Job Qualifications: · 12+ years of experience developing complex database systems · 8+ years of experience with Databricks · 8+ years of experience using Elastic Search, Kibanna, and S3 · 8+ years of experience using Python/Scala · 8+ years of experience in Oracle · 5+ years of experience with Extract, Transform, and Load (ETL) processes, and developing data pipelines · 5+ years of experience with AWS Cloud-based Application Development · 5+ years of experience in data warehousing, data visualization tools, and data integrity · 5+ years of experience using CMM/CMMI Level 3 methods and practices · 5+ years of experience implementing Agile development processes, including test driven development · 3+ years of experience creating CI/CD pipelines using Azure DevOps · Experience with Electronic Health Record (EHR) HL7 solutions · Experience with data warehousing, data visualization tools, and data integrity, and designing both logical and physical database models · Extensive knowledge in source control tools, such as GIT · Exposure to flowcharts, screen layouts, and documentation to ensure logical flow of the system requirements · A minimum of a Bachelor’s Degree in a relevant field