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%
• 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.
• 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.
• 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 - 20%
• 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 - 5%
• Seek input from team members and supervisors on areas to improve skill set.
• Actively apply feedback received into day-to-day work and strives to improve performance.
• Actively train on new systems and new technologies as they are incorporated into use by QuikTrip.
• 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.
• Maintain professional and technical knowledge by attending on-going training workshops, reviewing professional publications, reviewing industry best practice
Location: Tulsa, OK
Posted: Sept. 15, 2024, 6:14 a.m.
Apply Now Company Website