Business Intelligence & Systems Analyst

RaceTrac Petroleum, Inc.; United States; On-site; USD 55,000 - 75,000; Full time

Job summary

RaceTrac Petroleum, Inc. is looking for a Business Intelligence and Systems Analyst to support data analysis and reporting across the organization. This role involves collaboration with various business groups to develop and improve reporting tools, ensuring comprehensive data analysis.

The ideal candidate should have a Bachelor’s degree and familiarity with SQL, Power BI, and financial data analysis.

Applicants will join a team dedicated to enhancing business reporting efficiency and effectiveness.

Qualifications

• 0–2 years’ experience as a systems analyst, database analyst/developer, or business analyst.
• Knowledge of syndicated data like IRI and Nielsen is a plus.

Responsibilities

• Provide research and reporting support for internal customers.
• Create reporting tools to identify business challenges.
• Collaborate with multiple business groups to gather report requirements.
• Perform User Acceptance Testing (UAT) on data models.

Skills

Data analysis

SQL

Microsoft Power BI

Financial analysis

Microsoft Excel

Education

Bachelor’s degree in Business, Economics, Finance, Math, Computer Science, Statistics or related field

Tools

SAS

SPSS

Microsoft Fabric

Job description

The Business Intelligence and Systems Analyst supports various company categories and business functions across the Metroplex organization by ensuring the proper reporting and data are available for internal users. This role involves extensive collaboration with internal customers and the IT team to provide comprehensive data analysis and reporting solutions. The Analyst will act as a point of contact for reporting needs, develop reporting tools, and create data models to identify business challenges and opportunities for improvement. The Business Intelligence and Systems Analyst plays a crucial role in driving the business forward through meticulous data analysis and reporting, ensuring that internal customers have access to accurate and actionable data.

What You’ll Do

• Provide research and reporting support to internal customers, including financial analysis, data analysis, trend identification, and monitoring and summarizing the progress of tests and promotions.
• Create reporting tools to identify business challenges and opportunities for improvement. Use data from various sources in reporting to drive the business forward in areas such as retail pricing, wholesale analysis, fuel accounting, etc.
• Fulfill ad‑hoc requests for reports determining fuel trends, fuel grade testing, exception reporting analysis, etc.
• Assess current company reporting processes and provide recommendations for new methods to enhance reporting and analytics for internal customers.
• Work with the Business Intelligence team on reporting and data efficiency, ensuring Power BI dashboards are up and refreshing appropriately for all business units supported.
• When reports are down, work with IT to get reports functioning appropriately.
• Collaborate with multiple business groups to gather requirements for requested reports and dashboards. This includes Metroplex, Retail Fuel Pricing, Gulf, Silver Comet, B2B Sales, RaceWay, Legal, and Energy Dispatch.
• Meet with IT members to locate, understand, and consume tables needed to create the requested reports and dashboards. Make recommendations to IT on different storage methodologies for data based on use cases.
• Perform User Acceptance Testing (UAT) on the data to understand its quirks for creating fit‑for‑purpose report data models.
• Using the located data, curate it for a fit‑for‑purpose report data model, including the creation of datasets, dataflows, data lakehouse storage objects, and other data models.
• Consume the data model into a data analysis tool, such as Power BI, and build the appropriate business calculations and visuals according to gathered requirements.
• Work with business units to UAT the report/dashboard to identify and resolve any issues.
• Complete all documentation around reports and maintain organized storage for all report/dashboard files.
• Work with vendors to obtain better/more accurate data files.
• Communicate with leadership and stakeholders on report/dashboard findings, development status, issues, and plans to resolve issues.

What We’re Looking For

• Bachelor’s degree from an accredited college or university; a degree in Business, Economics, Finance, Math, Computer Science, Statistics or related field preferred.
• 0–2 years’ experience as a systems analyst, database analyst / developer, or business analyst preferred.
• Experience performing business analysis or financial/statistical data in a retail environment preferred.
• Knowledge of SQL, SAS, SPSS, Microsoft Fabric and other Business Intelligence software preferred.
• Proficiency in Microsoft Excel, Microsoft Power BI.
• Knowledge of syndicated data like IRI and Nielsen is a plus.

All qualified applicants will receive consideration for employment with RaceTrac without regard to their race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.