Financial Analyst

Guardian-Protection-; Marshall Township (PA); On-site; USD 60,000 - 90,000; Full time

Job summary

Guardian Protection is seeking a Financial Analyst to collaborate with marketing and sales leadership. The role involves building standardized financial analyses, shaping data with SQL and Power BI, and owning parts of the monthly close with variance explanations.

Applicants should have a bachelor’s degree in finance or related field, 1–2 years of experience, and strong Excel and communication skills. Proactive learners with SQL are encouraged to apply.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, or related field.
• 1–2 years of financial analysis experience.
• Advanced Excel skills (lookups, pivot tables, modeling).
• Strong communication and ability to explain numbers.
• Working knowledge of SQL or quick learner.

Responsibilities

• Develop standardized financial analysis and reporting for Marketing & Sales.
• Pull and shape data using SQL and Power BI.
• Own portions of monthly close and variance explanations.
• Perform financial analysis of new projects and growth opportunities.
• Support annual budgeting and process improvements.

Skills

Excel (Advanced)

Communication

Analytical thinking

SQL familiarity

Education

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

Tools

SQL

Power BI

AI tools

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 packageComprehensive benefit package starting day 1Opportunity to learn the business and industry leading to growth within the companyDirect, regular exposure to senior leadership — your analysis goes to the people making the decisionsThe chance to be part of a Top 10 security company and high-energy employee cultureWhat You’ll Be Doing:Work with various business leaders on development of standardized financial analysis and reporting, with focus in Marketing & Sales functionsPull and shape data yourself using SQL and Power BI / Fabric semantic models, and use AI tools to accelerate analysisOwn pieces of the monthly close and reporting process for your business areas, explaining variances and trends — not just producing the numbersPerform financial analysis of new projects and growth opportunities.Assistance with the completion of annual budgetIdentify and lead process improvements that make reporting faster and more reliableWhat You’ll Need:Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or a related field1–2 years of financial analysis experience (internships count)Advanced Excel skills — you're comfortable with lookups, pivot tables, and building a model from scratchStrong communication skills — you can explain what the numbers mean to someone who doesn't live in a spreadsheetIntellectual curiosity and a bias toward improving how things get doneWorking knowledge of SQL, or a demonstrated ability to learn it quicklyWho We AreThe 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.