Job description

Job Title: Data Scientist (Locations available in: Warminster, PA, Hilliard, OH, Plymouth, MI, and Burnsville, MN) Department: Finance Accountability: This Position Reports to the Senior Manager, Financial Planning & Analytics We are building a next-generation analytics capability at the intersection of data, finance, operations, and strategy. The Data Scientist will support this effort by developing practical, scalable analytics, machine learning, and AI-enabled solutions that improve decision-making, strengthen reporting accuracy, and enhance business performance. This role combines data engineering, database design, statistical modeling, business intelligence, and process improvement to transform complex structured and unstructured data into timely, meaningful insights. Working closely with Finance, Operations, IT, and other business stakeholders, the Data Scientist will gather requirements, define analytical approaches, build and validate models, automate data workflows, and deliver reporting tools that support efficient and effective business operations. This is an excellent opportunity for an early-career professional with approximately 3–5 years of relevant experience who is highly analytical, technically capable, business-minded, and motivated by the opportunity to apply emerging AI technologies to real-world business challenges. Primary Responsibilities: • Partner with Finance, Operations, IT, and functional leaders to understand business objectives, document requirements, assess current-state processes, and recommend data-driven solutions that improve efficiency, accuracy, and decision-making. • Design, develop, test, and maintain analytical models, predictive tools, reporting datasets, and AI-enabled solutions using Microsoft, SQL, Python/R, LLM, and related technologies. • Build, maintain, and optimize ETL/ELT pipelines that ingest, cleanse, transform, and validate data from multiple internal and external sources, including structured and unstructured datasets. • Develop dashboards, recurring reports, self-service analytics tools, and executive-level visualizations that translate complex data into clear, actionable business insights. • Apply machine learning, statistical analysis, forecasting, classification, optimization, and other advanced analytical methods to support planning, performance management, operational improvement, and strategic initiatives. • Provide technical guidance for data and analytics initiatives, ensuring solutions align with business priorities, data governance expectations, security practices, documentation standards, and scalable architecture principles. • Support enterprise-level data workflows, system interfaces, third-party software integrations, and modernization efforts, including evaluating legacy system risks and recommending long-term improvements. • Troubleshoot data quality, database, reporting, software, and infrastructure issues; optimize SQL queries, report performance, and data refresh processes; and escalate complex matters to vendors or internal stakeholders as needed. • Conduct code reviews, validate analytical outputs, promote reusable development practices, and help establish standards for data definitions, model documentation, testing, version control, and deployment. • Communicate findings, recommendations, risks, and tradeoffs clearly to technical and non-technical audiences, ensuring stakeholders understand both analytical results and practical business implications. Job Requirements • Minimum of 3 years of experience in data analysis, data science, systems analysis, business intelligence, financial analytics, or a related role; experience applying ML/AI concepts in a business environment strongly preferred. • Bachelor’s degree in Data Science, Computer Science, Information Systems, Finance, Quantitative Methods, Statistics, Engineering, or a related discipline; an equivalent combination of education and relevant experience may be considered. • Strong foundation in SQL, relational databases, data warehousing, data modeling, data validation, and workflow orchestration (an assessment will be administered for this skillset) . • Demonstrated analytical and problem-solving ability, including the capacity to evaluate ambiguous business issues, identify root causes, and propose practical technical solutions. • Ability to collaborate effectively with cross-functional stakeholders, end users, IT partners, and third-party vendors to deliver high-quality, sustainable analytics and system solutions. • Strong communication skills, including the ability to explain technical concepts, analytical assumptions, model outputs, and business recommendations in a clear and audience-appropriate manner. • Strong time-management, organization, and prioritization skills, with the ability to work independently, manage multiple concurrent initiatives, and meet deadlines in a dynamic environment. • High attention to detail and a commitment to producing accurate, reliable, repeatable, and well-documented work. • Working understanding of accounting, finance, and business operations terminology, including bookings, shipments, sales versus revenue, COGS, OpEx, debits, credits, and related reporting concepts. • Working knowledge of ERP transaction flows, preferably within Microsoft Dynamics NAV/Business Central; experience with manufacturing, distribution, or inventory-related data is helpful. Technical Requirements • Advanced proficiency with Microsoft-based data, reporting, and development technologies, including SQL Server and related database tools. • Hands-on experience with machine learning and AI concepts, including model development, evaluation, automation, prompt-based or LLM-enabled workflows, and responsible use of AI outputs. • Strong experience with relational database design, SQL development, stored procedures, triggers, query optimization, indexing strategies, and performance tuning. • Proficiency with at least one scripting or statistical programming language, such as Python, R, or a comparable tool, for data processing, automation, modeling, and analysis. • Strong preference for hands-on experience with Power BI, including dataset design, DAX, report development, dashboard publishing, refresh management, and performance optimization; comparable visualization tools may be considered. • Experience with Git or other version control systems; familiarity with CI/CD practices for data pipelines, analytics assets, reports, or software development preferred. • Working knowledge of Access, Oracle databases, Syspro ERP, or related enterprise applications preferred. • Knowledge of data storage strategies, partitioning, indexing, data retention, data quality controls, and governance considerations a plus. • Demonstrated ability to translate complex business requirements into scalable technical designs, data models, reports, integrations, and automation solutions. • Experience integrating ERP, financial, operational, or other enterprise-grade systems with reporting, analytics, or data warehouse environments. • Understanding of software security, access controls, testing practices, model validation, peer review, release management, and documentation standards. Work Environment – Office-Based Role (PA/OH/MI/MN/IN locations possible) • This role is primarily performed in a professional office environment and requires regular collaboration with cross-functional business partners. Occasional access to manufacturing, warehouse, or production areas may be required; applicable safety protocols and personal protective equipment requirements must be followed. Prepared by: Human Resources Approved by: Senior Manager, FP&A

