AP
Junior Data Scientist
Atlantic Partners Corporation
Location not stated
Junior
1 month ago
- Excel
- Power BI
- Smartsheet
- Tableau
- Salesforce
- SQL
- Jira
- Asana
1 month ago
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: 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
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
- 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
- Build and enhance dashboards in Power BI, Excel, or Tableau
- Support data visualizations for operational and quality improvement initiatives
- Document operational workflows, steps, and procedures
- Draft and maintain SOPs for related efforts
- Support process standardization and documentation across systems
Junior Data Scientist · Atlantic Partners Corporation