Senior Programmer & Dashboard Developer

THE UNIVERSITY OF CONNECTICUT FOUNDATION INC • Mansfield, CT

1d • $100,000

About The Position

The University of Connecticut is a top-ranked national university and health system with its flagship campus located in idyllic Storrs. Designated a Carnegie Research 1 institution, UConn is the state land- and sea-grant university focused on education, research, and service to the state of Connecticut and beyond. The University serves over 33,000 students — 8,550 of them first in family — across seven campuses, with a legacy of national championships. UConn Health is a top-ranked health provider that delivers groundbreaking medical education, research, and hospital and clinical services to over one million patients each year. In addition, UConn has nearly 300 scientists who are in the top 2 percent of researchers globally advancing discoveries in fields ranging from cancer to AI. UConn continues its meteoric rise as a top public university with a record number of applications, continued investment in student success, health, and wellness, recruitment of top faculty, innovation in research, and top-tier athletic programs focused on the holistic success of student-athletes. UConn is proud to have 26 national championships across all sports. This includes the men’s and women’s basketball teams, which have brought home three consecutive NCAA National Championship trophies in the last three years. Guided by the public launch of our most ambitious campaign in history, Because of UConn: The Campaign for UConn Nation, we are moving boldly into the future. The $1.5B comprehensive campaign spans all schools, colleges, campuses, and UConn Health, focusing on four pillars designed to make education more affordable and elevate UConn among its national peers: Students First: making transformative investments in financial aid, student health, career readiness, and life skills to improve time-to-degree and career outcomes. Academic & Innovation Excellence: driving investment in top faculty and graduate fellows and building the innovation ecosystem of the state and beyond. Health & Wellness of People & Planet: focusing on patient care, medical research, and development of life-changing technologies that improve healthcare outcomes. Husky Pride: investing in athletic excellence and supporting a thriving UConn Nation that includes more than 290,000 alumni worldwide. The campaign will have a profound impact on the University, doubling the number of named scholarships, funding scientific breakthroughs and advanced lifesaving therapies, and engaging UConn Nation in the life and mission of the University like never before. We seek the top talent in the country to join The UConn Foundation and help us drive our mission to connect people to the University of Connecticut, growing philanthropy, engaging a thriving alumni and donor community, and building a robust endowment to strategically advance UConn and UConn Health’s educational, research, and service missions. We are committed to a caring and supportive work culture, professional and leadership development, and flexibility for high achievers with a passion for higher education. We’re looking for dedicated professionals to drive success and excellence and exemplify our values of Purpose, Excellence, Culture, Communication, and Integrity. The UConn Foundation is an equal opportunity, affirmative action employer. We celebrate different perspectives and are committed to a welcoming environment that values your unique experiences and identity. As an organization, we strive for continued growth each and every day. The Senior Programmer & Dashboard Developer (SPDD) is the Foundation’s primary technical resource for developing reports and dashboards related to the Foundation’s CRM system. Related duties will include TSQL work on ETL processes supporting dashboard development, creating necessary stored procedures and other related database objects. In addition to report and dashboard work, the SPDD will respond to end-user data requests using TSQL to pull together result sets that are difficult or impossible for users or analysts to pull using the embedded query tool in the CRM system. This position requires strong customer service skills related to end-user interactions. The SPDD also works to continuously improve the data quality and integrity within the CRM database system.

Requirements

• Bachelor’s degree required.
• Demonstrated proficiency in dashboard development, preferably with Power BI.
• 3+ years of experience with SQL programming.
• Champion for inclusive priorities both internally and externally.
• Proficiency with: Development of dashboard visualizations (Power BI preferred) ETL design and deployment SQL (stored procedures, query optimization)
• High level of motivation, as well as an ability to exercise independent judgment.
• The ability to build productive, beneficial relationships with a broad range of constituencies.
• Strong interpersonal skills, tact, and diplomacy
• High level of motivation, as well as an ability to exercise independent judgment.
• Analytical thinker with strong attention to detail.
• Attention to and concern for others.
• Ability to work to the demands of the position, which may exceed a 40-hour work week.

Nice To Haves

• Experience with Azure DevOps or similar source control preferred.

Responsibilities

• Design, build, and maintain Power BI dashboards visualizing fundraising performance, campaign progress, donor pipelines, alumni engagement, and other advancement KPIs. Work product must meet user defined requirements and internal specifications, be optimized for performance, and adhere to departmental standards.
• Optimize Power BI datasets for performance, usability, and accuracy. Utilize DAX to enhance dataset transformation into actionable visualizations.
• Maintain and document Power BI workspaces and apps, service settings, deployment, permissions, data refresh schedules, and related security.
• Develop and maintain optimized TSQL queries and stored procedures, and integrate them into system processes, as appropriate, for the following: ETL data import and modification processes; data integrity processes and initiatives; business intelligence and analysis initiatives; and other database programming as assigned.
• Create custom components using Blackbaud SDK to meet the business needs of the Foundation.
• Collaborate with Foundation and University colleagues to identify and document end user requirements for new dashboard development.
• Contribute to the overall productivity and efficiency of the Division/Department’s development staff, by meeting or exceeding goals in a metrics-driven environment.
• Model and articulate the Foundation’s organizational core values at all times.
• Perform other duties as assigned.
• Provide visible leadership across the entire organization by engaging in organization-wide activities such as department meetings, all-staff meetings, and staff events.

Benefits

• Benefits start from day one. We offer medical, dental, and vision plans and will make an annual contribution to your health savings account if enrolled in one of the high-deductible health plans offered by the Foundation.
• We offer a generous contribution to your 403(b) retirement plan to help you plan for retirement.
• We place an emphasis on work/life balance. In addition to a hybrid schedule, you will receive thirteen paid holidays, five weeks of paid time off per calendar year, and additional sick time.
• We invest in your professional development. Aside from opportunities to participate in various trainings, committees, and conferences throughout the year, you will also be eligible for tuition reimbursement after one year of employment.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level