Business Intelligence and Systems Analyst

Description

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.   

POSITION SUMMARY

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. 

PRIMARY TASK 

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. 

ESSENTIAL FUNCTIONS 

Business Intelligence & Reporting

• 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. 

Salesforce & Business Systems Support 

• 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 Salesforce applications, integrations, automation, relevant software, and system enhancements in coordination with the Senior Systems Administrator, system owners, and vendors. 

Enterprise Data Platform Support 

• Assist with the ongoing development and operation of the organization’s Microsoft Fabric enterprise data platform under established technical and data governance standards. 
• Support data extraction, transformation, loading, validation, and reconciliation activities for approved data sources and reporting use cases. 
• Use basic SQL and available query tools to retrieve, validate, reconcile, and troubleshoot data. 
• Support testing and monitoring of data pipelines, refreshes, lakehouse or warehouse data, semantic models, and reporting outputs. 
• Document data flows, source-to-target mappings, refresh schedules, dependencies, and recurring data processes. 
• Participate in testing and validation activities related to system integrations, migrations, and data exchanges. 
• Use or learn version-control practices, including Git and GitHub, as the organization adopts these tools for analytics and data platform development. 

Process Improvement & Documentation

• Conduct structured requirements gathering with internal stakeholders and document business, reporting, and system needs. 
• Map workflows and identify opportunities to improve alignment between operational processes, system behavior, and reporting outputs. 
• Organize assigned work through sprint boards or other project-management tools and communicate progress, dependencies, risks, and follow-up actions. 
• Assist with rollout, adoption, and post-implementation support for approved process, system, and reporting changes. 
• Develop and maintain standard operating procedures, system documentation, user guidance, and training materials. 
• Help users understand system workflows, reporting practices, data definitions, and consistent data-entry expectations. 

Data Quality & Governance Support

• Monitor data integrity and identify recurring patterns of inconsistency, duplication, incomplete data, or other data quality risks. 
• Perform data validation and reconciliation during integrations, migrations, report development, and data platform activities. 
• Help trace data from source systems through transformations and reporting outputs. 
• Support consistent field usage, metric implementation, documentation, and data handling practices. 
• Collaborate with business data owners, technical teams, and data governance leadership to identify root causes and support corrective actions. 
• Participate in the documentation and application of data definitions, access standards, security requirements, and governance practices. 

Other duties as assigned.

Requirements

REQUIRED COMPETENCIES

• Proactive, forward-thinking, and self-motivated. 
• Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.  
• Plans and prioritizes work to meet commitments aligned with organizational goals.  
• Holds self and others accountable to meeting commitments.  
• Gains the confidence and trust of others through honesty, integrity, reliability, and authenticity. 
• Defines and owns a project’s scope, resource requirements, dependencies, steps, and timelines.   
• Ability to develop reporting and other skills in team members to help them extract, understand, and use data from Salesforce/data systems.   
• Ability to design and test solutions that meet user needs in long-term and consistent ways; look for solutions of the root cause, not the symptom.  
• Has the confidence and humility to ask questions, admit to and address challenges, “fail forward,” and learn and test continuous improvement tools and techniques.   
• Ability to write and speak with diverse stakeholders: discuss data topics in ways that are appropriate to the audience.   
• Ability to take initiative and operate effectively, even when things are not certain, when conditions are shifting, or the way forward is not clear.   

QUALIFICATIONS 

• Three or more years of relevant experience in business intelligence, Salesforce or CRM administration, reporting, data analysis, business systems support, or a related field. 
• Hands-on experience with Salesforce or a comparable CRM, including reporting, dashboards, data management, and routine system configuration. 
• Experience developing reports and dashboards in Power BI, Salesforce, Tableau, or a comparable data visualization tool; Power BI experience strongly preferred. 
• Working knowledge of SQL for querying, joining, filtering, aggregating, and validating data. 
• Experience with Excel, including organizing, analyzing, reconciling, and presenting data. 
• Experience gathering requirements, documenting processes, and supporting cross-department operational or system improvements. 
• Bachelor’s degree in information systems, data analytics, business administration, computer science, or a related field, or an equivalent combination of relevant professional experience, education, certifications, and training. 
• Experience with Microsoft Fabric, OneLake, Power Query, DAX, data pipelines, semantic models, or a comparable cloud data platform preferred. 
• Familiarity with data warehouses, data lakes, lakehouses, dimensional modeling, and ETL or ELT concepts preferred. 
• Familiarity with Git, GitHub, or other version-control tools preferred. 
• Experience with Salesforce Sandbox, Pardot or Marketing Cloud Account Engagement, Wealth Engine, fundraising operations, donor lifecycle, or nonprofit development practices preferred. 
• Familiarity with APIs, JSON, CSV-based data exchange, data governance, security, access controls, or data lineage preferred. 

PHYSICAL REQUIREMENTS  

The employee regularly communicates with internal and external stakeholders and is required to communicate clearly, in oral and written formats, and must be able to exchange accurate information. The employee must be able to transcribe, read extensively, prepare and analyze data and figures, operate a computer and other standard office machinery. The employee is required to work primarily from UWSL during core business hours.   

COMPENSATION & BENEFITS   

The position is a full-time, exempt position with full benefits. $74,500-91,000. Salary commensurate with experience. UWSL/UP provides a wide range of benefits, including: 

• Competitive medical, dental, vision insurance • 6% retirement match • Life, accidental death, and long & short-term disability insurance • FSA • HSA contribution • Free on-site gym & bike storage • Paid parking or public transportation subsidy • Two weeks paid office closure (December & July) • Generous PTO & Health time • Paid parental leave • Onsite coffee shop & café • Paid time to volunteer