Job Information
COOLSOFT ETL Python AWS Data Warehouse Analyst in Lansing, Michigan
ETL Python AWS Data Warehouse Analyst
(Jobs in Lansing, MI)
Requirement id 157409
Job title Analyst
Job location in Lansing, MI
Skills required Database Systems, Data Bricks, ETL, Python AWS Data Warehouse
Open Date 09-Mar-2026
Close Date
Job type Contract
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
Email Recruiter:coolsoft
Job Description Analyst: Database Systems, Data Bricks, ETL, Python AWS Data Warehouse
Start date : 03/30/2026
End Date : 1 Years from projected start date
Submission deadline : 3/16/2026 10:00:00 AM
Client Info : DHHS
Note:
Interview Process: Candidates submitted must be willing to come ONSITE (Lansing, MI) for interviews.
On-site: Hybrid position - Onsite 2 days per week - REQUIRED. Open to candidates local and nonlocal willing to relocate. NO REMOTE ONLY OPTION.
Duration: 1 year with possible extension.
Description :
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 client MDSS phase 1. Making sure automated processes are funtioning,
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 Client 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.
•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
•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 developm
Call502-379-4456 Ext 100for more details. Please provide Requirement id: 157409 while calling.
EOE Protected Veterans/Disability