Data Engineer II

Regal Cinemas Corporation Knoxville , TN 37902

Posted 3 months ago

Summary: The Data Engineer II is responsible for the design, development, implementation, security and maintenance of the company data warehouse and related technologies. Responsible for verifying accuracy of data, creating performant, low-impact collections, and supporting enterprise data through the full life cycle from collection to presentation to archiving. This role requires a strong understanding of business processes and collaboration with analysts and all levels of management for requirements gathering.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

  • Design, construct, install, test and maintain highly scalable data management systems.

  • Build high-performance algorithms, prototypes, predictive models and proof of concepts for data collection.

  • Product quality and timely deliverables as part of data operations project teams.

  • Research opportunities for data acquisition and new uses for existing data.

  • Develop data set processes for production use.

  • Use and support of various Enterprise Data Mining tools.

  • Verify accuracy of data throughout the business.

  • Recommend and implement ways to improve data reliability, efficiency, and quality.

  • Defines user interfaces and functional specifications.

  • Acceptance test planning & execution.

  • Perform peer reviews and take ownership to ensure quality of data.

  • Management of enterprise-wide data resources at the conceptual, logical and physical level

  • Employ a variety of languages and tools for data collection

  • Design technical architectures.

  • Maintain detailed documentation on all processes

  • Production support on a rotating basis.

  • Other duties as assigned.

  • Regular and Consistent Attendance

Requirements 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:

  • Must be organized and capable of providing leadership in a structured environment while requiring minimal day-to-day guidance.

  • Strong relational, dimensional data modeling and database design skills.

  • Strong analytical, problem-solving, time management and organizational skills.

  • Ability to prioritize end-user requirements.

  • Ability to translate business needs into data analysis and reporting solutions.

  • Experience in Data Warehouse architectures, life cycle and deployments.

  • Knowledge of dimension types, member properties, custom members and custom rollup.

  • Understand OLAP server architecture (Analysis Services).

  • Knowledge of object-oriented programming language (C#/VB.NET.)

  • Proficiency with Microsoft Excel (Experience with Power BI is a plus.)

  • Familiarity with Microsoft SharePoint.

  • Familiarity with web development (HTML, CSS, JavaScript, XSL, etc.)

  • Familiarity with Zap BI and Cube Xpress is a plus.

  • Familiarity with Azure Data Warehousing components.

  • Experience with advanced report creation using MS Reporting Services.

  • Strong Interpersonal and communications skills to effectively communicate and coordinate activities with other IT groups and users.

  • Must be a team player.

  • Ability to facilitate training and to teach end users to use tools and data

  • Skilled Knowledge of MS SQL server, query, reporting and OLAP tools

  • Ability to translate business needs into data management systems

  • Ability to develop business-oriented metadata definitions.

  • Ability to prioritize end-user requirements.

  • Strong relational, dimensional data modeling and database design skills.

Education/Experience:

Bachelor's Degree or equivalent IT systems experience. Minimum of three years of experience in designing, implementing, and building data management and warehousing systems in a MS SQL Server environment. Must have experience working with MS SQL Server and MSSQL Analysis Services. Proven ability to work throughout the full software development life-cycle. Experience in designing and building the database portion of the solution.

Certificates, Licenses, Registrations:

MCSA or MCSE a plus

Language Ability:

Interpersonal and communications skills must be adequate to effectively communicate with other IT groups, external support vendors, and Theatre management. 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, and customers.

Math 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.

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. While representing the company, the marketing coordinator will be required to determine answers to questions and situations which may be socially or politically volatile. Execution and communication of such solutions are often in the public eye.

Computer Skills:

Microsoft Outlook, Word, Excel, database software

Supervisory Responsibilities:

This position has no direct supervisory responsibilities.

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.

The noise level in the environment is moderate.

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.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Engineer II Big Data

Pilot Flying J

Posted 1 week ago

VIEW JOBS 9/7/2019 12:00:00 AM 2019-12-06T00:00 Job Description The purpose of this job is to research, develop, document, and modify extract, transform, load processes and jobs in support of a Big Data infrastructure, as well as data warehouse (EDW) for Pilot Flying J. Focus will be on Enterprise AWS Cloud environment, with an emphasis in EMR and Redshift. 1. Research, develop, document, and modify Big Data processes and jobs according to data architecture and modeling requirements, and processes set forth by Business Intelligence (BI) Data senior team members 2. Maintain accountability for completing key EDW/Data Lake project activities; communicate project status and risks to project leader 3. Troubleshoot issues including connection, failed jobs, application errors, server alerts, and space thresholds within predefined service level agreements (SLAs) 4. Proactively maintain and tune code according to EDW/Big Data best practices 5. Review and ensure appropriate documentation for all new development and modifications of the Big Data processes and jobs 6. Perform unit testing for solutions developed, and ensure integrity and security of institutional data 7. Under the guidance of lead data team members, take technical specifications and complete development per specifications. 8. Model behaviors that support the company's common purpose; ensure guests and team members are supported at the highest level 9. Ensure all activities are in compliance with rules, regulations, policies, and procedures of the organization 10. Complete other duties as assigned Qualifications * High school diploma or equivalent certification required * Bachelor's degree in computer science, engineering, information technology or related field preferred Qualifications, cont. * Minimum 1-3 years' technology operations experience required Specialized Knowledge * Strong SQL knowledge and skills required * Knowledge of Postgres and SQLServer preferred * Familiarity with AWS or similar data platform required * Knowledge of ETL tools such as Informatica or Datastage a plus * Familiarity with Enterprise Data Warehouse data models with a focus on Star Schemas preferred * Experience with Spark/Spark-streaming, Python, Hive, Kafka preferred * PFJ institutional knowledge preferred 5508 Lonas Rd Knoxville TN Application Instructions Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you! Pilot Flying J Knoxville TN

Data Engineer II

Regal Cinemas Corporation