Senior Business Intelligence Analyst in Development for Salesforce

Location: Texas Medical Center-Houston, Texas

Hot

Category: Accounting/Finance

UTHealth Houston General Administration

Requisition #: 240002D2

Position Summary:

UTHealth Houston’s Office of Development and Public Affairs is looking for a Senior Business Intelligence Analyst who will primarily support the administration of the Salesforce constituent database, Affinaquest. This role will serve as the primary programmer and system admin that supports the development and maintenance of Affinaquest, the SQL reporting instance, and the SQL patient database. You will need to apply a user-centered approach to transform raw data into meaningful and valuable information, enabling more effective, strategic, tactical, and operational insight and decision-making to support the department’s fundraising and brand elevation goals.

This employee functions as both a programmer and system administrator and needs to be able to design custom application programming interfaces and pull data reports. You will be automating some processes using SQL and SOQL alternatively. We use Salesforce, and you should have experience with that or other cloud-based CRM’s that are relational. A background of working with a non-profit, medical organization, or an institute of higher learning will be an asset.

What we do here changes the world. UTHealth Houston is Texas’ resource for healthcare education, innovation, scientific discovery, and excellence in patient care. That’s where you come in.

Once you join us, you won't want to leave. It’s because we reward our team for the excellent service they provide. Our total rewards package includes the benefits you’d expect from a top healthcare organization (benefits, insurance, etc.), plus:

• 100% paid medical premiums for our full-time employees

• Generous time off (holidays, preventative leave days, both vacation and sick time – all of which equates to around 37-38 days per year)

• The longer you stay, the more vacation you’ll accrue!

• Longevity Pay (Monthly payments after two years of service)

• Build your future with our awesome retirement/pension plan!

We take care of our employees! As a world-renowned institution, our employees’ well-being is important to us. We offer work/life services such as...

• Free financial and legal counseling

• Free mental health counseling services

• Gym membership discounts and access to wellness programs

• Other employee discounts include entertainment, car rentals, cell phones, etc.

• Resources for child and elder care

• Plus, many more!

Position Key Accountabilities:

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

• Performs other duties as assigned.

Certification/Skills:

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

Minimum Education:

At least a bachelor’s degree in science, business, or a related field is required.

Minimum Experience:

Five (5) years of system administration experience in a Customer Relationship Management system similar to Salesforce is required.

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

Physical Requirements:

Exerts up to 20 pounds of force occasionally, up to 10 pounds frequently, and a negligible amount constantly to move objects.

Security Sensitive:

This job class may contain positions that are security sensitive and thereby subject to the provisions of Texas Education Code § 51.215

Residency Requirement:

Employees must permanently reside and work in the State of Texas. This role will be on a hybrid working schedule in the office, alternating with optional remote days.

If you are looking for a great healthcare career in Houston, visithttp://go.uth.edu/careers!

University of Texas Health Science Center at Houston (UTHealth)

Established in 1972 by The University of Texas System Board of Regents, The University of Texas Health Science Center at Houston (UTHealth) is Houston’s Health University and Texas’ resource for health care education, innovation, scientific discovery and excellence in patient care. The most comprehensive academic health center in the UT System and the U.S. Gulf Coast region, UTHealth Houston is home to schools of biomedical informatics, biomedical sciences, dentistry, nursing and public health and the John P. and Kathrine G. McGovern Medical School. UTHealth Houston includes The University of Texas Harris County Psychiatric Center, as well as the growing clinical practices UT Physicians, UT Dentists and UT Health Services. The university’s primary teaching hospitals are Memorial Hermann-Texas Medical Center, Children’s Memorial Hermann Hospital and Harris Health Lyndon B. Johnson Hospital.

UTHealth Benefits

UTHealth Houston offers a comprehensive and competitive benefits package. For more information on our benefits programs please refer to the UTHealth Houston Office of Benefits Website.

https://www.uth.edu/benefits/

Equal Employment Opportunity Statement

UTHealth Houston is committed to providing equal opportunity in all employment-related activities without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, genetic information, gender identity or expression, veteran status or any other basis prohibited by law or university policy. Reasonable accommodation, based on disability or religious observances, will be considered in accordance with applicable law and UTHealth Houston policy. The University maintains affirmative action programs with respect to women, minorities, individuals with disabilities, and eligible veterans in accordance with applicable law.

UTHealthHoustonhas adopted a policy consistent with CMS regulations to protect our patients and university community from exposure to COVID-19. This policy affects all employees, residents, fellows, students, contractors, new hires, visiting scholars program participants, adjunct faculty, and volunteers who work, train, or collaborate at the John S. Dunn Behavioral Science Center.

In addition, all UTHealthHouston​​​​​​​employees who are assigned to work at a location that is subject to the affiliated partner’s hospital, clinical offices, or agency are required to abide by UTHealth’sHoustonrules and regulations, as well as the affiliate’s rules and regulations, including COVID-19 vaccination and safety requirements.

Work location is based on the needs of the department and may be adjusted.