SpokaneRecruiter Since 2001
the smart solution for Spokane jobs

Business Intelligence Developer

Company: Northern Quest Resort & Casino
Location: Airway Heights
Posted on: June 9, 2021

Job Description:

Summary of Functions continued:BI Developers will support the business by performing the following duties: data governance, data analysis, database administration, data mining and dimensional modeling, supporting the data warehouse, and developing reports and creating effective dashboards and other visualizations and analytical tools for KTEA to monitor their businesses and business processes.Essential Duties and Responsibilities (Architecture)Collaborate with other team members to select, plan for, and implement adoption of BI tools and software to use with the data warehouse.Define and design the infrastructure for analytical reporting, KPIs, and other data specifications from various BI applications.(Development)Support the Sr. BI Developer with development of ETL/integration tools to populate the data warehouse for analysis, data mining, reporting, etc.Design complex data models from business requirements for delivery to business operators.Query, analyze, and profile data to ensure data quality and determine the ability to meet reporting analytic needs.Develop data pipelines to disparate sources of data using a variety of means including APIs, XML, custom coding, etc.(Requirements Gathering)Collaborate with other departments to understand their Core Business Processes.Assist with requirements-gathering sessions with business and technical staff to determine technical requirements of business requests.(Report Building)Develop complex SQL queries, procedures, functions, and views for reporting and analytic needs, as well as other data needs.Define, design and develop analytical reports from various BI applications, incorporating KPIs introduced by business leadership, and other data specifications.Synthesize unstructured, disjointed information into meaningful, compelling narratives that facilitate and promote self-learning by business users.(Analysis)Integrate, analyze and interpret data from a variety of data sources, identify business-related trends, and communicate analysis to business operators.(Administration and Support)Develop scripts for administrative tasks, security, and automation of the reporting server(s).Manage user accounts and access permissions, sites, subscriptions, and licenses of databases, reporting, and analysis tools.Train and mentor users and management on BI Tools, analytics, data architecture and database resources.Ensure the accuracy and integrity of data through analysis, coding, and writing clear documentation.Monitor the performance of the data warehouse, databases, and BI tools; recommend improvements to increase performance.Perform database administration tasks such as the maintenance, monitoring, design, integrity and security of databases across the enterprise.(General)Ensure control and protection of company assets.Be available and willing to work any changes in hours deemed necessary for business levels.Ensure compliance with:the Kalispel Tribe of Indians-State of Washington Gaming CompactAll KTOI, KTEA and NQRC policies, procedures and internal controlsNIGC RegulationsOther relevant governance requirements (PCI DSS, HIPAA, etc.)This job description does not list all of the duties of this position.Supervisory ResponsibilitiesThis job has no supervisory responsibilities.Skills RequiredWorking knowledge of data-reporting and business intelligence analysis tools required; specifically preferred:Microsoft SQL Server Reporting Services, Analysis Services, Integration ServicesTableau Software's data visualization toolsPower BIWherescape or other DW/ETL automation tools a plusFamiliarity with one or more hospitality- & financial-management systems preferred, specifically:Sage 500UKG Group UltiPro HRMSAgilysys Visual One lodging-management and club-management systemsAgilysys InfoGenesis point-of-sale systemRetailPro point-of-sale systemResortSuite spa-management systemAbility to understand and document business and administrative processes.Familiarity with data science concepts, machine learning, regression analysis, predictive analytics, clustering, decision trees, etc.Ability to develop and debug SQL Server Common Language Runtime packages using C#Ability to develop and debug data-exchange automations using JSON, XML, and SSISAbility to communicate clearly and effectively with technical and non-technical audiences, verbally and in writing (including writing reports, business correspondence and procedural manuals).Ability to provide one-on-one and formal classroom training to users and management.Well-developed organizational and leadership skills.Ability to reason from limited information, and identify and solve practical problems under high-pressure conditions.Ability to take data from disparate sources across the enterprise and synthesize into meaningful business insights.Ability to troubleshoot data integrity problems and provide technical support as needed.Ability to deal with conflicts and tense situations in a professional manner.ExperienceAt least 5 years of experience:Working with SQLServer, including design and administration of databasesCreating complex SQL scripts, procedures, functions, etc.Creating reports with tools such as Tableau, SSRS, Excel/Access, Power BI, etc.At least 2 years of experience:Working as part of a team to design, build and support a data warehouse and related data models.Assisting with the creation of medium- to large-scale SSIS ETL's and SSAS cubes for a data warehouseWorking with and creating multidimensional expressionsProgramming with C#, Java, Python, or Visual BasicEducationBachelor's degree or equivalent in a Business or IT related fieldMicrosoft SQL Server or other relevant Certification required.Other RequirementsAbility to obtain and maintain a Tribal Gaming License and a Class III Gaming License.Valid driver's license (Must be in possession while operating a Tribal Vehicle).Available and willing to work nights, weekends and holidays as required.

Keywords: Northern Quest Resort & Casino, Spokane , Business Intelligence Developer, Other , Airway Heights, Washington

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Washington jobs by following @recnetWA on Twitter!

Spokane RSS job feeds