Red Robin Business Intelligence Developer in Greenwood Village, Colorado

Based at our Greenwood Village Home Office the Business Intelligence Developer will evaluate the current data-warehouse environment and recommend changes to and/or create new data marts and end-to-end flows to improve the overall functionality and usefulness of Red Robin’s data warehouse capabilities. The BI Developer will ensure proper data cardinality, data relationships, and quality of the data as well as new dashboards and reports to efficiently fulfill the requirements of the BI team and management. The goal is to modernize the data infrastructure supporting the Business Intelligence Environment and utilize Power BI for developers and power users alike. This role will provide relational data for customers and data integration activities as needed. The BI Developer will act as a liaison between cross functional teams and participate in resolving new Business Intelligence requests using Power BI.

Duties Include:

  • Migrate on-prem application to Azure .NET / SQL Server / Power BI / Reporting / SSIS expert with Azure certifications.

  • application development & maintenance across Microsoft Technology stack with a focus on Microsoft Azure PaaS, .NET framework, C#, VB.NET, ASP.NET, Web API, Entity Framework 6, Unity and SQL Server, Spark, Hadoop, Databricks.

  • implementing enterprise systems based on Microsoft Azure PaaS and SaaS platform using Azure Storage Queue, Azure Table, Azure BLOB, Data Lake, NoSQL, Worker / Web Role and Azure Redis Cache, Azure Deployment and Monitoring,

  • App Service, Logic Apps, Web Jobs, Azure Functions in an integrated development & test environment involving Azure SDK, Visual Studio and Azure Emulator.

  • design and development of middleware components and reusable frameworks using .NET / C# and Object-Oriented Design patterns and Dependency Injection using Unity Framework.

  • Database development with MS SQL Server and Oracle RDBMS systems.

  • design web Applications using ASP.NET / Java / Python.

  • design and develop WCF and Web Services using .Net Framework.

  • ·optimize complex database queries and authoring large Stored Procedures, Views and Triggers for data centric enterprise business solutions.

  • Conceptualize and implement reports and BI solutions using POWER BI, SQL Server Reporting Services (SSRS) and Crystal Reports.

  • Source Control / Build Management tools such as Microsoft TFS or VSTS

  • integrating / migrating legacy data sources with SQL server using SQL Server Integration Services (SSIS)

  • Support consistent triage and execution of incoming requests

  • Support and follow compliance with all IT controls and interpretations of the IT Information Security Director including, but not limited to SOX, PCI and HIPAA.

Requirements:

  • BS Degree in Information Technology, Business Administration, Computer Science, CIS, Engineering or related field preferred

  • Microsoft SQL development experience required

  • Power BI experience required

  • Azure experience required

  • Data Science/Data Management Certificate/Experience

  • Minimum 5+ years of relevant work experience in IT/Data & Analytics required

  • 7+ years of software development and/or BI development experience preferred

  • Retail/Hospitality/Restaurant industry experience preferred

  • Extensive experience working with Microsoft Power Business Intelligence (BI) tools

  • Experience with Microsoft Power BI required

  • Experience with Cloud platforms like Azure and/or AWS required

  • Strong .NET Skills (C#, VB.NET, and/or F#)

  • Proven expertise as a Database Developer with MS SQL Server and Oracle RDBMS systems

  • Knowledge of REST web services development and consumption

  • Ability to use/implement several different security mechanisms such as: OATH2, APIKEYS, etc.

  • Working Knowledge of Core Azure Components: App. Hosting, Storage, SQL, Document DB (Cosmos DB), Azure Active Directory, Functions, Queues, etc.

  • Experience in developing solutions for cloud architecture using cloud patterns

  • Experience deploying to Azure a plus

  • History of Azure project delivery

  • Certification a big plus (please provide MCP #)

  • Data warehousing & business intelligence

  • Data analysis, design, & testing

  • Data stewardship & governance

  • Solution architecture & planning

  • Critical thinking & problem solving

  • Excellent oral & written communications

  • Technical & business analysis

  • Expert knowledge of SQL development, including development of triggers, views, stored procedures, functions, and ETL

  • Implementation of solutions applying development life cycles (SDLC/Agile)

  • Data & BI Technology: Oracle, SQL Server, SSRS, SSIS, SSAS, Sybase, DB2, MDM/DRM/DRG

  • Other Applications: ERP’s (Oracle/SAP/MS), EPM (Oracle/Hyperion, SAP BPC, IBM Cognos), Cloud Services (Anaplan, Host Analytics, Oracle, SAP, Salesforce.com, Aloha Enterprise, Apache Camel)

  • Languages: SQL, HTML

  • Knowledge system integration design, development and testing ETL processes.

  • Microsoft: Word, Excel, Access, PowerPoint, Visio, SQL Server

Red Robin is an Equal Opportunity & E-Verify Employer

Company: Red Robin

Req Number: 470035

Updated: Thu, 26 Jul 2018 00:00:00 GMT

Location: Greenwood Village,CO

Category: Home Office