Strategic BI & Systems Analyst

RaceTrac; Atlanta (GA); On-site; USD 75,000 - 110,000; Full time

Job summary

RaceTrac's Business Intelligence and Systems Analyst collaborates with internal customers and IT to ensure accurate reporting and actionable data. The role develops reporting tools, data models, and Power BI dashboards to support Retail Fuel Pricing, Gulf, RaceWay, Energy Dispatch, and other units with timely insights.

Responsibilities include researching and compiling financial and data analyses, fulfilling ad hoc requests, coordinating with IT on data storage methods, and conducting UAT to

Qualifications

• Bachelor’s degree from an accredited college or university in a related field.
• 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 BI software preferred
• Proficiency in Microsoft Excel, Microsoft Power BI
• Knowledge of syndicated data like IRI and Nielsen is a plus
• Knowledge of Codex, Agent Bricks, Databricks Genie is preferred

Responsibilities

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

Skills

SQL

SAS

SPSS

Power BI

Excel

Data analysis

Education

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

Tools

Databricks Genie

Codex

Agent Bricks

Databricks

Job description

RaceTrac's Business Intelligence and Systems Analyst collaborates with internal customers and IT to ensure accurate reporting and actionable data. The role develops reporting tools, data models, and Power BI dashboards to support Retail Fuel Pricing, Gulf, RaceWay, Energy Dispatch, and other units with timely insights.

Responsibilities include researching and compiling financial and data analyses, fulfilling ad hoc requests, coordinating with IT on data storage methods, and conducting UAT to