Senior Enterprise Data Analyst
Based at our Greenwood Village Home Office you will participate in the build-out of enterprise
data architecture at Red Robin. This includes developing and supporting data integration services
and reporting services that provide business owners access to key performance metrics across the
organization.
Additional Duties Include
Supporting new and existing databases and ensuring their performance, availability and security
in a distributed architecture environment.
Work with application developers to design and implement application data models.
Perform implementation tasks including physical storage configuration, database export and import, data migration / conversion and database performance tuning.
Troubleshoot application database issues identifying database server issues versus application issues.
Develop and maintain database functionality to support corporate reporting and application needs
through building database structures, ETL processes, stored procedures, audit reports, and
data extracts.
Troubleshoot and problem solve of existing databases and data architectures.
Provide decision support and fulfill ad hoc data reporting requests.
Skills/Requirements:
4 year degree in CIS, MIS, Computer Science, Engineering or equivalent experience (required)
5-10 years of database development, data modeling
Experience with SQL Server 2005 or better including SQL Server Integration & Server
Reporting Services
Experience writing SQL, including queries, triggers, stored procedures
Experience with Oracle database 11g, Oracle Data Integrator, and Oracle Business Intelligence
Enterprise Edition desired
Separation of data methodologies (i.e. staging, development, production)
Operational data storage environments and data warehousing concepts desired
Database Administration activities including managing connections, configuring databases
Knowledge of data backup/ recovery/ rollback planning and implementation
Conversant in Software Development Lifecycle (SDLC) methodologies such as RUP, Agile, etc.