Spring 2023- Big Data Engineering Intern - 90350529 - Washington, D.C.

Location: Washington, District of Columbia, US, 20001

Company: Amtrak

As we move America’s workforce toward the future, Amtrak connects businesses and communities across the country. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority, and the success of our railroad is due to our employees.

 

Our values of ‘Do the Right Thing, Excel Together and Put Customers First’ are at the heart of what matters most to us, and our Core Capabilities, ‘Building Trust, Accountability, Effective Communication, Customer Focus, and Proactive Safety & Security’ are what every employee needs to know and do to be most impactful at Amtrak. By living the Amtrak values, focusing on our capabilities, and actively embracing and fostering diverse ideas, backgrounds, and perspectives, together we will honor our past and make Amtrak a company of the future.

 

The Big Data Engineering Intern will support the Marketing team in synthesizing various data domains and creating working models helpful for customer segmentation. This position will require the candidate to apply theoretical concepts to robust data sources and create meaningful insight that can be shared with senior leadership. Specifically, the candidate would provide analysis into various customer-based attributes like price sensitivity, travel history, promotional usage, psychographic profiles including brand loyalty. Additionally, the candidate will work closely with the Market Research and Analytics team to create customer segments that can be used in campaigns and product development. This role requires experience in SQL and Exploratory Data Analysis coupled with familiarity doing customer segmentation in some scientific programming language.

 

·       Python/R and SQL programming, familiarity with customer related data domains helpful

·       Experience in the design, testing and reporting of various customer segmentation algorithms (K-Means++ and Hierarchical)

·       Documentation and structured programming to support sustainable development practice

·       Debugging and code-reading skills

 

·       Must be actively pursuing a degree at an accredited educational institution

·       Must be actively pursuing an undergraduate degree in Business Management, Criminal Justice, Political Science, Human Resources or related field

·       Must have at least 1 year of academic undergraduate studies completed or a sophomore status at minimum.

·       Must have a cumulative GPA of 2.8 or higher 

 

·       Provable experience with SQL and Python in the context of large data sources

·       Some experience with unstructured data sources

·       Experience with visualization tools such as Business Objects, Tableau or similar

·       Understanding of data warehousing concepts including data integration for data warehouse objects

·       Demonstrated skill in project planning and collaborating with groups

·       Ability to describe challenges and solutions in both technical and business terms

·       Ability to develop and maintain excellent working relationships at all organizational levels

 

Must have excellent oral and written communication skills

 

 

Requisition ID: 156382

Posting Location(s): District of Columbia; Maryland; Virginia

Job Family/Function: Marketing 

Relocation Offered: No 

Travel Requirements: None 

 

We want your work at Amtrak to be more than a job – we want it to be a fulfilling experience where you find challenging and rewarding opportunities, respect among colleagues, competitive pay, benefits that protect you and your family and a high performance culture that recognizes and values your contributions and helps you reach your career goals.

All positions require pre-employment background check verification, a pre-employment drug screen and proof of full vaccination against COVID -19. Amtrak is committed to a safe workplace free of drugs and alcohol and performs pre-employment substance abuse testing. Marijuana, notwithstanding any statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use. Candidates who engage in the usage of marijuana will not be qualified for hire. Successful applicants for employment with Amtrak must be fully vaccinated against COVID-19 by the date of hire as a condition of employment, subject to requests for accommodation. Fully vaccinated means 14 days have elapsed since receiving the second dose of the Pfizer or Moderna vaccine or 14 days since receiving the Johnson & Johnson vaccine.

In accordance with DOT regulations (49 CFR § 40.25), Amtrak is required to obtain prior drug and alcohol testing records for applicants/employees intending to perform safety-sensitive duties for covered Department of Transportation positions. If an applicant/employee refuses to provide written consent for Amtrak to obtain these records, the individual will not be permitted to perform safety-sensitive functions.

In accordance with federal law governing security checks of covered individuals for public transportation ( Title 6 U.S.C. § 1143), Amtrak is required to screen applicants for any permanent or interim disqualifying criminal offenses.

Note that any education requirement listed above may be deemed satisfied if you have an equivalent combination of education, training and experience.

Amtrak is an EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, disability (intellectual, mental and physical), veteran status, marital status, ancestry, sexual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.