Requirements

Must-haves

Job Title: Data Scientist (Locations available in: Warminster, PA, Hilliard, OH, Plymouth, MI, and Burnsville, MN)
Department: Finance
Accountability: This Position Reports to the Senior Manager, Financial Planning & Analytics
Design, develop, test, and maintain analytical models, predictive tools, reporting datasets, and AI-enabled solutions using Microsoft, SQL, Python/R, LLM, and related technologies.
Build, maintain, and optimize ETL/ELT pipelines that ingest, cleanse, transform, and validate data from multiple internal and external sources, including structured and unstructured datasets.
Develop dashboards, recurring reports, self-service analytics tools, and executive-level visualizations that translate complex data into clear, actionable business insights.
Support enterprise-level data workflows, system interfaces, third-party software integrations, and modernization efforts, including evaluating legacy system risks and recommending long-term improvements.
Conduct code reviews, validate analytical outputs, promote reusable development practices, and help establish standards for data definitions, model documentation, testing, version control, and deployment.
Communicate findings, recommendations, risks, and tradeoffs clearly to technical and non-technical audiences, ensuring stakeholders understand both analytical results and practical business implications.
Job Requirements
Strong foundation in SQL, relational databases, data warehousing, data modeling, data validation, and workflow orchestration (an assessment will be administered for this skillset) .
Demonstrated analytical and problem-solving ability, including the capacity to evaluate ambiguous business issues, identify root causes, and propose practical technical solutions.
Ability to collaborate effectively with cross-functional stakeholders, end users, IT partners, and third-party vendors to deliver high-quality, sustainable analytics and system solutions.
Strong communication skills, including the ability to explain technical concepts, analytical assumptions, model outputs, and business recommendations in a clear and audience-appropriate manner.
Strong time-management, organization, and prioritization skills, with the ability to work independently, manage multiple concurrent initiatives, and meet deadlines in a dynamic environment.
High attention to detail and a commitment to producing accurate, reliable, repeatable, and well-documented work.
Working understanding of accounting, finance, and business operations terminology, including bookings, shipments, sales versus revenue, COGS, OpEx, debits, credits, and related reporting concepts.
Working knowledge of ERP transaction flows, preferably within Microsoft Dynamics NAV/Business Central; experience with manufacturing, distribution, or inventory-related data is helpful.
Technical Requirements
Advanced proficiency with Microsoft-based data, reporting, and development technologies, including SQL Server and related database tools.
Hands-on experience with machine learning and AI concepts, including model development, evaluation, automation, prompt-based or LLM-enabled workflows, and responsible use of AI outputs.

Nice-to-haves

Experience with Git or other version control systems; familiarity with CI/CD practices for data pipelines, analytics assets, reports, or software development preferred.
Working knowledge of Access, Oracle databases, Syspro ERP, or related enterprise applications preferred.
Knowledge of data storage strategies, partitioning, indexing, data retention, data quality controls, and governance considerations a plus.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

machine learningaisqlpythonllmmlci/cd

Platform: adp-workforce-now
Effort: medium