Business Intelligence & Systems Analyst

RaceTrac, Inc.; Atlanta (GA); On-site; USD 70,000 - 95,000; Full time

Job summary

RaceTrac, Inc. seeks a Business Intelligence and Systems Analyst to support reporting across Fuel & Energy Business. You will partner with internal customers and IT to develop data models, dashboards, and tools that turn data into actionable insights.

Responsibilities include ad hoc analyses, Power BI dashboard maintenance, UAT, and collaborating with multiple business groups to gather requirements. A Bachelor’s degree and 0–2 years in analytics are preferred; proficiency in SQL, SAS, SPSS, and

Qualifications

• Bachelor's degree in business/related field required.
• 0-2 years' experience as a systems analyst, database analyst/developer, or business analyst preferred.
• Experience in retail data analysis preferred.
• Proficiency with SQL, SAS, SPSS and BI tools required.

Responsibilities

• Provide research and reporting support to internal customers, incl. financial/data analysis and trend identification.
• Create reporting tools to identify business challenges and opportunities for improvement using diverse data sources.
• Fulfill ad hoc requests for reports on fuel trends, testing, and exception analysis.
• Assess and improve current reporting processes for analytics.

Skills

Data analysis

Business communication

Problem solving

Education

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

Tools

SQL

SAS

SPSS

Microsoft Fabric

Power BI

IRI/Nielsen data

Codex

Agent Bricks

Databricks Genie

Job description

The Business Intelligence and Systems Analyst supports various company categories and business functions across the Fuel & Energy Business 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.
• 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.

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
• Knowledge of Codex, Agent Bricks, Databricks Genie is preferred

Fueled by Growth, Driven by You

At RaceTrac, our people make the difference. Whether you're working in a store, at our corporate office, or on the road, you'll be part of a team that brings energy, innovation, and a passionforserving others every day. We support each other, celebrate wins big and small, and create opportunitiesforgrowth at every level. With four operating divisions RaceTrac, RaceWay, Energy Dispatch, and Gulf - there's always a new challenge to take on and a new path to pursue. Join us and discover how far your career can go.

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.