
Programmer Analyst 6 - Data Engineer
Role: Programmer Analyst 6 - Data Engineer
Location: Lansing, MI Hybrid
Duration: 12 Months
Interview: Phone/Skype/F2F
Top Skills & Years of Experience:
12+ years developing complex database systems.
8+ years Databricks.
8+ years using Elastic search, Kibanna.
8+ years using Python/Scala.
8+ years Oracle.
5+ years' experience with Extract, Transform, and Load (ETL) processes and developing Data Pipelines.
5+ years' experience with AWS.
5+ years' experience with data warehousing, data visualization Tools, data integrity.
5+ years using CMM/CMMI Level 3 methods and practices.
5+ years implemented agile development processes including test driven development.
Interview Process: Candidates submitted must be willing to come onsite (Lansing, MI) for interviews. Manager may request virtual and/or onsite interviews. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of any MS Teams interview to validate candidate.
On-site: Hybrid position - Onsite 2 days per week - REQUIRED. CANDIDATES MUST BE LOCAL TO MID-MICHIGAN. Hiring manager is not currently interested in candidates who will need to relocate to accept offer. NO REMOTE ONLY OPTION.
Duration: 1 year with possible extension.
Position Justification (Why this resource is being procured and which Agency applications/projects/other areas this resource will be working on):
The position is responsible for providing ongoing maintenance and support of the Michigan Disease Surveillance System (MDSS). MDSS is a complex application that supports communicable disease surveillance, registries, and case management systems that are critical to supporting effective responses to public health emergencies and reducing the burden of communicable diseases. MDSS is going through modernization to enhance stability and functionality of the system. With phase 1 already completed. The resource is integral to developing and maintaining and enhancing Agency's MDSS phase 1. Making sure automated processes are functioning, streamlining critical business processes, data integrity, SEM/SUITE compliance, and securing the application. The resource also performs as a technical lead and provides technical guidance to the other developers in the department. As a technical lead, the resource participates in a variety of analytical assignments that provide for the enhancement, integration, maintenance, and implementation of projects. The resource will also provides technical oversight to other developers in the team that support other critical applications . Not having a resource on staff will lead to MDHSS failing to maintain, enhance, and support the modernized MDSS that can lead to errors causing application outages, data integrity issues and can eventually lead to incorrect information being processed and reporting of the patient information.
Position Summary (Detail Position Summary in Bullet Point or Descriptive Statement):
Lead the design and development of scalable and high-performance solutions using AWS services.
Experience with Databricks, Elastic search, Kibanna, S3.
Experience with Extract, Transform, and Load (ETL) processes and data pipelines.
Write clean, maintainable, and efficient code in Python/Scala.
Experience with AWS Cloud-based Application Development
Experience in Electronic Health Records (EHR) HL7 solutions.
Implement and manage Elastic Search engine for efficient data retrieval and analysis.
Experience with data warehousing, data visualization Tools, data integrity
Execute full software development life cycle (SDLC) including experience in gathering requirements and writing functional/technical specifications for complex projects.
Excellent knowledge in designing both logical and physical database model
Develop database objects including stored procedures, functions,
Extensive knowledge on source control tools such as GIT
Develop software design documents and work with stakeholders for review and approval.
Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirements
Experience working on large agile projects.
Experience or Knowledge on creating CI/CD pipelines using Azure Devops
Skill Descriptions (8-10 or more Required/Desired/Nice to Have skills in Bullet Points identified by their ranking):
12+ years developing complex database systems.
8+ years Databricks.
8+ years using Elastic search, Kibanna.
8+ years using Python/Scala.
8+ years Oracle.
5+ years' experience with Extract, Transform, and Load (ETL) processes and developing Data Pipelines.
5+ years' experience with AWS.
Over 5+ years' experience with data warehousing, data visualization Tools, data integrity .
Over 5+ years using CMM/CMMI Level 3 methods and practices.
Over 5+ years implemented agile development processes including test driven development.
Over 3+ years' Experience or Knowledge on creating CI/CD pipelines using Azure Devops- Nice to have
Role: Programmer Analyst 6 - Data Engineer
Location: Lansing, MI Hybrid
Duration: 12 Months
Interview: Phone/Skype/F2F
Top Skills & Years of Experience:
12+ years developing complex database systems.
8+ years Databricks.
8+ years using Elastic search, Kibanna.
8+ years using Python/Scala.
8+ years Oracle.
5+ years' experience with Extract, Transform, and Load (ETL) processes and developing Data Pipelines.
5+ years' experience with AWS.
5+ years' experience with data warehousing, data visualization Tools, data integrity.
5+ years using CMM/CMMI Level 3 methods and practices.
5+ years implemented agile development processes including test driven development.
Interview Process: Candidates submitted must be willing to come onsite (Lansing, MI) for interviews. Manager may request virtual and/or onsite interviews. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of any MS Teams interview to validate candidate.
On-site: Hybrid position - Onsite 2 days per week - REQUIRED. CANDIDATES MUST BE LOCAL TO MID-MICHIGAN. Hiring manager is not currently interested in candidates who will need to relocate to accept offer. NO REMOTE ONLY OPTION.
Duration: 1 year with possible extension.
Position Justification (Why this resource is being procured and which Agency applications/projects/other areas this resource will be working on):
The position is responsible for providing ongoing maintenance and support of the Michigan Disease Surveillance System (MDSS). MDSS is a complex application that supports communicable disease surveillance, registries, and case management systems that are critical to supporting effective responses to public health emergencies and reducing the burden of communicable diseases. MDSS is going through modernization to enhance stability and functionality of the system. With phase 1 already completed. The resource is integral to developing and maintaining and enhancing Agency's MDSS phase 1. Making sure automated processes are functioning, streamlining critical business processes, data integrity, SEM/SUITE compliance, and securing the application. The resource also performs as a technical lead and provides technical guidance to the other developers in the department. As a technical lead, the resource participates in a variety of analytical assignments that provide for the enhancement, integration, maintenance, and implementation of projects. The resource will also provides technical oversight to other developers in the team that support other critical applications . Not having a resource on staff will lead to MDHSS failing to maintain, enhance, and support the modernized MDSS that can lead to errors causing application outages, data integrity issues and can eventually lead to incorrect information being processed and reporting of the patient information.
Position Summary (Detail Position Summary in Bullet Point or Descriptive Statement):
Lead the design and development of scalable and high-performance solutions using AWS services.
Experience with Databricks, Elastic search, Kibanna, S3.
Experience with Extract, Transform, and Load (ETL) processes and data pipelines.
Write clean, maintainable, and efficient code in Python/Scala.
Experience with AWS Cloud-based Application Development
Experience in Electronic Health Records (EHR) HL7 solutions.
Implement and manage Elastic Search engine for efficient data retrieval and analysis.
Experience with data warehousing, data visualization Tools, data integrity
Execute full software development life cycle (SDLC) including experience in gathering requirements and writing functional/technical specifications for complex projects.
Excellent knowledge in designing both logical and physical database model
Develop database objects including stored procedures, functions,
Extensive knowledge on source control tools such as GIT
Develop software design documents and work with stakeholders for review and approval.
Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirements
Experience working on large agile projects.
Experience or Knowledge on creating CI/CD pipelines using Azure Devops
Skill Descriptions (8-10 or more Required/Desired/Nice to Have skills in Bullet Points identified by their ranking):
12+ years developing complex database systems.
8+ years Databricks.
8+ years using Elastic search, Kibanna.
8+ years using Python/Scala.
8+ years Oracle.
5+ years' experience with Extract, Transform, and Load (ETL) processes and developing Data Pipelines.
5+ years' experience with AWS.
Over 5+ years' experience with data warehousing, data visualization Tools, data integrity .
Over 5+ years using CMM/CMMI Level 3 methods and practices.
Over 5+ years implemented agile development processes including test driven development.
Over 3+ years' Experience or Knowledge on creating CI/CD pipelines using Azure Devops- Nice to have