Data Analyst

About Squire

Are you passionate about driving excellence and embracing innovation? Join our team where your dedication is not only valued but celebrated. Take the opportunity to contribute to a firm that recognizes and rewards your hard work. Apply now and be part of a team that fosters growth and encourages your professional development!

Based in Orem and Salt Lake City, Squire has been a trusted advisor in financial services, specializing in tax, audit, wealth, and advisory services for over 50 years. With solid values and business acumen as our foundation, Squire's culture promotes a steadfast commitment to three core values: Personal Connection, Proactive Ownership, and Thoughtful Innovation. These principles have played a pivotal role in our enduring success, guiding us through decades of growth and evolution.

We extend an invitation to individuals who share our dedication to excellence and innovation. Join us and discover the opportunity to contribute to a professional services firm where your efforts are valued and rewarded. At Squire, we offer a supportive environment conducive to career development and advancement through structured mentoring programs.

About the role:

We are looking for someone with advanced knowledge of SQL, who can create reports and use their knowledge of accounting principles to analyze data to join our fast-growing firm! If you're dedicated and ambitious, Squire & Company PC is an excellent place to develop your career.

Responsibilities:

• Write queries, views, and stored procedures to extract the data from SQL Server
• Create/develop data models, analysis, and visualization for Power BI
• Build and manage data sets and sources for Power BI
• Build end user tools to interact with firm data
• Design and develop business intelligence reports and dashboards for use by partners and staff of the firm
• Review and analyze reports for accuracy prior to distribution
• Clarify or research issues as necessary
• Build financial reports for business analysis and KPIs
• Assist in compiling and organizing data for use in forecasts and budgets
• Identify and research variances in trends and bring them to the attention of the supervisor for discussion and resolution
• Identify potential issues in data to develop a solution and interact with appropriate staff to achieve a resolution
• Assist with special projects as assigned

Qualifications:

• Bachelor's degree in information systems, business, or a related field preferred, or 2 years’ experience on the job
• Advanced working knowledge of SQL is required
• Intermediate knowledge of accounting and finance principles
  • A/R Aging Reports
  • Basic GL knowledge
  • Debit/Credit Memos
• Ability to develop data models, analysis, and visualization for Power BI
• Knowledge of Power BI Gateways
• Analytical skills to identify patterns and trends in data
• Ability to check for consistency and accuracy of data
• Finds satisfaction in analytical review
• Verbal and written communication skills
• Proficiency in Microsoft Excel and VBA
• Critical thinking skills
• Judgment and decision-making skills
• Time management
• Experience in CCH Axcess a plus
• General knowledge of financial software a plus, such a QuickBooks or NetSuite

Job Status: Full Time Salary

Work Location: Orem or Salt Lake City

Work Arrangements: Hybrid for local candidates (3 days in office) or Remote for non-local candidates

Squire Benefits Package

Squire takes pride in offering our benefit-eligible employees a comprehensive benefits package tailored to meet the needs of both individuals and their families. Our benefits program is designed to provide peace of mind and ensure access to quality healthcare, covering 90% of healthcare premium coverage.

Average Annual Benefits Contribution (full-time employees)

Family: 23,200.00

Individual: $11,300.00

• Medical/Dental/Vision Plans
• Robust Health Savings Account Match
• Flexible Spending Account
• 401(k) Match
• Employer Paid Short-Term & Longer-Term Disability
• Employer Paid Group Life Insurance Policy
• Accident Insurance Plans
• Employee Assistance Mental Health Services
• Pet Insurance Plans
• Identify Theft Protection Plans

Squire Perks:

• Squire Culture
• Incentive, Discretionary, and Spot Bonus Structure
• Professional Training
• Tuition Reimbursement (MAcc)
• Philanthropic Activities
• Signature Rewards Program
• Employee Assistance Programs
• Women’s Professional Development
• Fitness Reimbursement
• Paid Time Off & Comp Time
• Health & Wellness Programs

Squire's dedication to excellence and quality work has garnered numerous accolades, including:

• Utah’s Best Company Award – 8 years running
• 2023 Best Accounting Firm to Work For
• 100 Companies Championing Women Award
• Accounting Today’s “Firms to Watch” in 2023
• Worksite Wellness Award 2020-2024