Junior Data Scientist (26-00204) -

Primary Purpose of the Position

The Junior Data Scientist supports operational, analytical, and quality improvement initiatives. Responsibilities include cleaning, validating, transforming, and summarizing data; monitoring automated workflows; troubleshooting pipeline issues; merging complex files; and contributing to dashboards, automations, and integrated reporting processes. The Junior Data Scientist will also support KPI initiatives and report development such as dashboards for executive and operations reporting. This role will also support recurring monthly reporting systems documentation efforts, and development of standard operating procedures.

Knowledge, Skills, and Abilities

• Data Tools: Strong Excel skills; ability to write formulas and merge complex data sets; familiarity with Power BI, Smartsheet, Tableau, and Salesforce reporting tools, familiarity with basic SQL queries
• Productivity & Project Tools: Basic familiarity with Jira and Asana
• Growth Mindset: Curious, proactive, and effective at problem solving

Education and Experience Required

Education

Bachelor's in Health Informatics, Statistics, Data Science, or related field

Experience (Junior Level)

• Experience working with operational and health care data in academic projects, internships, or professional roles
• Experience cleaning data, merging files, and preparing structured datasets
• Familiarity with Salesforce for pulling reports, reviewing data fields, or supporting basic operational workflows
• Experience documenting processes or workflows in SOPs
• Basic understanding of SQL for simple querying, filtering, and data extraction
• Experience supporting recurring reporting tasks or monthly data cycles
• Exposure or experience in dashboard creation using Power BI, Smartsheet and/or Tableau

License or Certification Required

None

Description of Work

Data Quality & Validation (30%)

• Run data validation checks to ensure accuracy and completeness
• Identify quality issues and coordinate data corrections
• Document data definitions, rules, and standards
• Monitor automated workflows and refresh processes
• Troubleshoot issues in data pipelines and integrations
• Conduct Jira clean-up activities based on documented guidance

Operational Data Support (30%)

• Support the Medicaid and State Health Plan Reconciliation Project by cleaning, merging, and standardizing complex monthly data files
• Support the review and update of monthly operational metrics
• Establish and maintain a recurring monthly processing and reporting systems
• Assist with automating merges, refreshes, and repeatable processes using Excel, Power BI, and other tools

Dashboard & Visualization Development (20%)

• Build and enhance dashboards in Power BI, Excel, or Tableau
• Support data visualizations for operational and quality improvement initiatives

Process Documentation & SOP Development (20%)

• Document operational workflows, steps, and procedures
• Draft and maintain SOPs for related efforts
• Support process standardization and documentation across systems