IT - App Development - Data Analyst

Replacement Parts, Inc•Little Rock, AR

About The Position

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.

Requirements

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.
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.
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.
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.
Hands on experience with MS Access and knowledge of ODBC, JCDB, JSON, XML, linked servers, and data replication.
Proficiency with SSIS, SSRS, and other automation tools for ETL processing is required.
Demonstrable knowledge of Dashboard creation.

Nice To Haves

Experience with MS SQL Server Management Studio, PostGreSQL, FireBird, Unidata databases is helpful.
Prior exposure to multiple programming languages - Python, Java, Visual Basic, C++, C#, R is also helpful.

Responsibilities

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
Operates in a rapidly changing environment with a sense of urgency with a high level of intellectual curiosity and comfort with ambiguity.