Sr. Business Intelligence Developer

Job Posting Title: Sr. Business Intelligence Developer ---- Hiring Department: University Development Office ---- Position Open To: All Applicants ---- Weekly Scheduled Hours: 40 ---- FLSA Status: Exempt ---- Earliest Start Date: Apr 18, 2022 ---- Position Duration: Expected to Continue ---- Location: UT MAIN CAMPUS ---- Job Description: Reporting to the Director of Data Management, the Sr. BI Developer will lead actionable business intelligence and data analytics solutions within the University Development Office for both the office and larger campus community as assigned. This role will focus on annual giving programs campaigns and advanced analytics. ---- Job Details: General Notes About UT Austin The University of Texas at Austin, founded in 1883, ranks among the 40 best universities in the world with top national programs across 18 colleges and schools. The university is an enduring symbol of the spirit of Texas, driving economic and social progress while serving the city, state, nation and world as a leading center of knowledge and creativity. Our work is inspired by the bold spirit of Texas and our commitment to its people. Learn more about UT Austin’s mission and values, leadership and strategic plan. Why Join Texas Development? What starts here changes the world. What starts here starts with you. The University of Texas at Austin is on the front lines of the future: sparking the imagination, driving discovery and transforming lives. And it’s only possible because generous supporters believe in the power and promise of our state’s flagship university to change the world. We strive to reach the highest levels of achievement and success in all that we do by creating meaningful and powerful experiences for our donors. Together, through one of the largest fundraising efforts in our state’s history, we will unlock student potential, recruit world-class faculty, transform health and care, and create a vibrant future for Texas and beyond. With more than $3 billion raised in the past five years, Texas Development is quickly becoming one of the best fundraising programs in higher education. Texas Development is a dynamic and growing community of more than 400 team members across the Forty Acres. Like the university we serve, we are committed to promoting a culture of diversity, equity, inclusion and belonging along our staff and donor communities. We honor the idea that if what starts here changes the world, what starts here should reflect the world. Join us and change the world. Responsibilities Lead BI developer delivering quantitative and qualitative analyses on a broad array of issues to inform strategic decision making for Annual Giving team Establish key metrics, create review cycle, and provide insights on donor and prospect intelligence Uses strong understanding of program audience segmentation to drive growth Partner with creative and campaign teams to optimize content Develop and deliver reporting and analytics solutions designed to translate data into actionable business intelligence. Work with other analysts/developers to consult with stakeholders to determine reporting needs and define reporting solutions to meet requirements Identify, retrieve, query, and append data from internal databases and external data sources in support of reporting and analytics operations (i.e., complex queries for list generation) Cultivate and maintain expertise on University of Texas alumni and donor data Validate, enhance and trouble shoot reports. Fulfilling ad hoc data requests as needed Other duties as assigned Required Qualifications Bachelor’s degree. Three years of SQL development. Two years of Python development. Three years working with relational databases. Two years of professional experience working as a marketing analyst, data analyst, or business intelligence analyst/developer. Two years of working with BI reporting tools such as Tableau, Cognos, or PowerBI. One years developing reports against APIs. Advanced Excel expertise. Comfort working with unstructured data. Demonstrable experience with data security. Familiarity with fundraising and development terminology and related business processes. Familiarity with annual giving fundraising analytics, campaigns, metrics and KPI’s. Must be authorized to work in the United States. Attention to detail and excellent written and oral communication skills. Demonstrated understanding of email marketing best practices. Experience with A/B test plan methodologies and reporting. Ability to shift priorities quickly, without losing track of projects. Ability to work collaboratively with data management and annual giving team. Aptitude at acquiring business knowledge and translating business needs. Practitioner of quality assurance and testing methodologies. Relevant education and experience may be substituted as appropriate. Preferred Qualifications Advanced expertise in python and SQL programming. Five years of professional experience working as a marketing analyst, data analyst, business analyst, or application developer. Experience with campaign management tools such as Oracle Eloqua. Salary Range $85,000 Working Conditions Hybrid work environment. Required Materials Resume/CV 3 work references with their contact information; at least one reference should be from a supervisor Letter of interest Important for applicants who are NOT current university employees or contingent workers: You will be prompted to submit your resume the first time you apply, then you will be provided an option to upload a new Resume for subsequent applications. Any additional Required Materials (letter of interest, references, etc.) will be uploaded in the Application Questions section; you will be able to multi-select additional files. Before submitting your online job application, ensure that ALL Required Materials have been uploaded. Once your job application has been submitted, you cannot make changes. Important for Current university employees and contingent workers: As a current university employee or contingent worker, you MUST apply within Workday by searching for Find UT Jobs. If you are a current University employee, log-in to Workday, navigate to your Worker Profile, click the Career link in the left hand navigation menu and then update the sections in your Professional Profile before you apply. This information will be pulled in to your application. The application is one page and you will be prompted to upload your resume. In addition, you must respond to the application questions presented to upload any additional Required Materials (letter of interest, references, etc.) that were noted above. ---- Employment Eligibility: Regular staff who have been employed in their current position for the last six continuous months are eligible for openings being recruited for through University-Wide or Open Recruiting, to include both promotional opportunities and lateral transfers. Staff who are promotion/transfer eligible may apply for positions without supervisor approval. ---- Retirement Plan Eligibility: The retirement plan for this position is Teacher Retirement System of Texas (TRS), subject to the position being at least 20 hours per week and at least 135 days in length. ---- Background Checks: A criminal history background check will be required for finalist(s) under consideration for this position. ---- Equal Opportunity Employer: The University of Texas at Austin, as an equal opportunity/affirmative action employer, complies with all applicable federal and state laws regarding nondiscrimination and affirmative action. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, national origin, age, marital status, sex, sexual orientation, gender identity, gender expression, disability, religion, or veteran status in employment, educational programs and activities, and admissions. ---- Pay Transparency: The University of Texas at Austin will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. ---- Employment Eligibility Verification: If hired, you will be required to complete the federal Employment Eligibility Verification I-9 form. You will be required to present acceptable and original documents to prove your identity and authorization to work in the United States. Documents need to be presented no later than the third day of employment. Failure to do so will result in loss of employment at the university. ---- E-Verify: The University of Texas at Austin use E-Verify to check the work authorization of all new hires effective May 2015. The university’s company ID number for purposes of E-Verify is 854197. For more information about E-Verify, please see the following: E-Verify Poster (English) [PDF] E-Verify Poster (Spanish) [PDF] Right To Work Poster (English) [PDF] Right To Work Poster (Spanish) [PDF] ---- Compliance: Employees may be required to report violations of law under Title IX and the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act). If this position is identified a Campus Security Authority (Clery Act), you will be notified and provided resources for reporting. Responsible employees under Title IX are defined and outlined in HOP-3031. The Clery Act requires all prospective employees be notified of the availability of the Annual Security and Fire Safety report. You may access the 2021 report here or obtain a copy at University Compliance Services, 1616 Guadalupe, Suite UTA 2.206, Austin, TX 78701.

Salary : $3 - $85,000