| Daily Duties / Responsibilities: The candidate will work closely with members of the Systems Integration, Health Data Visualizations, and Database Administration teams as well as STD / HIV program staff. The candidate should be self-motivated and team-oriented, work under limited supervision, and respond to priority tasks. The candidate must be able to independently research and design processes, create specifications and data flows, develop ETL processes, make stored procedures, advanced queries, and reports, assist with validations, actively engage with the Team and stakeholders, attend meetings, provide guidance, and respond promptly. Participate in a team comprised of DPH and solution implementation staff providing STD HIV system and data migration support, data pipeline improvement and monitoring, data warehousing and reporting. New solutions for eCR onboarding, import and utilization will be included. Work can consist of planning, design, configuration, process development, SSIS and script coding, and automation of data flows. Will coordinate with the assigned IT Section Manager and Team Lead on daily assignments/tasks. Will coordinate and collaborate with contract and vendor staff, existing DPH staff, and other I. T. professionals working with the Office of Information Technology. Ensure assignments are completed accurately and on time, assist with problem resolution, mitigate issues, provide solutions, communicate, and escalate as needed to management, and report progress to the manager. Will advise staff on code conversions, database and query design, optimization, process improvements and automation, validations, reporting, and report creation. Work with vendors and staff on deliverables, debugging, and converting current processes to SSIS and PowerBI. This includes rewriting existing SAS solutions to conform to best practices and updated coding standards and improving efficiency, performance, and maintenance. Specific duties and responsibilities will include but are not limited to the following: - Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existing).
- Work with end users to perform gap analysis, gather and document functional requirements, and create necessary processes
- Assist with project and time management including estimates and status reporting
- Ability to plan, organize, review, and implement associated project milestones to completion.
- Process Development, Process Automation, and ETL Solutions
|
Never miss an opportunity! Create an alert based on the job you applied for.
