Programmer Analyst 6 - Data Engineer

Codetech•Lansing, MI

About The Position

Provide ongoing maintenance, support, modernization, and enhancement of the Michigan Disease Surveillance System (MDSS), a complex application supporting communicable disease surveillance, registries, and case management. The system supports public health emergency response and efforts to reduce communicable diseases. The position supports MDSS modernization following completion of phase 1, including reliable automated processes, streamlined business processes, data integrity, SEM/SUITE compliance, and application security. Serve as a technical lead, provide technical guidance and oversight to developers, and participate in analytical assignments involving the enhancement, integration, maintenance, and implementation of projects. The role also provides technical oversight to developers supporting other critical applications. The posting notes that inadequate staffing could result in failures to maintain or support MDSS, application outages, data integrity issues, and incorrect processing or reporting of patient information. Lead the design and development of scalable, high-performance solutions using AWS. Work with Databricks, Elasticsearch, Kibana, S3, ETL processes, data pipelines, Python/Scala, Oracle, and electronic health record (EHR) HL7 solutions. Responsibilities also include database design and development, software lifecycle work, technical documentation, source control, and CI/CD pipelines.

Requirements

At least 12 years developing complex database systems.
At least 8 years of Databricks experience.
At least 8 years using Elasticsearch and Kibana.
At least 8 years using Python and/or Scala.
At least 8 years of Oracle experience.
At least 5 years of experience with ETL processes and developing data pipelines.
At least 5 years of AWS experience.
More than 5 years of experience with data warehousing, data visualization tools, and data integrity.
More than 5 years using CMM/CMMI Level 3 methods and practices.
More than 5 years implementing agile development processes, including test-driven development.
Experience with AWS cloud-based application development.
Experience with electronic health records (EHR) HL7 solutions.
Extensive knowledge of source control tools such as Git.
Experience working on large agile projects.
Excellent knowledge of logical and physical database modeling.
Ability to gather requirements and write functional and technical specifications for complex projects.

Nice To Haves

More than 3 years of experience or knowledge creating CI/CD pipelines using Azure DevOps.

Responsibilities

Maintain, support, modernize, and enhance the Michigan Disease Surveillance System (MDSS).
Ensure automated processes function properly and streamline critical business processes.
Support data integrity, SEM/SUITE compliance, and application security.
Lead the design and development of scalable, high-performance solutions using AWS services.
Develop ETL processes and data pipelines.
Write clean, maintainable, and efficient code in Python and/or Scala.
Implement and manage Elasticsearch for efficient data retrieval and analysis.
Execute the full software development life cycle, including requirements gathering and preparation of functional and technical specifications for complex projects.
Design logical and physical database models and develop database objects, including stored procedures and functions.
Develop software design documents and work with stakeholders to review and approve them.
Provide technical leadership, guidance, and oversight to other developers, including developers supporting other critical applications.
Participate in analytical assignments for project enhancement, integration, maintenance, and implementation.
Use flowcharts, screen layouts, and documentation to ensure the logical flow of system requirements.