Job Description

Posting Text
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 webservices APIs
Higher Education system experience a plus
Prior experience with Ellucian Banner systems (technical/administrative)
Excellent verbal and written communication skills in order to deal with a wide variety of users and peers.