Database Administrator/Application Developer Intern

Central Electric Power Cooperative Inc•Columbia, SC

23h•Onsite

About The Position

The Database Administrator / Application Developer Intern assists with entry-level data management and software development duties while gaining practical experience in database administration, data integration, reporting, business intelligence, cloud-based data storage and processing, data warehouse concepts, and internal application development, including introductory exposure to Snowflake-based solutions. Under close guidance, the position supports routine tasks related to databases, queries, reports, dashboards, scripts, data pipelines, and internal software solutions using approved technologies and established standards. The role learns and follows Git-based development practices and may assist with approved analytics, Power BI, and AI/ML-enabled use cases in accordance with governance, security, and data handling requirements. This position is located on-premises.

Requirements

Basic analytical, communication, and problem-solving skills
Basic familiarity with database, business intelligence, application development, and scripting concepts
Basic understanding of cloud-based data storage, data processing, and data warehouse concepts, including introductory familiarity with Snowflake
Ability to learn technical tools, standards, and procedures and apply them under guidance
Ability to manage assigned tasks, follow instructions, and complete work accurately and on time
Service oriented with a willingness to learn and support team and user needs
Basic understanding of secure development and data handling expectations
Basic familiarity with Git-based development practices and team delivery processes
Basic understanding of business intelligence concepts and reporting tools, including Power BI fundamentals
Basic understanding of AI/ML concepts, development practices, and the responsible use of approved tools
Must have familiarity through coursework, training, projects, or prior internship experience with the following technologies and products: Microsoft SQL Server or other relational database concepts; Basic SQL query writing and data manipulation; Basic programming or scripting concepts; Visual Studio, .NET, or similar development tools/workflows; Git source control fundamentals, including commits, branches, and pull requests; Microsoft Office Suite (including Excel and Word)

Nice To Haves

Web development fundamentals such as HTML, CSS, and JavaScript
Reporting, dashboarding, ETL, or file-based data processing concepts
Power BI or similar business intelligence and visualization tools
Basic understanding of application testing and debugging
Cloud-based data storage, processing, and data warehouse concepts, including Snowflake fundamentals
Basic understanding of approved AI/ML tools, services, or AI-assisted development practices, following data handling expectations

Responsibilities

Assist with maintaining Microsoft SQL Server databases, scripts, scheduled jobs, and related documentation
Assist with basic query, extract, report, dashboard, visualization, and data validation tasks, including business intelligence deliverables using approved tools such as Power BI, under the direction of more senior staff
Support routine data integration, reconciliation, and file-based processing activities using approved tools and procedures
Assist with data loading, validation, query support, and documentation for cloud-based data storage, processing, and data warehouse solutions, including Snowflake, under established guidance
Assist with testing, troubleshooting, and documenting database and application changes
Learn and follow Git-based source control practices, including commits, branching, pull requests, code review participation, and deployment procedures established by the team
Assist with monitoring scheduled jobs, data pipelines, dashboards, and application processes and escalate issues when identified
Support maintenance of technical documentation, data definitions, and team procedures
Assist with preparation of curated datasets, searchable content, metadata, and other inputs that support analytics and approved AI/ML-enabled use cases under established guidance
Provide user and team support for routine issues, requests, and assigned tasks as needed
Perform other related duties as assigned