Title:  Senior Data Engineer

Category:  Corporate Office
Date:  Jul 18, 2024
Location: 

Tulsa, OK, US

This role performs all aspects of the data engineering pipeline and or process. We are given requirements and or needs for data sets and must design and develop the correct process and method for landing, transforming, and validating the process. This can include working with multiple sources such as flat files, DB2, SQL Server, and API calls. This process utilizes DEVOPS for CI/CD pipelines and or deployments. Must be able to work independently or with a team using repeatable processes and standards. Tool experience like Azure Data Factory, Azure Data Lake, Databricks, SQL, & PySpark is required. Additional experience with SSIS, Python, and Azure Synapse is a plus.

 

Primary Purpose of job:

This position is responsible for programming, testing, implementing, supporting, and maintaining data pipelines, data stores (e.g., Data Warehouse, Mart, Hub, etc.), and business intelligence models.

 

Development - 70%

  1. Write, modify, extend and debug data pipelines based on QuikTrip’s Software Development Lifecycle (SDLC) process.  Specific duties will include:
    1. Data Extraction and Analysis: Connect to diverse data sources and perform data analysis to determine if data is suitable for needs. 
    2. Development of automated data pipelines to extract, cleanse, and transform data for intended business use. 
    3. Development of automated processes to consolidate diverse sources of similar data in to a single source of truth for QuikTrip (e.g. store, product, employee, etc.). 
    4. Development of automated data quality monitoring and alert processes
    5. Model and publish data sets for users to access through reporting and business intelligence technologies. 
    6. Possesses and apply working knowledge of multiple languages and tools utilized by QuikTrip during development process.  Common tools and languages: ETL, T-SQL, Data Profiling and MDM tools, BI Modeling Tools (e.g. SSAS, Power BI), and Programming Languages (e.g. C#).
  2. Adhere to QuikTrip’s standards and best practices.
  3. Have extensive knowledge of development tools and environments utilized by QuikTrip.
  4. Lead efforts to design data solutions that meet defined business needs, adhere to standards, and strive to maximize flexibility and scalability within time and cost constraints.  Key activities include: Data Modeling, Data Pipeline designs, and Metadata driven automations.   
  5. May act as a Product Technical Owner of a software product on occasion: 
    1. Accountable for the technological performance of the product:
      1.  Software
      2. Hardware
      3.  Virtual Ware
      4. Tech Teams – Development, Data, Infrastructure, Contractors, and Professional Services
    2. Responsible for adherence to strategic plan while remaining focused on the teams handling the product.
    3. Responsible for the technical requirements.
    4. Responsible for Technical User Story acceptance.
    5. Manages the technical debt of the product.
    6. Manages conflicts of interest within the development team.
    7. Coordinates coding efforts across one or more development teams.
    8. Holds Development, Technical, Professional Services, Data, and other IT teams accountable within the framework of the product.
    9. Accepts input and guidance from our Architecture, Infrastructure and Development teams and acts as the one voice back to Professional Services on technology related items when decisions need to be made.
    10. Leads trouble-shooting efforts by getting the right expertise involved and calling “war rooms” together when necessary.
  6. Acts as Scrum Master when the development team and PTO agree this is appropriate.

 

Technical Support - 20%

  1. Resolve technical issues utilizing excellent customer service skills, problem solving skills, and technical thinking/reasoning skills following established support process and metrics guidelines.
  2. Measure and analyze incoming issues to determine root cause and develop technical and training solutions to minimize reoccurrences and severity; report results to management.
  3. Accurately document all customer issues, resolution steps, and gather feedback in support tracking software to enhance identifying and reporting trends leading to recurring technical problems.
  4. Develop and publish support documentation for internal users for troubleshooting, training and other areas as needed.
  5. Gather and forward customer feedback and suggestions for product improvement.
  6. Position requires 24x7 support.

 

Training - 5%

  1. Seek input from team members and supervisors on areas to improve skill set.
  2. Actively apply feedback received into day-to-day work and strives to improve performance.
  3. Actively train on new systems and new technologies as they are incorporated into use by QuikTrip.
  4. Actively utilize training outlets as necessary improve development skills.  This could take the form of multiple items, including but not limited to self-study, in-house classes, seminars or online training.
  5. Maintain professional and technical knowledge by attending on-going training workshops, reviewing professional publications, reviewing industry best practices/procedures and reviewing new technologies to determine fit within the organization.
  6. Actively train junior developers on development skills or system knowledge through mentoring, knowledge transfer, code review, and shadowing.

 

Administration and Communication - 5 %

  1. Listen to others and accept input from team members.
  2. Clearly articulate ideas and thoughts both in verbal and written formats.
  3. Accurately prepares written business correspondence that is coherent, grammatically correct, effective and professional.
  4. Timely communicate status updates with the project manager or lead, the project team, and/or key customers and supervisor regarding specific assignments and overall scheduling/coordination needs.
  5. Accurately record project and trouble call work assignment updates within timeframes determined by departmental standards or individual supervisors.
  1. Record time tracking.
  2. Identify individual task progress.
  3. Identify task completion.

 

Position in Organization: Data Engineering Manager

 

Relationships: 

Inside the Company: Information Technology staff and primary users of systems from other departments.

Outside the Company: Technology vendors, contractors, and consultants

 

Position Specification: The required specifications (education, experience, and skills) are those that the employee must have to hold the position.  Applicants applying for this position must possess the required specifications in order to be considered for the job.  The desired specifications are those that are not required for the employee to hold the position, but the employee should try to obtain the desired education, experience, and/or skills to be effective and successful in the position.

 

Required education: High school graduate or equivalent. College or technical school courses in one or more programming languages or data tools used at QuikTrip.

Desired education: College degree in Computer Science, MIS, Mathematics, or related discipline.

Required experience: 5-8 years' progressive experience programming complex data solutions. Familiar with all aspects of systems analysis, design, and installation procedures in a business environment

Desired experience: 8+ years’ professional experience in programming data solutions. 2+ years system analysis in business environment..

Required skills: Competent and knowledgeable of the entire data engineering range of duties. Proficient in one or more QuikTrip standard data technologies and languages. Good problem-solving skills. Familiar with a variety of IT concepts, practices and procedures. Good written and verbal communication skills and time management skills.

Desired skills: Proficiency in all programming languages and data tools in use at QuikTrip.

 

Additional Criteria: This position requires good communications skills to assist customers with problems. Ability to work in a fast-paced team environment.  Works under direct supervision. Intermittent or extended travel may be required based on project or support requirements and may encompass Holidays and non-standard working hours.

 

Starting Salary: $113,900-$142,300

 


Nearest Major Market: Tulsa
Nearest Secondary Market: Oklahoma