Senior Software Engineer

Overview The South Dakota Board of Regents – Regents Information Systems is seeking a highly skilled Senior Software Engineer with deep experience developing on enterprise SQL platforms and supporting analytical systems. The successful candidate will play a key role in designing, developing, and maintaining data-driven solutions that support a data warehouse or data lake environment. Experience with dimensional modeling and business intelligence tools—particularly IBM Cognos—is highly valued. This position is physically located in Sioux Falls, SD and is NOT a remote position. Must be authorized to work in the U.S. Sponsorship is not available for this position. Key Responsibilities Design, develop, optimize, and maintain complex SQL-based solutions using Oracle, Microsoft SQL Server, and/or PostgreSQL Lead development efforts to support reporting from data warehouse or data lake platforms Develop and support SQL-based transformations, stored procedures, views, and performance tuning strategies Collaborate with architects, analysts, and stakeholders to translate business requirements into technical solutions Develop and support analytics and reporting solutions using Cognos Analytics, Cognos Framework Manager, PowerBI or Tableau Ensure data integrity, performance, and reliability Document technical designs and processes Preferred Qualifications Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience) 7+ years of professional software or database development experience Extensive experience with Oracle, Microsoft SQL Server, or PostgreSQL Strong SQL skills with performance tuning experience Experience supporting a data warehouse or data lake and development of ETLs to support data transfers. Strong communication and problem-solving skills Working knowledge of Cognos Analytics and Cognos Framework Manager Experience with dimensional data modeling Experience in regulated or enterprise-scale environments Working knowledge of web services APIs Higher Education system experience a plus Prior experience with Ellucian Banner systems (technical/administrative) Excellent verbal and written communication skills to deal with a wide variety of users and peers. The South Dakota Board of Regents is an Equal Opportunity Employer. The Board of Regents will take affirmative action to ensure that all employment practices are free of discrimination. Arrangements for accommodations required by disabilities can be made by contacting the appropriate Human Resources office. Please see the Contact Us section of this webpage for more information. South Dakota Board of Regents 306 E. Capital Ave, Suite 200 Pierre, SD 57501 View phone number on click.appcast.io #J-18808-Ljbffr