IT - App Development - Data Analyst

Bumper to Bumper•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. 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.

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