Description

Key Responsibilities

• Manage data validation and data extraction from the Department of Public Health’s data collection system.
• Ensure data accuracy, integrity, consistency, and completeness across data systems and submissions.
• Use Python to support data processing, validation, troubleshooting, and application functionality.
• Utilize software applications and databases to visualize, aggregate, and prepare data for internal and external submissions.
• Develop, read, and maintain Windows batch (BAT) files to support data processing and related tasks.
• Use advanced Excel VBA programming for data manipulation, validation, and reporting.
• Troubleshoot programming errors and resolve data processing and application issues.
• Assist users with questions regarding EMResource, data submissions, application functionality, and data transfers.
• Communicate with internal partners and provide clear instructions on application functionality and data validation requirements.
• Provide customer support to end users and help resolve technical issues.
• Explain data validation requirements and the importance of maintaining accurate and reliable data.

Required Qualifications

• Minimum 5 years of experience with data systems, data integrity, and data validation.
• Minimum 5 years of experience with Microsoft Excel VBA, including advanced data manipulation.
• Minimum 5 years of experience in Python programming.
• Minimum 5 years of experience with Microsoft batch scripting and Windows BAT files.
• Minimum 5 years of experience using software applications and databases to visualize and aggregate data for external submissions.
• Minimum 5 years of experience handling numerical data and performing detail-oriented tasks.
• Strong troubleshooting and analytical skills.
• Clear written and verbal communication skills.
• Experience providing customer support and technical assistance to end users.

Core Technical Skills

• Python Programming
• Data Validation and Data Integrity
• Microsoft Excel VBA
• Windows Batch Scripting (BAT Files)
• Data Extraction and Data Processing
• Database Applications and Data Visualization
• EMResource Support
• Data Submission and Transfer
• Application Troubleshooting
• End-User and Customer Supportc

Key Skills

Education

Bachelor's degree