Senior Data Engineer

US Citizens or Green Cards only please

No 3rd parties please

w2 employment only

PSR Associates is immediately seeking a Senior Data Engineer to join our team providing support to our client.

Client: State of Michigan

Term: 1 year+

Work Environment: Hybrid; 2 days onsite in Lansing, MI

Job 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 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 provide technical oversight to other developers in the team that support other critical applications.

• 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.
• Develop database objects including stored procedures, functions,
• Execute full software development life cycle (SDLC) including experience in gathering requirements and writing functional/technical specifications for complex projects.
• Develop software design documents and work with stakeholders for review and approval.

• 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
• Experience with Databricks, Elastic search, Kibanna, S3.
• Experience with Extract, Transform, and Load (ETL) processes and data pipelines.
• Experience with AWS Cloud-based Application Development
• Experience in Electronic Health Records (EHR) HL7 solutions.
• Experience with data warehousing, data visualization Tools, data integrity
• Excellent knowledge in designing both logical and physical database model
• Extensive knowledge on source control tools such as GIT
• 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