Data Analytics Specialist

We are looking for a Data Analytics Specialist to work a part time contract position with SKpharmteco. We are a contract chemical manufacturing company located in Rancho Cordova, CA. This role can be an in-person or hybrid position. This is a 6 month contract. Job Summary: Under limited direction, provide technical analysis, curated data sets and reporting tools in a fast-paced environment through collaboration with business SMEs to accelerate building analytics driven production pipelines. Perform moderate to extensive problem solving around data quality, accuracy, and dataset connectivity. Use Analytics and BI tools and various programming languages to deliver insight, recommendations, and solutions for business users. Contribute to development of sustainable, consumable, accurate, and impactful reporting on business impact, and key performance indicators. Prepare reports, visualizations, PowerPoint presentations and analyses with large data sets for supervisor review, under time constraints and across various project types. Maintain relationships, timeline communication, and project scope with internal clients. Maintain several database structures and data analytics portfolios. Job Responsibilities: Through collaboration with department stakeholders, design, develop, test, and implement Analytics reports, databases, and/or dashboards and visualizations supporting company-wide Analytics projects and ad-hoc requests including data preparation, security design and access management, testing, optimization, and automation processes Deliver meaningful insights, trends, and analysis across all Quality Systems areas using a variety of internal and external data sources Use data to tell stories by creating visually appealing reports, dashboards, and presentations for internal customers Collaborate with multiple departments to collate data sources for integrated data pools. Translate analysis outcomes into compelling data visualizations that are intuitive and prompt insights and actions Manage portfolio of existing and future datasets and dashboards and deliverables May be responsible for authoring data analytics framework, best practices, and procedures. Deliver data and insights through interactive, creative, and professional visual graphics built on large static and live data sets May Coordinate problem resolution and reconciliation across multi-functional boundaries. May Develops ad hoc reports within the computer system to retrieve information for review and verification purposes. May perform data input from source documents into database. May require ability to read and interpret blueprints, standard operating procedures, and other function specific documents. May provide work leadership to operational data support personnel. Required: High School Diploma or GED and 12 years relevant experience Desired: Bachelor of Science degree or a similar field with four years relevant experience OR Master of Science with two years relevant experience Educational preparation or applied experience in at least one of the following areas: Process Engineering, Statistics, Mathematics, Computer Science, Data Science, or other related quantitative discipline Experience: Years of experience is degree dependent. Experience in Data Analytics with manufacturing, automation, or related disciplines Skills: Must be able to execute a complex sequence of operations in a field where standard procedures are available, but changing conditions require independent action. Ability to translate system data into spreadsheets or charts for subsequent analyses. Advanced knowledge of SQL (R or Python are a plus) Understanding of data visualization design best practices Ability to translate internal stakeholder requests into a data analytics spreadsheet and/or dashboard, take complex datasets and create key takeaways and recommendations using several data sources Strong data analytics, data accuracy, and collaboration skills Passionate about using data to tell stories Requires thorough knowledge of word processing, spreadsheet and graphics software packages used in area of assignment. Requires thorough knowledge of data base file structure to facilitate complex ad hoc report generation. Required: Expert Level knowledge of Microsoft Office and calculations. Expert knowledge in PowerBI or other BI interfaces; as well as, utilizing BI with excel. Advanced knowledge of data dashboard and visualization technical development.