Position Overview
The Data Analyst will work directly with TruNorthe’s current analysis team to assist in building and maintaining data models using Excel. This is a high-visibility position with opportunities for advancement and the potential to make a strong, positive impact across multiple departments. The Data Analyst will play a critical role in supporting data-driven decision-making, improving reporting accuracy, and enhancing the efficiency of operational processes and analytics across the organization.
Key Responsibilities
· Build and maintain Excel models (Trackers) that serve as the primary source of market- and project-specific data.
· Ensure models are built consistently across similar markets/projects and are efficiently integrated with TruNorthe’s proprietary systems and reporting tools.
· Develop and automate Power BI dashboards to visualize key metrics and performance trends.
· Participate in the budgeting and forecasting process by assisting with the formulation and collection of key assumptions, preparing market-level budgets and forecasts, and analyzing results.
· Compile key operating metrics on a historical and projected basis to support management decision-making.
· Analyze, organize, and improve data flow between models, reports, and systems using logical database modeling concepts and relational database management principles.
· Coordinate and collaborate with Market Leads, the Operations team, and clients to understand business objectives, validate data accuracy, and communicate analytical results.
· Drive process improvements by optimizing model design, reporting workflows, and data validation processes.
· Support automation initiatives and continuous enhancements to Excel and Power BI tools.
· Provide actionable insights to leadership through clear reporting and presentations.
Expectations & Work Environment
· This role is currently hybrid, currently requiring at least three days per week in the office. Work location expectations may change based on business needs.
· The Data Analyst is expected to manage workload independently while maintaining clear and effective communication across teams.
· Demonstrate professionalism, accuracy, and attention to detail in all documentation, reporting, and communications.
· Uphold company policies, contribute to continuous improvement, and support the team with flexibility and initiative.
· Additional responsibilities may be assigned as needed to support project and company success.
Required Qualifications
- Self-motivated and able to learn new systems and processes independently in a fast-paced environment.
- Extremely proficient with Microsoft Excel, VBA, Power BI, and PowerPoint (required).
- Knowledge of logical data modeling concepts and relational database management.
- Experience with SQL, VB, or .NET (optional, but a big plus!).
Education & Experience
- Bachelor’s degree in Finance, Accounting, Computer Science, or a related field.
- Minimum of 3+ years of experience using Excel and Power BI for data modeling, reporting, or analysis.
- Advanced professional certifications such as CPA, CFA, or MBA (optional but preferred).
Job Type: Full-time
Pay: $60,000.00 - $68,000.00 per year
Benefits:
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Referral program
- Vision insurance
Application Question(s):
- Are you willing to undergo a background check?
- Have you previously built or maintained large Excel data models or trackers that integrated data from multiple sources? (Yes/No)
Experience:
- Microsoft Excel: 3 years (Required)
- VBA or macros: 3 years (Required)
- Power BI: 3 years (Required)
- PowerPoint: 3 years (Required)
- Creating reports or dashboards: 1 year (Required)
Location:
- Park City, UT 84060 (Preferred)
Ability to Commute:
- Park City, UT 84060 (Required)
Work Location: Hybrid remote in Park City, UT 84060
