Chicago Cubs
  • - Information Technology
  • Chicago, IL, USA
  • Salary
  • Full Time

This position performs data analysis and development of enterprise data warehouse, application databases, system integrations, data models and relational database structures across multiple computing environments

ETL Development
• Profiles data and implements ETL plans.
• Develops, tests, implements, troubleshoots and tunes ETL processes.
• Assists in the definition and resolution of ETL and database problems.
• Solutions must be rapidly developed and highly flexible.
• Candidate will be responsible for appropriate development documentation, including requirements, design, code documentation, test plans and other related documents.
Data Analysis, Modeling and Reporting
• Performs data profiling and analysis to understand entity and transaction relationships and to derive the business value of the data.
• Performs data modeling analysis and develops detailed data models.
• Candidate will be responsible for data cleansing and transformation of source system data stores into our data warehouse for our strategic initiatives within the Cubs organization.
• Candidate will develop and maintain business report creation across multiple departments from our Enterprise Data Warehouse including metadata mapping, Business Intelligence technology use and overall automation of standardized reporting across the organization.

• 4-year degree at an accredited college or university
• Strong Interpersonal Communication
• Data Modeling (Relational)
• Extract Transform and Load (ETL) and Database development
• Structured Query Language (SQL)

• Data Modeling (Dimensional)
• Data Profiling
• Data Analysis
• Technologies
o Oracle
o Informatica
o Toad/Erwin
o Python
o Columnar Database Technology (e.g. Amazon Redshift)
o NoSQL Database Technology (e.g. Mongo DB)
o Distributed File System Technology (e.g. Hadoop)

The Chicago Cubs are an Equal Opportunity Employer

Chicago Cubs
  • Apply Now

  • Start Application Through LinkedIn
  • Sign Up For Job Alerts

  • Follow Us On Social Media

  • Follow Our Jobs On Facebook Follow Our Jobs On Twitter
  • Share This Page

MLB Home Cubs Logo News Video Scores Tickets Schedule Stats Roster Community Fans Wrigley Field Apps Teams Fantasy MLB.TV Shop