BI Engineer II

Create, manage and maintain performant BI and reporting solutions – 30%

1. • Develop, enhance, and support BI models and applications (e.g. reports, dashboards, data visualizations) in support of customer needs in assigned business areas.
   • Partner with assigned business areas to ensure that BI applications and workspaces are optimized for business purpose and aligned with relevant data governance policies.
   • Gather and forward customer feedback and suggestions for product improvement.
   • Resolve BI issues utilizing excellent customer service, problem solving, 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 recurrences 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 problems.
   • Develop and publish support documentation for internal users for troubleshooting, training and other areas as needed.

Maintain proficiency with Power BI tools, technology, and concepts - 20%

1. • Primary BI technology stack in use at QuikTrip is Microsoft, which includes SSAS, SSRS, Power BI, and Excel BI components. Other technologies could be required due to changing business or technical needs.
   • Reach and maintain proficiency in all technologies relevant to position. Learn new features as they become available in technology stack.
   • Stay current on emerging industry capabilities related to data management and business intelligence that could provide ongoing value to assigned business units.

Assist with business analysis and requirements gathering – 20%

1. • Analyze and document requirements as well as current state reporting, business rules, and other variables relevant to building proposed data solutions
   • Assist Data Delivery Owners (DDOs) PTOs and engineers building data solutions by clarifying business intelligence requirements and performing quality assurance (QA) testing of published data sets, ensuring accuracy and adherence to business rules.
   • Provide leadership to less experienced team members on projects as well as user workgroups (centers of excellence).

Assist with documentation and maintenance of Power BI governance strategies and standards – 10%

1. • Assist with capturing and maintaining information for QT Data Inventory as well as metadata for published data sets.
   • Participate with the design processes and develop supporting materials such as document templates in effective support of the company’s data strategy.
   • Could also include researching how technology could be better leveraged by analyst team (e.g. TFS, SharePoint, etc.) and performing implementation tasks.

Recommend opportunities for data driven solutions – 10%

1. • Participate in the data stewardship processes, working with Data Owners, Stewards, and other stakeholders to recommend data sources, definitions, business rules, and data quality rules.
   • Facilitate discussions with management and staff in assigned business units to understand challenges and opportunities, which can be addressed with data solutions.
   • Develop and maintain knowledge of processes, objectives, systems, and data of assigned business units to pro-actively propose solutions and serve as SME on development efforts.

Training – 10%

1. • 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 more experienced team members to improve Analyst skills and data knowledge.
   • Actively utilize training outlets as necessary improve relevant 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.
   • May train junior analysts on development skills or system knowledge.

Primary Purpose of the job

Enable QT to derive value from data by working with assigned business units to understand opportunities where data solutions can support business objectives, improve process efficiency, or support data driven decision making. To deliver on these opportunities, this position analyzes business requirements and associated data, and provides subject matter expertise on systems, data, and business processes to teams tasked with building data solutions. To mitigate risks associated with data usage, this position facilitates data and BI stewardship to ensure data is used consistently and accurately throughout the organization, leading to confident decisions based on trusted data. Additionally, this position develops BI data models as well as BI applications (e.g. reports, dashboards, data visualizations) to enable valuable usage of QT data assets.

Required Education

High school graduate or equivalent.

Required Experience

3+ years of experience delivering business intelligence, analytics, data warehousing, or other data-focused solutions. 3+ years of experience using SQL to query, transform, and analyze data. 3+ years of experience developing Power BI reports, dashboards, and semantic models.

Position in Organization

Reports to: Sr. IT Program Manager – BI & Platform

Relationship

Inside the Company: Management and staff in assigned business units, Enterprise Data & BI Manager, DDOs, PTOs, Data Engineering Manager, Sr IT Program Manager and Team, Product Portfolio Developers, Data Stewards, other IT personnel, business area analysts and management.

Outside the Company: Data consulting partners, Hardware/software vendors, and industry user groups.

Additional Criteria for Scope & Impact of Position

Position will require candidate to provide secondary support after hours and possibly on weekends. Minimal travel may be required, primarily to visit QT facilities outside of Tulsa.

This position requires the employee to be available by phone and/or email and/or have accessibility to e-mail and QT network while out of the office.

Starting Salary: $99,600-$124,530

Benefits: Employee Benefits – QuikTrip