Job Location: Knoxville, TN
Essential Duties and Responsibilities include the following. Other duties may be assigned.
- Regular and Consistent Attendance
- Collaborate with the Data Operations and Other IT Development Teams
- Perform Necessary Production Support for Data Operations Processes
- Maintain and Create Extract, Transform, and Load (ETL) Processes
- Develop and Tune T-SQL Queries
- Create Relational Data Sets for Production Consumption
- Profile Relational Data Sources
- Prepare and Maintain Team Key Performance Indicators (KPIs)
- Enhance and Maintain System Logging and Performance Monitoring
- Support End Users of Data Operations Products
- Create Reporting Products
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.
Professional Skills:
- Expert in Microsoft T-SQL in an Enterprise Environment
- Experience with Microsoft SQL Server Integration Services (SSIS)
- Experience with Microsoft SQL Server Analysis Services (SSAS)
- Experience with Microsoft SQL Server Reporting Services (SSRS)
- Understanding of Relational Data Models
- Conceptual and Logical Knowledge of Enterprise Data Systems
- Ability to Understand and Communicate Business Needs
- Ability to Develop and Maintain Business-Oriented Metadata Definitions
- Ability to Prioritize End-User Requirements
- Ability to Create Professional Documentation
- Proficiency with Microsoft Office Suite, Particularly Excel
Education/Experience: Associate’s or bachelor’s degree in relevant field of study or one (4) to two (6) years’ experience working with data in a professional sense. Relevant course work, academic projects, or Regal work experience will be considered for professional experience.
Certificates, Licenses, Registrations: Any relevant professional training, certifications, or continuing education will be considered in evaluating professional experience.
Language Ability: Must have good reading, writing and speaking skills to effectively communicate with co-workers, industry partners, and leadership.
Math Ability: Comfort with basic statistics and common business formulas. Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent, and to develop and interpret charts. Ability to utilize probability distributions, uniform distributions, standard deviation, normalization, and sampling.
Reasoning Ability: Perform under pressure and/or opposition at times relying on your own independent judgment and knowledge to decide the best directions and solutions. Comfortable evaluating parallel technical solutions and making design decisions that are compatible with the platform and development direction.
Computer Skills: In addition to software and languages specific to the role, a strong understanding of the Windows operating system, general comfort using a Linux operating system. Comfort with the Microsoft Office suite with an emphasis on Excel. Comfort using various integrated development environments including Microsoft Visual Studio and Microsoft SQL Server Management Studio.
Supervisory Responsibilities: This position has no direct supervisory responsibilities.
Work Environment: The work environment for this position is an open plan corporate office. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the environment is low to moderate as to be expected in a collaborative work environment.
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 frequently required to stand; walk; sit and use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl and talk or hear. The vision requirements include close vision, distance vision, peripheral vision, depth perception and ability to adjust focus. The employee is occasionally required to lift up to 50 pounds.
Submit CV To All Data Science Job Consultants Across United States For Free
