IT, Data and Analytics Intern

Tasks

• Perform development, support and training activities in SQL Server, Snowflake, AWS, Business Intelligence tools and other analytics related applications.
• Develop and maintain SQL scripts and stored procedures.
• Build and maintain Snowflake databases, tasks, streams, etc.
• Build and maintain AWS infrastructure.
• Leverage GitHub for CI/CD.
• Consume third-party APIs.
• Build and maintain Business Intelligence dashboards and reports.
• Serve as a team member for cross-functional application implementations and upgrades.
• Work with IT, Data and Analytics team members to assist with the optimization of current processes, the automation of routine administrative tasks to improve efficiencies, and the documentation of processes and procedures.
• Lead agile ceremonies including sprint planning and daily scrums.
• Work independently on projects to support the business units and the IT team.
• Develop and implement solutions to business problems.
• Design and implement new features and functionality.
• Test and deploy new applications.
• Perform quality assurance and user acceptance testing.
• Test new development for bugs and errors.
• Work with users to ensure that new development meets their needs.
• Document systems, defects, and change requests.
• Document systems and data flows.
• Track and document system defects and change requests.
• Work with PCNA/PAG IT to resolve issues.
• Research and test the latest analytics trends and technology.
• Stay up-to-date on the latest trends and technologies in analytics.
• Test and evaluate new technologies at PCNA.
• Work with PAG on implementation of new technologies.

Qualifications

• Education: At a minimum, be enrolled in a 4-year degree program in Information Technology, Computer Science, Data Analytics, Data Science, or comparable curriculum.
• Experience: Preference will be given to candidates with experience working full-time in Data Analytics, Business Intelligence, or Snowflake development.
• Skills: Demonstrated skill in Snowflake and MS SQL Server; demonstrated skill in AWS Cloud (Glue, EC2, S3, Athena); understanding of GitHub is a plus; understanding of Atlassian Confluence & Jira is a plus; knowledge of Strategy (FKA MicroStrategy) or similar BI Tools is a plus; demonstrated skill in Python, JavaScript, or Java is a plus.
• Competencies: Strong communication and organizational skills; teamwork; project management; overall understanding of applied information technology; systematic thinker; ability to work at conceptual and detail levels; tenacious/adept at follow-up; self-starter/organized; ability to adapt to changing scenarios.