Position: Colorado Rockies Data Management Part-Time Staff

Location: Denver, Colo.

Description:
The primary purpose of the job is to assist the Baseball Analytics department with the design, implementation, and management of the Baseball Department’s information architecture. The candidate will assist the Baseball Analytics staff to maintain data infrastructure, support needs, implement solutions, and drive innovation in baseball’s data-driven decision process. Key functions will include data modeling, integration, warehousing, and consumption. This is an 2015 in-season, Denver-based, 35-40 hour a week, hourly paid position.

Responsibilities:
Data Modeling

• Understand and document existing database structures, historical design decisions, business rules, and future requirements
• Develop and document a comprehensive information model that describes the data and maps the workflow that transform and manipulates it into usable information
• Ensure “single version of the truth” consistency across applications and reports

Data Integration

• Create and manage ETL (extract, transform, load) data integration processes
• Understand the format, definitions, limitations, and content of external and internal data feeds
• Reconcile differences across data sources and consolidate into a single master repository
• Knowledge of managing and reading XML, JSON, CSV, among other data formats into proprietary databases
• Assist efforts to identify, obtain and integrate new data sources useful for decision-making

Data Warehousing

• Design and manage a data warehouse to support reporting and analytics
• Review and assess technical proposals requesting changes or upgrades to the existing databases
• Data Consumption
• Support data and reporting requirements for a variety of applications, analysts, and end-users in all departments
• Provide technical and strategic advice of the management in the creation and implementation of new data standards, databases, products, and vendors

Qualifications:
Education and Work Experience

• Bachelor’s degree in Computer Science, Information Systems, Computer Engineering or related field (candidates still in school with extensive work towards such degree will be considered)
• Information technology experience
• Business intelligence, data warehousing, OLAP, and/or data integration experience
• Proven data modeling experience
• Experience designing, implementing, and managing large and complex data warehouses and cubes in Microsoft SQL Server Analysis Services
• Thorough knowledge of design and integration principles for complex, heterogeneous databases
• Experience with ETL and BI reporting tools (e.g. Microsoft SSIS & SSRS)
• Advanced knowledge in query development, including SQL, MDX, and stored procedures
• Experience parsing XML, JSON and CSV formatted data
• Candidates with some, but not all skills are encouraged to apply

Relevant Skills

• Knowledgeable about software development best practices and long-term maintainability of code
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure, integrity, and incompatibilities
• Familiarity with baseball and sabermetrics strongly desirable
• Experience using statistical programs (R, Python or others) and/or data mining (WEKA or others) applications is desirable
• Advanced Excel knowledge (VLOOKUP, INDEX/MATCH, Conditional Formatting)
• Familiarity with any of application development and/or web technologies is desirable

Functional Skills

• Ability to work evenings and weekends required
• Effective communication with both co-workers and guests
• Passion for baseball, strong intellectual curiosity and strong communication skills
• Ability to develop and maintain successful working relationship with members of the Front Office

Compensation:
This position is compensated.

To Apply:
Email baseballjobs@rockies.com with a resume and cover letter by April 8th, 2015.