BI Engineer II

QuikTrip; Tulsa (OK); On-site; USD 100,000 - 125,000; Full time

Job summary

QuikTrip Corp. is seeking a BI Analyst to develop, enhance, and support BI models, reports, dashboards, and data visualizations across assigned business areas.

You will collaborate with business units to ensure BI tools meet business needs and comply with data governance policies. Responsibilities include gathering customer feedback, resolving BI issues with strong problem-solving, documenting resolutions, and publishing internal troubleshooting guides.

Qualifications

• 3+ years of experience delivering BI, analytics, data warehousing, or related data-focused solutions.
• 3+ years of SQL querying, transforming, and analyzing data.
• 3+ years of developing Power BI reports, dashboards, and semantic models.

Responsibilities

• Develop, enhance, and support BI models and applications (reports, dashboards, data visualizations).
• Partner with business areas to optimize BI applications and governance alignment.
• Gather and forward customer feedback for product improvement.
• Resolve BI issues with strong customer service and problem-solving.
• Document customer issues and resolution steps in tracking software.

Skills

Customer service

Problem solving

Technical thinking

Education

High school diploma

Tools

SQL

Power BI

SSAS

SSRS

Excel BI

Job description

• 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.

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

• 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%

• 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%

• 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%

• 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%

• 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.

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.

Compensation Data

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

Benefits

Employee Benefits – QuikTrip