Financial & Business Intelligence Analyst

Financial & Business Intelligence Analyst

Idaho Asphalt Supply, Inc. is a leading asphalt supplier and marketer in the Inland Northwest and Pacific Northwest Regions. With plants in Idaho, Utah, Wyoming, Montana, Oregon, California, and Arizona, IAS supplies a diverse product line of asphalts, polymer-modified asphalt, and asphalt emulsions to the road maintenance and construction industry. IAS is seeking an energized and flexible self-starter to fill a full-time opening for a Financial & Business Intelligence Analyst located in Coeur d’Alene, ID (or one of our company locations) reporting to the Finance Director.

Position Overview: Reporting to the Director of Finance, the Financial & Business Intelligence Analyst plays a dual role in supporting both financial analysis and developing data models to support the strategic decision-making needs of the organization. This position will combine the duties of financial forecasting, variance analysis, and performance evaluation with advanced business intelligence reporting using tools like Power BI and SQL. This hybrid role is designed for a data-driven, detail-oriented professional with strong analytical and communication skills who can collaborate across departments to improve business outcomes. The Financial & Business Intelligence Analyst must be detail oriented, with a strong understanding of best practices. This position must thrive in an environment that is mission-driven, results-driven and team oriented. The ideal individual will have the ability to exercise good judgment in a variety of situations, with strong written and verbal communication, and organizational skills, and the ability to maintain a realistic balance among multiple priorities. The Financial & Business Intelligence Analyst must have the ability to work independently on projects as well as in a team environment, from conception to completion, and must be able to work under pressure at times to handle a wide variety of activities and projects.

Position Responsibilities:

- Financial:

- Perform variance analysis on financial results (budget vs. actual vs. prior year)

- Create visualizations & charting of key financial performance metrics for presentation to C-Suite and Board of Directors

- Develop, maintain, and update variable-based financial forecasts used for scenario modelling

- Complete monthly reporting bank reporting packages for review by CFO

- Point person on consolidating presentation content for quarterly Board of Directors’ meetings

- Support ad-hoc analysis for strategic projects related to business expansion, capital planning, and operational efficiency

- Business Intelligence:

- Collect, consolidate, condition and normalize data from multiple sources via queries

- Create advanced data models combining operational and financial data to drive KPI dashboards, visualizations, and scorecards using Power BI & SAP Analytics Cloud (“SAC”)

- Partner with stakeholders to understand business objectives and ensure data alignment with company strategy

- Collaborate with IT on data consolidation, clean-up, and warehousing to enable accurate and efficient reporting

Additional Duties:

- Provide technical and analytical insight into data-related issues

- Create documentation and business requirements for data projects

- Maintain error tracking and reporting tools for real-time data management

- Other duties and projects as assigned

Required Skills/Qualifications:

- Minimum 6 years of education and/or experience in finance, business intelligence, or a related analytical role. Educational/experience background must be in Finance, Accounting, Economics, Business Intelligence, or related field

- Knowledge of accounting/financial principles and financial statements (income statement, balance sheet, statement of cashflows)

- Strong proficiency in Power BI, Excel, SQL, and Microsoft Office Suite

- Previous experience with SAP Analytics Cloud is a plus

- Familiarity with Enterprise Resource Planning Systems (“ERPs”) and underlying databases

- Previous experience with SAP S4HANA database is a plus

- Experience with advanced data analytics techniques and building data models

- Familiarity with SAP S4HANA, Python or AI experience is a plus

- Excellent attention to detail, time management, and organizational skills

- Strong verbal and written communication and storytelling skills

- Ability to travel as needed with periodic overnight stays

- Professional, positive attitude with a growth mindset and adaptability to change

- Excellent problem solving and analytical skills.

- Highly resourceful; can solve problems independently and create useful and unique solutions.

- Strong organizational skills that reflect ability to perform and prioritize multiple tasks seamlessly with excellent attention to detail.

- Very strong interpersonal skills and the ability to build relationships with stakeholders.

- High level written and verbal communication skills.

- Demonstrated proactive approaches to problem-solving with strong decision-making capability.

- Emotional maturity.

- Demonstrated ability to achieve high performance goals and meet deadlines in a fast-paced environment.

- Must have a good sense of humor.

Physical Requirements:

- Prolonged periods sitting at a desk and working on a computer

- Must be able to lift up to 15 pounds at times

Key Competencies:

- Organized and Strong Attention to Detail

- Dedication to producing error-free, accurate work.

- Gets things done.

- Successfully juggles multiple projects.

- Manages time efficiently.

- Drive for Results

- Bias for action and getting things done.

- Taking calculated risks.

- Prioritize and push projects and initiatives to completion.

- Follows up with various parties.

- Teamwork

- Develops and leverages cooperative relationships.

- Willingly shares information/resources and assists others.

- Contributes constructively to the team decision making process.

- Supports the team decision with comments/actions outside the team.

- Fosters development by giving feedback, coaching, and mentoring.

- Embraces and Drives Change

- Demonstrates energy for effective implementation of change.

- Sees what is possible.

- Takes responsible risk.

- Owns & sustains the change.

- Personal Growth Mindset

- Able to reflect and learn from mistakes.

- Is curious and asks questions.

- Seeks to continuously improve themselves and everyone around them.

The success of Idaho Asphalt Supply is built by a dedicated team of professionals who excel in their roles and, in turn, we are seeking the best in class talent: professionals, scientists, engineers, advanced thinkers, and people who thrive on growth and collaboration to co-create the future of Idaho Asphalt.

To be the BEST, we must employ the BEST. We offer a competitive total rewards package, an innovative, dynamic, and fast-paced learning culture, and research environment.

Founded in 1976, our company is now a third-generation family business supplying materials to the highway construction industry. Our company is FIRST CHOICE in the industry due to our relentless pursuit of continuous improvement of the products and services we provide to our customers.

Idaho Asphalt Supply, Inc. is an Equal Opportunity Employer.

#ZR