Data Modeling Intern
Location: San Diego, California US
Requisition Number: 206497
Position Title: Intern-Engineering (I)
Our summer internship program lasts 10-12 weeks beginning in May/June 2020 and ending in August/September. Fast-paced, flexible, fun. The Teradata culture isn’t just about one kind of person. So many individuals make up who we are, making us that much more unique. It’s what sets apart the dynamic, diverse and collaborative environment that is Teradata.
The Transcend team is an organization chartered to utilize Teradata products and services to deliver information and analytic capabilities to all Teradata business functions and external stakeholders. Data Architects on the Transcend team are responsible for developing and maintaining a formal description of Teradata data and data structures using logical and physical data models. The Data Architect is responsible for developing and enforcing data modeling standards and best practices, managing the enterprise data model and managing all metadata in the Teradata Analytics Platform environment. The Data Architect role is broader than the role of a typical application-level “data modeler” in that it involves identifying the data needs, providing guidance on how to extract, transform and load the data, providing guidance on layered data architecture and integrating the new data and applications with master data and other existing data in the Teradata Analytics Platform. It also involves modeling from a neutral perspective rather than from a single business functional perspective.
The intern will be involved in updating the Transcend data model in the following two methods:
- Adding and updating objects in the Erwin Data Model to reflect the objects that are in the DB including modeling of the semantic layer views. This includes capturing the metadata on these objects (missing source rules, missing application ID's, missing descriptions, etc.)
- Identify and create missing base views
Must be enrolled in BS/MS degree program. With graduation dates between December 2020-June 2022.
- Knowledge of modeling methodologies and techniques.
- Strong SQL and analytical skills.
- Hands-on experience with relational DBMS, with Teradata experience desired.
- Good understanding of ETL processes and ETL best practices.
- Good understanding of Metadata usage and benefits.
- Experience/ familiarity with Business Intelligence tools. For example: MS Power BI.
- Excellent teaming and communication skills.
- Effective multi-tasking skills.
CountryEEOText_Description: Teradata invites all identities and backgrounds in the workplace. We work with deliberation and intent to ensure we are cultivating collaboration and inclusivity across our global organization. We are proud to be an equal opportunity and affirmative action employer. We do not discriminate based upon race, color, ancestry, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related conditions), national origin, sexual orientation, age, citizenship, marital status, disability, medical condition, genetic information, gender identity or expression, military and veteran status, or any other legally protected status.
City: San Diego
Community / Marketing Title: Data Modeling Intern
Job Category: College & Interns
With all the investments made in analytics, it’s time to stop buying into partial solutions that overpromise and underdeliver. It’s time to invest in answers. Only Teradata leverages all of the data, all of the time, so that customers can analyze anything, deploy anywhere, and deliver analytics that matter most to them. And we do it at scale, on-premises, in the Cloud, or anywhere in between.
We call this Pervasive Data Intelligence. It’s the answer to the complexity, cost, and inadequacy of today’s analytics. And it's the way Teradata transforms how businesses work and people live through the power of data throughout the world. Join us and help create the era of Pervasive Data Intelligence.
Location_formattedLocationLong: San Diego, California US