Data Analytics Senior Consultant I

Predictive Modeling and Forecasting

• Design, build, populate, own, monitor, and maintain medium- to high-complexity predictive models, including reruns and backfills.
• Build and support Python workflows for operational forecasting, reporting, and scalable analytical solutions.
• Query and transform datasets using Python and SQL to create feature datasets; perform data validation, reconciliation, and anomaly detection.

Data Preparation and Quality

• Perform data validation, reconciliation, and anomaly detection.

Process Improvement

• Automate manual and spreadsheet-based processes, identify efficiency opportunities, and implement creative modeling concepts that improve business processes.

Business Partnership

• Translate business questions into analytical solutions, provide high-quality data models to support stakeholder performance initiatives, and communicate effectively with stakeholders, product owners, and team members.

Knowledge Sharing

• Support peer-to-peer cross-training and help build team capability through collaboration.

Qualifications

• Experience developing, maintaining, or supporting predictive models.
• Advanced Python skills for data analysis, feature engineering, workflow development, and model creation.
• Advanced SQL (joins, aggregations, window functions).
• Experience working with large or complex datasets.
• Experience troubleshooting and debugging analytical processes.
• Experience building and implementing short and long-term demand and capacity forecasting models (a plus).

Skills

• Intermediate to advanced ability to build forecasts and/or technical tools, using a variety of data reporting and visualization software.
• Intermediate technical knowledge with data management processes (i.e., data flow within systems, data mapping, etc.) and/or experience with integrating data from multiple sources, including databases, unstructured data, and/or other enterprise data stores.
• Comprehensive knowledge of forecast reporting and business knowledge (financial skills, follow the numbers).
• Advanced proficiency in querying, compiling, analyzing, and integrating information from different sources to make data informative and form a recommendation.
• Demonstrated ability to work with numbers and develop medium to high complexity formulas.
• Advanced PC skills including Excel, PowerPoint, and Word.
• Exceptional interpersonal skills to work effectively in a virtual team environment.
• Effective time management and organization skills.
• Strong oral and written communication skills.

Skills (continued)

• Advanced SQL
• Big Data
• Data Engineering
• Data Query
• Predictive Modeling
• Python (Programming Language)

Compensation

Compensation offered for this role is $70,100.00 - $121,475.00 annually and is based on experience and qualifications.