Business Intelligence and Systems Analyst

ORGANIZATION SUMMARY

United Way of Salt Lake (UWSL), part of the Utah’s Promise organization, is changing the way organizations, communities, schools, governments, and individuals work to fix complex social problems. By focusing on removing barriers, improving education, and providing access to basic needs, we can help every child and family thrive. UWSL’s workplace is fast-paced, friendly, adaptive, and grounded in our core values: relationships, continuous improvement, equity, and results.

We offer competitive compensation including a comprehensive benefit package, generous paid time off, and flexible schedules. People with diverse backgrounds and abilities are encouraged to apply.

Our workplace is fast-paced, friendly, adaptive, and grounded in our core values: relationships, continuous improvement, results, and equity. We offer competitive compensation including a comprehensive benefit package, generous paid time off, and flexible schedules. People with diverse backgrounds and abilities are encouraged to apply.

The Business Intelligence and Systems Analyst supports organizational reporting, business applications, data quality, and the ongoing development of the organization’s enterprise data platform. The position develops and maintains reporting solutions in Salesforce and Power BI, supports approved Salesforce configuration and data processes, and assists with Microsoft Fabric and related data integration activities. The role works closely with business stakeholders, the Senior Systems Administrator, and the Senior Director of Data Operations to improve reporting reliability, strengthen system usability, and support consistent data practices across departments.

This position works within established technical, security, and data governance standards and does not serve as the organization’s primary system architect, data engineer, or IT support function.

Ensure organizational data and reporting systems are accurate, usable, and trusted by developing and maintaining reporting solutions, supporting business system configuration, and assisting with data quality and enterprise data platform activities.

• Design, develop, and maintain operational reports, visualizations, and dashboards in Salesforce and Power BI.
• Maintain existing Salesforce reports and dashboards and support the planned transition of appropriate reporting solutions to Power BI over time.
• Connect approved data sources to Power BI and create data transformations, relationships, calculations, and visualizations appropriate to the reporting need.
• Validate report outputs and investigate discrepancies between reported and source data.
• Implement approved metric definitions and document report logic, calculations, filters, assumptions, and data sources.
• Support recurring analysis, including year-over-year comparisons, revenue analysis, campaign performance, and forecasting using approved methodologies.
• Present reporting findings and explain data results to technical and nontechnical stakeholders.
• Identify trends and use data to evaluate and improve strategies.

• Support day-to-day Salesforce administration, including duplicate record management, campaign maintenance, page layouts, picklists, approval processes, and other approved configuration changes.
• Configure and test routine Salesforce changes in Sandbox environments and support user acceptance testing and production release processes under established change-management standards.
• Build and maintain Salesforce reports, dashboards, campaigns, lists, and related data processes.
• Support Pardot or similar email marketing processes, including audience segmentation, list development, and suppression-list management, including direct mail lists for appeal and stewardship mailings such as holiday cards.
• Support Wealth Engine or similar prospect research tools, donor screening activities, prospect pipelines, and approved record assignments.
• Translate approved business requirements into system changes, reporting solutions, or documented process improvements.
• Evaluate and support approved…