Business Intelligence Specialist

Summary

About The Role Arcadia Financial Group is a growing independent RIA built around a family office model that integrates financial planning, tax strategy, estate planning, and client service. We believe our clients deserve more than good returns - they deserve clarity, discipline, and a firm that understands their full picture.About The Role Arcadia Financial Group is a growing independent RIA built around a family office model that integrates financial planning, tax strategy, estate planning, and client service. We believe our clients deserve more than good returns - they deserve clarity, discipline, and a firm that understands their full picture. To deliver that, we need great information. Business intelligence isn't about producing reports. It's about helping the firm ask better questions, make better decisions, better serve our clients, and help them fearlessly live every day like it's Saturday. We're looking for someone to help build that capability. Today, information lives across multiple systems. Some reporting is automated. Some still relies on spreadsheets. Some dashboards exist. Others haven't been built yet. We have ambitious ideas around executive dashboards, marketing analytics, operational scorecards, client segmentation, capacity planning, and business intelligence - but we're looking for someone who can help turn those ideas into reality. Very few firms our size have made business intelligence a strategic priority. We're intentionally investing in this capability because we believe the firms that make the best decisions over the next decade will be the ones that know their business best. You'll have the opportunity to help build that capability from the ground up - not simply inherit someone else's reporting environment. ou'll work directly with our Director of Operations and COO to create the reporting environment that helps leadership understand what's happening across the firm, identify opportunities before they become problems, and make better decisions. This role has visibility across every department in the firm. You'll partner with Marketing, Financial Planning, Tax, Client Service, Concierge, and Operations to help leadership understand not just how each department is performing - but how they work together. Because this role supports every department in the firm, you'll work in a highly collaborative environment. Priorities are established by the Director of Operations in partnership with the COO, ensuring your time is focused on the initiatives that will have the greatest impact on the business. This allows you to spend less time reacting to the loudest request and more time delivering meaningful improvements across the firm. This is not an IT role. It is not a systems administration role. It is not a report-running position. It's a role for someone who enjoys helping organizations think more clearly through better information. This role does not define organizational strategy or determine the firm's key performance indicators - leadership establishes the metrics that define success. This role builds the reporting environment that delivers those insights accurately, consistently, and efficiently. As Arcadia's Business Intelligence capabilities mature, this position has the opportunity to evolve into a more analytical role focused on business insights, trend analysis, forecasting, and strategic decision support.Who You Are You enjoy solving business problems with data. When someone asks you for a report, your first instinct isn't to ask what columns they want - it's to ask what decision they're trying to make. You know that dashboards aren't valuable because they're beautiful. They're valuable because they improve judgment. You're equally comfortable sitting with a department director to understand a business challenge as you are working with an outside consultant on Power BI, SQL, or data architecture. You're naturally curious, but you're also practical. You understand that the best reporting often removes work rather than creates it. Most importantly, you take ownership. Not ownership of every project or every request - but ownership of helping the firm make better decisions. You know when to educate someone toward self-service, when to build a new analytical solution, and when to challenge whether a report should exist at all. You think like an operator, not just an analyst. You understand that behind every metric is a business decision, and behind every business decision are real clients, real families, and real outcomes.Specifically, You Think analytically but communicate simplyTranslate messy business questions into meaningful reportingCare deeply about data quality because you know bad data leads to bad decisionsLook for opportunities to automate repetitive workBuild systems that reduce dependency instead of creating itEnjoy continuous improvement rather than maintaining the status quoAre energized by helping an organization become smarter over timeIf you've ever looked at a dashboard and thought, "this answers the wrong question," you'll probably enjoy working here.What You'll Own Business Intelligence Solutions & Reporting Design, develop, maintain, and continuously improve Power BI dashboards and reporting solutions that support operational and executive decision-makingTranslate business requirements into meaningful dashboards, ensuring solutions align with leadership's defined objectives and success metricsMonitor data quality across our systems, identify inconsistencies, and work with departments to improve accuracy and completenessMaintain reporting documentation, dashboard standards, and report logic to promote consistency and long-term usabilityIdentify opportunities to automate recurring reporting and eliminate manual processesContinuously evaluate reporting effectiveness and recommend enhancementsGuiding Principle: When someone asks you for a report, your first instinct isn't to ask what columns they want - it's to ask what decision they're trying to make.Collaboration & Adoption Partner with department leaders to understand operational reporting needs and translate those needs into practical solutionsTrain and educate leaders to confidently access, navigate, interpret, and use dashboards within their areas of responsibilityDevelop user guides, documentation, and training resources that support long-term adoptionPromote consistent use of dashboards in department meetings and leadership discussionsServe as the primary internal resource for reporting best practices and business intelligence educationFoster a culture where leaders increasingly use self-service reporting rather than relying on others for routine informationGuiding Principle: Department leaders remain accountable for their departmental metrics and performance. The Business Intelligence Specialist provides the reporting environment, education, and tools that enable leaders to confidently monitor, understand, and act upon those metrics.Business Intelligence Operations & Continuous Improvement Partner with Arcadia's external Business Intelligence consulting partner — translating requirements, coordinating enhancements, testing solutions, and supporting implementationSupport data quality initiatives by identifying inconsistencies and partnering with departments to improve reporting integrityCollaborate with the Director of Operations to prioritize Business Intelligence initiatives aligned with organizational prioritiesContinuously identify opportunities to improve reporting capabilities, streamline processes, and expand data-driven decision-makingGuiding Principle: Executive Leadership defines the organization's strategy, business objectives, and key performance indicators. The Director of Operations owns the Business Intelligence roadmap and priorities. The external Business Intelligence consulting partner owns technical architecture, integrations, data warehouse, and platform continuity. Department Leaders own the quality of their department's data and validate their own reporting needs. The Business Intelligence Specialist owns execution, the reporting experience, dashboard development, user adoption, and day-to-day enablement of the Business Intelligence function.What Success Looks Like - First Year Leadership relies on live dashboards rather than manually assembled reportsDepartment leaders confidently run routine reporting themselves while turning to you for meaningful analysis - not basic exportsManual reporting has been significantly reduced through automationData quality has improved because departments understand what matters and whyLeadership has greater confidence in the firm's metrics because they're consistent, transparent, and trustedMost importantly, the leadership team spends less time gathering information and more time making decisionsDocumentation, training, and knowledge transfer ensure continuity of the Business Intelligence function regardless of future staffing changesThe Business Intelligence platform continues to evolve through collaboration between leadership, the Business Intelligence Specialist, and Arcadia's external consulting partnerWhat This Role Is Not This is not an IT support positionThis is not a systems administrator roleThis is not someone who exports reports on demand and waits for the next ticketThis is not a passive analystAt Arcadia, we don't believe dashboards exist to satisfy curiosity or produce prettier reports. We believe they exist to improve judgment. The work you do should help leadership ask better questions, identify opportunities sooner, eliminate unnecessary work, and ultimately create a better experience for the families we serve.If you're energized by helping an organization think more clearly - not just report more efficiently - you'll thrive here.Experience & Background 3-5 years of experience in Business Intelligence, reporting, dashboard development, business systems, or data visualizationStrong Power BI experience with the ability to develop and maintain interactive dashboardsWorking knowledge of SQL and advanced ExcelExperience gathering business requirements and translating them into reporting solutionsStrong communication skills with both technical and non-technical audiencesExperience with CRM platforms preferred (Redtail, Salesforce, Wealthbox, or similar)Experience partnering with software vendors or external consulting firms preferredExperience training users, developing documentation, and supporting organizational technology adoptionStrong organizational skills with the ability to manage multiple priorities across departmentsBenefits We believe in taking care of the people who take care of our clients.80-100% employer-paid health, dental, and vision insurance depending on your plan selectionUnlimited paid time off (PTO) and flexible schedulingShort-term disability, long-term disability, and life insurance - fully covered401(k) retirement plan with 4% company matchQuarterly clothing allowanceProfessional development and continuing education opportunitiesCollaborative, people-first culture that values innovation and accountabilityArcadia challenges you to fearlessly live every day like it's Saturday.#J-18808-Ljbffr

