What are the responsibilities and job description for the Intern, IT Systems & Data Services position at Porsche Cars North America?
Tasks
Position Overview
The IT Data Analytics intern will perform, with supervision, the day-to-day tasks of development, support, testing, documentation, and training in areas of MS SQL Server, Snowflake, AWS, Business Intelligence tools, and other analytics related applications.
Roles & Responsibilities
Qualifications
Education
Position Location: The intern must reside within the Atlanta Metro area during the duration of their employment.
The hourly rate for this position is $18 to $20, dependent on degree status.
At a Glance
Porsche is an equal opportunity employer and we take pride in our diversity. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Porsche will be based on merit, qualifications and abilities. Porsche does not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, pregnancy, status as a parent, national origin, age, disability, family medical history, ancestry, medical condition, genetic information, sexual orientation, gender, gender identity, gender expression, marital status, familial status, registered domestic partner status, family and medical leave status, military status, criminal conviction history, or any other characteristic protected by federal, state or local law.
If you are an applicant from the state of California, please review the California Applicant Privacy Notice here .
Position Overview
The IT Data Analytics intern will perform, with supervision, the day-to-day tasks of development, support, testing, documentation, and training in areas of MS SQL Server, Snowflake, AWS, Business Intelligence tools, and other analytics related applications.
Roles & Responsibilities
- 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.
- Build and maintain AWS infrastructure.
- 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 provide insight in 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 sprit 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 meet 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 with 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.
- Preference will be given to candidates with experience working full time in Data Analytics, Business Intelligence, or SQL development.
- Demonstrated skill in SQL and Databases
- Understanding of Atlassian Confluence & Jira is a plus
- Knowledge of MicroStrategy or similar BI Tool is a plus
- Demonstrated skill in Python, JavaScript, or Java is a plus
- Understanding of Snowflake Database experience is a plus
- Demonstrated skill in AWS Cloud (Glue, EC2, S3, Athena) is a plus
- Knowledge of Big Data experience is a plus
- Strong communication and organizational skills
- Teamwork
- Project management
- Overall understanding of applied information technology
- Ability to work independently
- Systematic thinker; ability to work at conceptual and detail levels
- Tenacious/adept at follow-up
- Self-starter/organized
- Ability to adapt to changing scenarios
Position Location: The intern must reside within the Atlanta Metro area during the duration of their employment.
The hourly rate for this position is $18 to $20, dependent on degree status.
At a Glance
Porsche is an equal opportunity employer and we take pride in our diversity. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at Porsche will be based on merit, qualifications and abilities. Porsche does not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, pregnancy, status as a parent, national origin, age, disability, family medical history, ancestry, medical condition, genetic information, sexual orientation, gender, gender identity, gender expression, marital status, familial status, registered domestic partner status, family and medical leave status, military status, criminal conviction history, or any other characteristic protected by federal, state or local law.
If you are an applicant from the state of California, please review the California Applicant Privacy Notice here .
Salary : $18 - $20
