The Data Analyst role is to build data and reporting solutions, with a focus on SQL coding and dashboard building. An ideal candidate will be skilled in database creation and administration, ETL processes, be a strong cross-functional communicator and collaborator, and have raw analytical skills. The Data Analyst is a key contributor supporting many departments and applications. The support of this complex organization provides for a tremendous amount of challenge and variety. This job is responsible for collecting, examining, and identifying data patterns and trends that help drive actionable business insights and decision-making. This position will use a variety of development languages and environments to perform their daily duties.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
- Collecting and managing data, including exploratory data analysis (EDA).
- Identifying trends and patterns in complex datasets.
- Presenting findings in an easy-to-understand way to inform data-driven decisions.
- Ability to produce dashboards, including graphs, tables, and other visualizations.
- Manage analytics projects from start to finish (data integration, analysis, reporting).
- Carrying out statistical research, prototyping new systems, and finding new ways of gathering, cleaning, and analyzing data.
- Design machine learning systems and self-running AI software to automate the construction of predictive models.
- Document machine learning processes.
- Keep up to date with modern approaches in machine learning.
- Actively working to identify improvements to internal processes, to improve conversions, revenue, ROI (or other relevant metrics).
- Identify data science tool needs and build out tools to enable team as a whole.
- Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data mining applications with existing systems.
- Provide and apply quality assurance best practices for data mining/analysis services across the organization.
- Develop, implement, and maintain change control and testing processes for modifications to data models.
- Monitor data mining system details within the database, including stored procedures and execution time, and implement efficiency improvements.
- Respond to and resolve data mining performance issues.
- Develop, code, install, test, debug, and document processes using appropriate editors.
- Diagnose, troubleshoot, and document problems with existing ETL processes
- On the whole, operates in a rapidly changing environment with a sense of urgency with a high level of intellectual curiosity and comfort with ambiguity.
Supervisory Responsibilities
This job has no supervisory responsibilities.
Competencies
To perform the job successfully, an individual should demonstrate the following competencies:
Analytical - Synthesizes complex or diverse information; collects and researches data.
Continuous Learning - Pursues training and development opportunities; strives to continuously build knowledge and skills; shares expertise with others.
Job Knowledge - Competent in required job skills and knowledge; exhibits ability to learn and apply new skills; keeps abreast of current developments.
Use of Technology - Demonstrates required skills; adapts to new technologies; troubleshoots technological problems; uses technology to increase productivity; keeps technical skills up to date.
Machine Learning/AI – Competent in Machine Learning and AI concepts; skilled in predictive data mining; will serve as Subject Matter Expert for department in these areas.
Problem Solving - Identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; works well in group problem solving situations.
Communications - Expresses ideas and thoughts verbally; expresses ideas and thoughts in written form.
Cooperation - Offers assistance and support to co-workers; works cooperatively in group situations.
Customer Service - Responds promptly to customer needs; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments.
Planning/Organizing - Prioritizes and plans work activities; uses time efficiently.
Quantity - Meets productivity standards; completes work in timely manner.
Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education and/or Experience
Bachelor's degree from four-year college or university, and one to three years related experience and/or training; or equivalent combination of education and experience.
Language Skills
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
Mathematical Skills
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
Reasoning Ability
Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
Computer Skills
To perform this job successfully, an individual should have hands on experience with MS Access and knowledge of ODBC, JCDB, JSON, XML, linked servers, and data replication. Experience with MS SQL Server Management Studio, PostGreSQL, FireBird, Unidata databases is helpful. Proficiency with SSIS, SSRS, and other automation tools for ETL processing is required. Prior exposure to multiple programming languages - Python, Java, Visual Basic, C++, C#, R is also helpful. Demonstrable knowledge of Dashboard creation.
Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to stand and walk. The employee must regularly lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is occasionally exposed to moving mechanical parts. The noise level in the work environment is usually moderate.
Employment at Replacement Parts, Inc. is subject to post offer, pre-employment drug testing. Equal Opportunity Employer. Replacement Parts, Inc. is a drug-free workplace.
