Job Description
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
Job Requirements
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.