Job Description

About The Role Arcadia Financial Group is a growing independent RIA built around a family office model that integrates financial planning, tax strategy, estate planning, and client service. We believe our clients deserve more than good returns - they deserve clarity, discipline, and a firm that understands their full picture.About The Role Arcadia Financial Group is a growing independent RIA built around a family office model that integrates financial planning, tax strategy, estate planning, and client service. We believe our clients deserve more than good returns - they deserve clarity, discipline, and a firm that understands their full picture. To deliver that, we need great information. Business intelligence isn't about producing reports. It's about helping the firm ask better questions, make better decisions, better serve our clients, and help them fearlessly live every day like it's Saturday. We're looking for someone to help build that capability. Today, information lives across multiple systems. Some reporting is automated. Some still relies on spreadsheets. Some dashboards exist. Others haven't been built yet. We have ambitious ideas around executive dashboards, marketing analytics, operational scorecards, client segmentation, capacity planning, and business intelligence - but we're looking for someone who can help turn those ideas into reality. Very few firms our size have made business intelligence a strategic priority. We're intentionally investing in this capability because we believe the firms that make the best decisions over the next decade will be the ones that know their business best. You'll have the opportunity to help build that capability from the ground up - not simply inherit someone else's reporting environment. ou'll work directly with our Director of Operations and COO to create the reporting environment that helps leadership understand what's happening across the firm, identify opportunities before they become problems, and make better decisions. This role has visibility across every department in the firm. You'll partner with Marketing, Financial Planning, Tax, Client Service, Concierge, and Operations to help leadership understand not just how each department is performing - but how they work together. Because this role supports every department in the firm, you'll work in a highly collaborative environment. Priorities are established by the Director of Operations in partnership with the COO, ensuring your time is focused on the initiatives that will have the greatest impact on the business. This allows you to spend less time reacting to the loudest request and more time delivering meaningful improvements across the firm. This is not an IT role. It is not a systems administration role. It is not a report-running position. It's a role for someone who enjoys helping organizations think more clearly through better information. This role does not define organizational strategy or determine the firm's key performance indicators - leadership establishes the metrics that define success. This role builds the reporting environment that delivers those insights accurately, consistently, and efficiently. As Arcadia's Business Intelligence capabilities mature, this position has the opportunity to evolve into a more analytical role focused on business insights, trend analysis, forecasting, and strategic decision support.Who You Are You enjoy solving business problems with data. When someone asks you for a report, your first instinct isn't to ask what columns they want - it's to ask what decision they're trying to make. You know that dashboards aren't valuable because they're beautiful. They're valuable because they improve judgment. You're equally comfortable sitting with a department director to understand a business challenge as you are working with an outside consultant on Power BI, SQL, or data architecture. You're naturally curious, but you're also practical. You understand that the best reporting often removes work rather than creates it. Most importantly, you take ownership. Not ownership of every project or every request - but ownership of helping the firm make better decisions. You know when to educate someone toward self-service, when to build a new analytical solution, and when to challenge whether a report should exist at all. You think like an operator, not just an analyst. You understand that behind every metric is a business decision, and behind every business decision are real clients, real families, and real outcomes.Specifically, You Think analytically but communicate simplyTranslate messy business questions into meaningful reportingCare deeply about data quality because you know bad data leads to bad decisionsLook for opportunities to automate repetitive workBuild systems that reduce dependency instead of creating itEnjoy continuous improvement rather than maintaining the status quoAre energized by helping an organization become smarter over timeIf you've ever looked at a dashboard and thought, "this answers the wrong question," you'll probably enjoy working here.What You'll Own Business Intelligence Solutions & Reporting Design, develop, maintain, and continuously improve Power BI dashboards and reporting solutions that support operational and executive decision-makingTranslate business requirements into meaningful dashboards, ensuring solutions align with leadership's defined objectives and success metricsMonitor data quality across our systems, identify inconsistencies, and work with departments to improve accuracy and completenessMaintain reporting documentation, dashboard standards, and report logic to promote consistency and long-term usabilityIdentify opportunities to automate recurring reporting and eliminate manual processesContinuously evaluate reporting effectiveness and recommend enhancementsGuiding Principle: When someone asks you for a report, your first instinct isn't to ask what columns they want - it's to ask what decision they're trying to make.Collaboration & Adoption Partner with department leaders to understand operational reporting needs and translate those needs into practical solutionsTrain and educate leaders to confidently access, navigate, interpret, and use dashboards within their areas of responsibilityDevelop user guides, documentation, and training resources that support long-term adoptionPromote consistent use of dashboards in department meetings and leadership discussionsServe as the primary internal resource for reporting best practices and business intelligence educationFoster a culture where leaders increasingly use self-service reporting rather than relying on others for routine informationGuiding Principle: Department leaders remain accountable for their departmental metrics and performance. The Business Intelligence Specialist provides the reporting environment, education, and tools that enable leaders to confidently monitor, understand, and act upon those metrics.Business Intelligence Operations & Continuous Improvement Partner with Arcadia's external Business Intelligence consulting partner — translating requirements, coordinating enhancements, testing solutions, and supporting implementationSupport data quality initiatives by identifying inconsistencies and partnering with departments to improve reporting integrityCollaborate with the Director of Operations to prioritize Business Intelligence initiatives aligned with organizational prioritiesContinuously identify opportunities to improve reporting capabilities, streamline processes, and expand data-driven decision-makingGuiding Principle: Executive Leadership defines the organization's strategy, business objectives, and key performance indicators. The Director of Operations owns the Business Intelligence roadmap and priorities. The external Business Intelligence consulting partner owns technical architecture, integrations, data warehouse, and platform continuity. Department Leaders own the quality of their department's data and validate their own reporting needs. The Business Intelligence Specialist owns execution, the reporting experience, dashboard development, user adoption, and day-to-day enablement of the Business Intelligence function.What Success Looks Like - First Year Leadership relies on live dashboards rather than manually assembled reportsDepartment leaders confidently run routine reporting themselves while turning to you for meaningful analysis - not basic exportsManual reporting has been significantly reduced through automationData quality has improved because departments understand what matters and whyLeadership has greater confidence in the firm's metrics because they're consistent, transparent, and trustedMost importantly, the leadership team spends less time gathering information and more time making decisionsDocumentation, training, and knowledge transfer ensure continuity of the Business Intelligence function regardless of future staffing changesThe Business Intelligence platform continues to evolve through collaboration between leadership, the Business Intelligence Specialist, and Arcadia's external consulting partnerWhat This Role Is Not This is not an IT support positionThis is not a systems administrator roleThis is not someone who exports reports on demand and waits for the next ticketThis is not a passive analystAt Arcadia, we don't believe dashboards exist to satisfy curiosity or produce prettier reports. We believe they exist to improve judgment. The work you do should help leadership ask better questions, identify opportunities sooner, eliminate unnecessary work, and ultimately create a better experience for the families we serve.If you're energized by helping an organization think more clearly - not just report more efficiently - you'll thrive here.Experience & Background 3-5 years of experience in Business Intelligence, reporting, dashboard development, business systems, or data visualizationStrong Power BI experience with the ability to develop and maintain interactive dashboardsWorking knowledge of SQL and advanced ExcelExperience gathering business requirements and translating them into reporting solutionsStrong communication skills with both technical and non-technical audiencesExperience with CRM platforms preferred (Redtail, Salesforce, Wealthbox, or similar)Experience partnering with software vendors or external consulting firms preferredExperience training users, developing documentation, and supporting organizational technology adoptionStrong organizational skills with the ability to manage multiple priorities across departmentsBenefits We believe in taking care of the people who take care of our clients.80-100% employer-paid health, dental, and vision insurance depending on your plan selectionUnlimited paid time off (PTO) and flexible schedulingShort-term disability, long-term disability, and life insurance - fully covered401(k) retirement plan with 4% company matchQuarterly clothing allowanceProfessional development and continuing education opportunitiesCollaborative, people-first culture that values innovation and accountabilityArcadia challenges you to fearlessly live every day like it's Saturday.#J-18808-Ljbffr