Data Engineer II

Job description

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. This position relies on instructions and pre-established guidelines to perform the functions of the job. Major Functions: Development (50%) Write, modify, extend and debug data pipelines based on QuikTrip’s Software Development Lifecycle (SDLC) process. Specific duties will include: Data Extraction and Analysis: Connect to diverse data sources and perform data analysis to determine if data is suitable for needs. Development of automated data pipelines to extract, cleanse, and transform data for intended business use. 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.). Development of automated data quality monitoring and alert processes Model and publish data sets for users to access through reporting and business intelligence technologies. 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#). Adhere to QuikTrip’s standards and best practices. Have extensive knowledge of development tools and environments utilized by QuikTrip. May act as a Product Technical Owner of a software product on occasion: Accountable for the technological performance of the product: Software Hardware Virtual Ware Tech Teams – Development, Data, Infrastructure, Contractors, and Professional Services Responsible for adherence to strategic plan while remaining focused on the teams handling the product. Responsible for the technical requirements. Responsible for Technical User Story acceptance. Manages the technical debt of the product. Manages conflicts of interest within the development team. Coordinates coding efforts across one or more development teams. Holds Development, Technical, Professional Services, Data, and other IT teams accountable within the framework of the product. 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. Leads trouble-shooting efforts by getting the right expertise involved and calling “war rooms” together when necessary. Acts as Scrum Master when the development team and PTO agree this is appropriate Technical Support (35%) Resolve technical issues utilizing excellent customer service skills, problem solving skills, and technical thinking/reasoning skills following established support process and metrics guidelines. Measure and analyze incoming issues to determine root cause and develop technical and training solutions to minimize reoccurrences and severity; report results to management. 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. Develop and publish support documentation for internal users for troubleshooting, training and other areas as needed. Gather and forward customer feedback and suggestions for product improvement. Position requires 24x7 support. Training (10%) Seek input from team members and supervisors on areas to improve skill set. Actively applies feedback received into day-to-day work and strives to improve performance Actively train with senior level developers to improve development skills and system knowledge. Actively utilize training outlets as necessary to 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. Maintain professional and technical knowledge by attending ongoing training workshops, reviewing professional publications, reviewing industry best practices/procedures and reviewing new technologies to determine fit within the organization. Assist in development of junior data engineers on skills or system knowledge through mentoring, knowledge transfer, code review, and shadowing. Administration and Communication (5%) Listen to others and accept input from team members. Clearly articulate ideas and thoughts both in verbal and written formats. Accurately prepares written business correspondence that is coherent, grammatically correct, effective and professional. 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. Accurately record project and trouble call work assignment updates within timeframes determined by departmental standards or individual supervisors. Record time tracking. Identify individual task progress. Identify task completion. Position in Organization: Reports to: Manager of Enterprise Data & Business Intelligence Relationships: Inside the Company: Information Technology staff and primary users of systems from other departments. Outside the Company: N/A Position Specifications: 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 : 3-5 years’ experience in programming data solutions. Familiar with all aspects of systems analysis, design, and installation procedures in a business environment. Desired experience : 5+ years professional experience including developing data solutions in a business environment, installing and troubleshooting hardware and software problems. Required skills : Proficient in one or more of QuikTrip’s data technologies or 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: $106,500-$133,100 Benefits: Employee Benefits – QuikTrip #LI-MI1