Senior Business Intelligence Analyst in Development for Salesforce

UT Health - Houston, TX

Full-time - Mid Level

Hybrid - Houston, TX

Educational Services

About the position

UTHealth Houston's Office of Development and Public Affairs is seeking a Senior Business Intelligence Analyst to primarily support the administration of the Salesforce constituent database, Affinaquest. This role is crucial as it serves as the primary programmer and system administrator responsible for the development and maintenance of Affinaquest, the SQL reporting instance, and the SQL patient database. The ideal candidate will apply a user-centered approach to transform raw data into meaningful and valuable information, which will enable more effective strategic, tactical, and operational insights and decision-making to support the department's fundraising and brand elevation goals. In this position, the employee will function as both a programmer and system administrator, requiring the ability to design custom application programming interfaces and generate data reports. Automation of processes using SQL and SOQL will be a key responsibility. Familiarity with Salesforce or other cloud-based CRM systems that are relational is essential. A background in working with a non-profit, medical organization, or an institute of higher learning will be considered an asset. At UTHealth Houston, we are committed to changing the world through healthcare education, innovation, scientific discovery, and excellence in patient care. Once you join our team, you will find a rewarding environment that values your contributions. Our total rewards package includes comprehensive benefits, such as 100% paid medical premiums for full-time employees, generous time off (holidays, preventative leave days, vacation, and sick time totaling around 37-38 days per year), and a retirement/pension plan. We prioritize our employees' well-being by offering work/life services, including free financial and legal counseling, mental health counseling services, gym membership discounts, and resources for child and elder care, among other benefits.

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.
• Manage user requests and needs and deliver custom solutions and smooth dataflow.
• 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

• Salesforce Administration Certification is 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 is preferred.
• Strong knowledge of custom objects, process builders, workflows, apex triggers, validation rules, tags, etc.
• Proficiency in and ability to automate 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 (holidays, preventative leave days, vacation, and sick time totaling around 37-38 days per year)
• Longevity Pay (Monthly payments 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 including entertainment, car rentals, cell phones, etc.
• Resources for child and elder care