Finance & Business Analytics Manager

Armanino; Chicago (IL); On-site; USD 138,000 - 163,000; Full time

Benefits offered by this job

Medical, dental, vision

Generous PTO

Flexible work arrangements

401K with Profit Sharing

Wellness program

Parental leave

11 paid holidays

Job summary

Armanino LLP is hiring a Senior BI & Analytics Specialist to drive reporting, forecasting, and data modeling across Finance, Operations, and Leadership. You will design dashboards, optimize data flows, and mentor teams on self-serve analytics.

Ideal candidates have 5+ years in BI/FP&A analytics, strong Excel/Power Query/DAX skills, and experience with SQL, Python, and Pigment platform. This role is based in Chicago with a focus on enterprise data initiatives.

Qualifications

• Bachelor's degree in Finance, Analytics, or related field.
• Minimum 5 years in BI/Analytics, FP&A Analytics, or reporting.
• 3+ years creating scalable, automated reports.
• Expert in Excel, Power Query, and DAX.
• Familiar with SQL, Python, and financial statements.

Responsibilities

• Partner with FP&A leadership to translate business needs into reports.
• Lead requirement gatherings and design discussions.
• Train finance team on new reports and self-serve techniques.
• Serve as SME on reporting and data questions for internal stakeholders.
• Collaborate with Enterprise Analytics on data platform changes.
• Create centralized reports for forecasting, budgeting, and ad-hoc needs.
• Analyze large datasets and present findings to both technical and non-technical audiences.
• Identify opportunities to standardize and automate reporting using Power BI, Power Automate, Python and Excel.
• Apply AI-enabled analytics to improve data quality and speed.
• Maintain BI dashboards, reports, and semantic models (Finance, Ops, Exec).
• Ensure data accuracy, governance, and documentation standards.

Skills

Power BI

Power Automate

Excel

Power Query

DAX

SQL

Python

Forecasting

Autonomy

Education

Bachelor's degree in Finance/Analytics

Tools

Pigment

Job description

At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about. Armanino is proud to be Among the top 20 Largest Accounting and Consulting Firms in the Nation and one of the Best Places to Work. We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network. We want you to integrate all aspects of your life with your career. At Armanino, we know you don’t check-out of life when you check-in at work. That’s why we’ve created a unique work environment where your passions, work, and family & friends can overlap. We want to help you achieve growth by giving you access to a network of smart and supportive people, willing to listen to your ideas.

Job Responsibilities

Stakeholder Collaboration

• Partner with FP&A leadership and other stakeholders to translate business requirements into intuitive and actionable data and reporting solutions.
• Facilitate requirement gathering sessions and solution design discussions.
• Train and educate the broader Financial Team on new reports and how to effectively self-serve.
• Serve as SME on reporting and data questions for internal stakeholders, including training and support.
• Partner with the Firm’s Enterprise Analytics team to understand latest changes to the Firm’s broader Data Platform, semantic models and capabilities.

Financial & Operational Analytics

• Support FP&A team activities by creating centralized and standardized reports/processes for forecasting, budgeting and ad-hoc reporting.
• Analyze large datasets and communicate findings to both technical and non-technical audiences.
• Perform ad hoc analysis to identify trends, risks, opportunities, and operational improvements.

Automation & Process Improvement

• Identify opportunities to standardize, centralize and automate manual reporting and business processes for key stakeholders via Power BI, Power Automate, Python, Excel (Power Query) and other related technologies.
• Evaluate and apply AI-enabled automation opportunities, where appropriate, to reduce manual effort, improve data quality checks, accelerate recurring reporting processes, and support more efficient analysis.
• Streamline recurring reporting activities and improve data refresh processes.
• Partner with Data Engineering and IT teams to improve data accessibility and quality.

Business Intelligence, Reporting & Data Modeling

