RaceTrac · 3 days ago
Business Intelligence & Systems Analyst
Wonder how qualified you are to the job?
Food and BeverageOil and Gas
Insider Connection @RaceTrac
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 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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s degree from an accredited college or university; a degree in Business, Economics, Finance, Math, Computer Science, Statistics or related field
Proficiency in Microsoft Excel, Microsoft Power BI
Preferred
0-2 years’ experience as a systems analyst, database analyst / developer, or business analyst
Experience performing business analysis or financial/statistical data in a retail environment
Knowledge of SQL, SAS, SPSS, Microsoft Fabric and other Business Intelligence software
Knowledge of syndicated data like IRI and Nielsen is a plus
Company
RaceTrac
Headquartered in Atlanta, GA, RaceTrac is a third-generation, family-owned company that is comprised of four operating divisions: RaceTrac, RaceWay, Energy Dispatch, and Metroplex Energy.