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.
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.
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