• Design, develop, and maintain Power BI dashboards, reports, and semantic models supporting Finance, Operations, Workforce Planning, and Executive Leadership.
• Maintain reporting standards, documentation, and governance practices.
• Work with SQL-based data sources, data warehouses, Microsoft Fabric, Azure, and other enterprise platforms.
• Serve as a key contributor to the firm’s Pigment planning platform, including model design, development, maintenance, testing, and enhancement of budgeting, forecasting, reporting, and analytical solutions; act as secondary platform administrator, behind the primary system administrator.

Continuous Innovation

• Help establish and promote analytics best practices across the organization.
• Continuous improvement mentality with curiosity towards emerging technologies that can improve reporting efficiency and business insights.
• Stay current on advances in Power BI, Microsoft Fabric, AI-powered analytics, automation tools, and data visualization best practices.
• Evaluate emerging technologies that can improve reporting efficiency and business insights.

Requirements

• Bachelor's degree in Finance, Accounting, Business Analytics, Data Analytics, Information Systems, Economics, Mathematics, or related field
• Minimum 5 years of experience in Business Intelligence, Analytics, FP&A Analytics, Data Analytics, or Reporting
• Minimum 3 years experience developing scalable, automated reporting
• Expert-level abilities in Microsoft Data Tools, including Excel, Power Query, DAX
• Working knowledge and understanding of Financial Statements and Financial Processes
• Prior experience with Power Automate, SQL, Python
• Prior experience working with large financial and operational data sets and transforming them into ongoing reports
• Ability to work autonomously driving initiatives to completion with limited oversight
• Team focused delivery mindset with strong attention to detail
• Experience supporting Finance, Operations, Professional Services, or Consulting organizations in a fast-paced environment

Preferred Qualifications

• Masters Degree in Business Intelligence, Analytics, FP&A Analytics, Data Analytics, or Related field
• Proven experience applying AI and/or machine learning-enabled capabilities to reporting, forecasting, anomaly detection, workflow automation, or insight generation
• Prior team leadership experience
• Prior experience performing these functions at a Professional Services Firm
• Experience with Pigment Financial Planning software

"Armanino" is the brand name under which Armanino LLP and Armanino Advisory LLC, independently owned entities, provide professional services in an alternative practice structure in accordance with law, regulations, and professional standards. Armanino LLP is a licensed independent CPA firm that provides attest services, and Armanino Advisory LLC and its subsidiary entities provide tax, advisory, and business consulting services. Armanino Advisory LLC and its subsidiary entities are not licensed CPA firms.

Armanino provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Armanino complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Armanino expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Armanino employees to perform their job duties may result in discipline up to and including discharge.

Armanino does not accept unsolicited candidates, referrals, or resumes from any staffing agency, recruiting service, sourcing entity, or third-party paid service at any time. Any referrals, resumes, or candidates submitted to Armanino or any employee or owner of Armanino without a pre-existing agreement signed by both parties covering the submission will be considered the property of Armanino and not subject to any fees or charges. For existing agreements, a role must be approved and open to external search; otherwise, unsolicited and unapproved submittals and referrals will be considered Armanino property and free of fees. In addition, Talent Acquisition is the sole point of contact, and contacting others in our organization without Talent Acquisition’s knowledge will result in termination of contract.

Certain states require us to disclose the pay range and benefits summary for job openings. For Colorado residents, the compensation range for this position: $125,600 - $147,800. For Washington residents, Illinois residents, New York residents, and Southern California residents, the compensation range for this position: $138,200 - $162,600. For Northern California residents, the compensation range for this position: $144,500 - $170,000. Compensation may vary based on skills, role, and location. Eligible employees at certain levels can participate in a discretionary long-term financial incentive plan, subject to plan participation rules.

Benefits

• Medical, dental, vision
• Generous PTO plan and paid sick time
• Flexible work arrangements
• 401K with Profit Sharing
• Wellness program
• Generous parental leave
• 11 paid holidays

For positions based in San Francisco, consistent with the SF Fair Chance Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration.

For Individuals who would be working within the City of Los Angeles, Armanino will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance.

To view our Consumer Notice at Collection for job applicants, please visit: