Financial Analyst

Guardian Protection; Warrendale (Allegheny County); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

Attractive compensation package

Benefits starting day 1

Growth opportunities within the career

Direct exposure to senior leadership —

Culture of a Top 10 security company

Job summary

Guardian Protection in Warrendale, PA, is seeking a Financial Analyst to help drive strategic insight across Marketing & Sales. You will build standardized financial analyses, report on performance, and present findings to key business leaders.

The role emphasizes data fluency, SQL, Power BI, and AI-assisted analysis, with involvement in monthly close, budgeting, and identifying efficiency improvements to support growth and decision making.

Qualifications

• Bachelor’s degree in Finance, Accounting, Economics, or Business Analytics.
• 1–2 years of financial analysis experience (internships count).
• Advanced Excel with lookups, pivot tables, and building models from scratch.

Responsibilities

• Develop standardized financial analysis and reporting for Marketing & Sales.
• Pull and shape data using SQL and Power BI / Fabric semantic models; use AI tools to accelerate analysis.
• Own parts of the monthly close and reporting process for your business areas, explaining variances and trends.
• Perform financial analysis of new projects and growth opportunities.
• Assist with the completion of annual budget.
• Identify and lead process improvements that make reporting faster and more reliable.

Skills

SQL

Power BI

Advanced Excel

Communication

Analytical thinking

Learning ability

Education

Bachelor's degree in Finance, Accounting, Economics, Business Analytics

Tools

Fabric semantic models

Job description

Are you interested in working in a growing industry? Increased demand for smart security has opened a brand new opportunity at Guardian for a high-energy Financial Analyst like you. We provide smart technology, 24/7 professional monitoring, and peace of mind to hundreds of thousands of customers. Our products are installed by experts, monitored by real people, and truly make a difference. We do what we do because of one simple truth: life is better when it’s safe.

What’s In It For You

• Attractive compensation package
• Comprehensive benefit package starting day 1
• Opportunity to learn the business and industry leading to growth within the company
• Direct, regular exposure to senior leadership — your analysis goes to the people making the decisions
• The chance to be part of a Top 10 security company and high-energy employee culture

What You’ll Be Doing

• Work with various business leaders on development of standardized financial analysis and reporting, with focus in Marketing & Sales functions
• Pull and shape data yourself using SQL and Power BI / Fabric semantic models, and use AI tools to accelerate analysis
• Own pieces of the monthly close and reporting process for your business areas, explaining variances and trends — not just producing the numbers
• Perform financial analysis of new projects and growth opportunities.
• Assistance with the completion of annual budget
• Identify and lead process improvements that make reporting faster and more reliable

What You’ll Need

• Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or a related field
• 1–2 years of financial analysis experience (internships count)
• Advanced Excel skills — you're comfortable with lookups, pivot tables, and building a model from scratch
• Strong communication skills — you can explain what the numbers mean to someone who doesn't live in a spreadsheet
• Intellectual curiosity and a bias toward improving how things get done
• Working knowledge of SQL, or a demonstrated ability to learn it quickly

Who We Are

The Armstrong Group is a family owned and operated collection of diverse companies. What began in 1946 as Armstrong County Line Construction, founded by Jud L. Sedwick in Kittanning, PA, has now grown into an organization that encompasses multiple industries and employs over 2,400 individuals nationwide. Our brands include Armstrong Utilities, Guardian Protection, Armstrong Development, 4Front Solutions, Twin Pops, and Armstrong Comfort Solutions.

Armstrong is an Equal Opportunity Employer.