Data Engineer II

Overview

Here at Discount Tire, we celebrate the spirit of our people with extraordinary pride and enthusiasm. Our business has been growing for more than 60 years and now is the best time in our history to join us. We are opening more locations every year and we are always looking for qualified individuals to join us in our growth. We are a company that promotes from within, both in our retail and corporate operations.

Under general supervision, the Data Engineer II develops, tests, analyzes and maintains cloud-based analytics platform, including Enterprise Data Warehouse and other Big Data technologies.

• Develops high performance distributed data warehouse, distributed analytic systems and cloud architecture.
• Develops, tests and debugs batch and streaming, data pipelines (ETL/ELT) to populate databases and object stores from multiple disparate data sources; provides recommendations to improve data reliability, efficiency and quality.
• Performs data calculations through data integration tools and scripting languages.
• Implants data quality metrics, standards, guidelines; automates data quality checks / routines as part of data processing frameworks; validates flow of information.
• Ensures that Data Warehousing and Big Data systems meet business requirements and industry practices; including but not limited to, automation of system builds, security requirements, performance requirements and logging/monitoring requirements.
• Troubleshoots data and performance related issues; implements adjustments, documents root cause and corrective measure; provides recommendations to stakeholders.
• Documents technical specifications and participates with peers in design and code review sessions.
• Employ a variety of scripting languages and tools to integrate data from multiple disparate data sources.
• Stays current on the latest industry technologies, trends and strategies.
• Assists employees, vendors or other customers by answering questions related to Data Warehousing and Big Data processes, procedures and services.
• Completes work in a timely and accurate manner while providing exceptional customer service.
• Other duties as assigned.

• This position requires a minimum of five years of progressive database development and integration experience.
• Strong knowledge of logical and physical data modeling is necessary, including but not limited to entity design, relationships, indexing and star schemas.
• Ability to translate a logical data model into a relational or non-relational solution is necessary.
• Understanding of multiple relational (RDMS) and non-relational (No
  
  SQL) data platforms is needed.
• SQL experience is required.
• Scripting knowledge with SQL, Python, Java or R is necessary.
• Experience in SQL tuning, indexing, partitioning, data access patterns and scaling strategies is needed.
• Experience with data integrations and data processing for business intelligence and analytics workloads is required.
• Experience with AWS S3 or other distributed object stores, AWS Redshift, Elastic Map Reduce a plus.
• Hands-on experience in database development using views, SQL scripts and transformations is needed.
• Proficient with Microsoft office, including skills with Word and Excel, is necessary.
• Experience working with large complex data sets.
• Understanding of Software Development Life Cycle (SDLC) methodologies such as Agile and Waterfall is needed.
• Proven analytical problem solving and decision making skills is critical.
• Ability to communicate across all levels of the organization is necessary; must be able to clearly articulate technical ideas to a non-technical audience both verbally and in writing.
• Ability to work independently and in a team is vital.
• Customer service skills including the ability to manage and respond to different customer situations while maintaining a positive and friendly attitude is essential.
• The ability to multi-task, and manage multiple projects to meet various deadlines simultaneously is required.
• The ability to work efficiently and accurately under pressure, meet deadlines and present a professional demeanor is essential.
• In addition, troubleshooting and organizational skills with a…