Senior Business Intelligence Analyst in Development for Salesforce - 240002D2

$53,000 - $110,000/Yr

UT Health - Houston, TX

Full-time - Mid Level

Onsite - Houston, TX

Educational Services

About the position

The Senior Business Intelligence Analyst at UTHealth Houston's Office of Development and Public Affairs is responsible for managing and enhancing the Salesforce constituent database, Affinaquest. This role combines programming and system administration to transform raw data into actionable insights that support fundraising and brand elevation goals. The analyst will automate processes, design custom APIs, and ensure data integrity while collaborating with various stakeholders to deliver effective solutions.

Responsibilities

• Manage the ongoing configuration and enhancement of the Affinaquest/Salesforce Org and managed packages.
• Design and implement data integrity strategy, including custom fields, objects, triggers, and workflows.
• Develop and maintain SQL processes to enable the extraction of valuable insights from our data.
• Manage the data flow from Salesforce to the internal reporting instance.
• Maintain, revise, and update current code or configuration, including troubleshooting, fixing bugs, and improving system functionality.
• Streamline and optimize processes related to patient data.
• Collaborate with stakeholders and internal teams to identify requirements and design best practice solutions.
• Assist in system updates, upgrades, and migrations for existing and new applications and systems.
• Work closely with internal teams to ensure seamless integrations and data flow.
• Work with vendors and end users to troubleshoot applications, upgrades, and new solutions/implementations and manage user accounts, security settings, and access permissions.
• Perform other duties as assigned.

Requirements

• Bachelor's degree in science, business, or a related field.
• Five years of system administration experience in a CRM system similar to Salesforce.
• Salesforce Administration Certification (preferred).
• Experience defining metrics, dimensions, and KPIs on Business Intelligence projects.
• Proficient in Microsoft Excel and Access.
• Strong critical thinking, analytic, and problem-solving skills.
• Ability to work independently and effectively with prudent judgment and discretion.
• Experience with SQL database reporting tools.
• Experience in working with large volumes of data (preferred).
• Strong knowledge of custom objects, process builders, workflows, apex triggers, validation rules, tags, etc.
• Proficiency in automating data and manual processes via Python, R, SOQL, SQL, Apex, or other data analysis languages.
• Proficient in reporting via SSIS, SSRS, Power BI, and Tableau.
• API and integration knowledge.

Nice-to-haves

• Experience in an academic, research, healthcare, non-profit, or fundraising environment.

Benefits

• 100% paid medical premiums for full-time employees.
• Generous time off (around 37-38 days per year).
• Longevity Pay after two years of service.
• Retirement/pension plan.
• Free financial and legal counseling.
• Free mental health counseling services.
• Gym membership discounts and access to wellness programs.
• Employee discounts on entertainment, car rentals, cell phones, etc.
• Resources for child and elder care.