Job description

Based out of our Home Office in Greenwood Village, CO the Business Intelligence Solutions Architect (BISA) at Red Robin will focus on the creation of accurate, consistent and transparent enterprise data. The BISA is responsible for the architecture, design, development, and data quality of the data warehouse environment (data hub, ODS, enterprise data warehouse, data marts, ETL, and cubes) to deliver reliable, flexible, scalable and high business value with low cost of ownership enterprise data solutions. The BISA will also be responsible for the architecture, design, development of our Business Intelligence (BI) environment and Master Data Management (MDM) solution. The BISA will support enterprise data management in choosing the right processes, technologies, and resources for enterprise data. These responsibilities apply to data models, data integrations, and data quality as set forth by the IT governance organization. This role will work closely with the Business Relationship Directors, the Information Architect, and report directly to the Data Assets Manager to ensure all solutions deliver information to empower the business and their reporting, visualizations, and decisions making processes.ResponsibilitiesDesign and develop data management solutions including data partitioning, data normalizing/denormalizing, data aggregations, master data management and ETL within the data warehouse platform.Create logical and physical data model designs (including 3NF and dimensional models) supporting the business needs and following Red Robin data standards.Maintain and guide the technical architecture, standards and infrastructure of the technologies and tools used in the BI program.Gather all functional/non-functional requirements from business owners as part of the formal intake process for the data group.Coordinate with the development team to translate business requirements into technical specifications for custom development and systems integration requirements.Provide thought leadership with regards to creative data profiling and integration recommendations.Direct, test, and participate in regression testing as it relates to the data warehouse environments or data marts.Provide strategic and tactical guidance with respects to data warehousing / data mart best practices.Provide thought leadership with regards to creative data profiling and integration recommendations.Provide consulting and conduct reviews through the development lifecycle.Lead the data warehouse maturity with continuous improvement towards an enterprise data model.Troubleshoot Production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency. Perform data cleansing and data auditing as necessary to ensure data quality. Define and develop physical and logical data models to support departmental and functional reporting needsOther IT projects and duties as assigned.Staying current with industry trends and advising and educating management about their importance and impactRequirementsA Bachelors degree (or equivalent work experience) from an accredited college or university in Computer Science, Information Systems, or a related field. MBA preferable.2 years of experience in a data warehouse architecture role.3+ years of experience in data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling slow-changing dimensions/attributes.3+ years of experience designing and developing data extractions, models and UIs with front end reporting tools such as PowerBI, QlikView, or Tableau.Practical hands on experience with data modeling, ETL, OLAP, and data profiling.Strong knowledge of how databases and ETL software function including when to use which platform.Knowledge, Skills And AbilitiesDatabase development including stored procedures, store functions, triggers, and views.Understanding of the difference in data models (3NF, star schema, and snowflake schema) and when to use them.Knowledge of the SQL Server Business Intelligence stack including SSIS, SSRS, SSAS, and PowerBI.Strong analytical, evaluative, and problem-solving abilities.Excellent communications skills at both the IT and business levels.Be proficient in business analysis, data modeling, logical and physical database design, data acquisition analysis and design, data access analysis and design.Formalized audit and/or financial training.Data warehousing & business intelligenceData stewardship & governanceSolution architecture & planningCritical thinking & problem solvingExcellent oral & written communicationsTechnical & business analysisImplementation of solutions applying development life cycles (SDLC/Agile)Data & BI Technology: Microsoft SQL Server, SSRS, SSIS, SSAS, MDM, ESB,Languages: SQL, HTMLMicrosoft: Word, Excel, Access, PowerPoint, Visio, SQL ServerRed Robin is an Equal Opportunity & E-Verify Employer

To apply for this job please visit