Sr BI Data Analytics Engineer

About Nintendo of America: From the launch of the Nintendo Entertainment System™ more than 30 years ago, Nintendo’s mission has been to create smiles through unique entertainment experiences. Here at Nintendo of America Inc., we deliver on this mission by partnering closely with Nintendo Co., Ltd., to bring Nintendo’s iconic and cherished franchises including Mario™, Donkey Kong™, The Legend of Zelda™, Metroid™, Animal Crossing™, Pikmin™ and Splatoon™ across the Americas through our video games, hardware systems, and collaborations with partners on a range of other entertainment initiatives like feature films and theme parks.

Based in Redmond, Wash., Nintendo of America serves as headquarters for Nintendo’s operations in the Americas. We are an equal opportunity employer offering a welcoming and inclusive environment in service to one another, our products, and the diverse consumers and communities we call home. For more information about Nintendo, please visit the company’s website at https://www.nintendo.com/.

Develops and maintains medium to complex data warehouse ETL (Extraction, Transformation and Loading), reporting, and analytic tasks for Nintendo global consumer contact centers.

• Designs, develops, and maintains ETL routines and reporting with agreed-upon Service Level Agreements (SLAs) using Microsoft SQL Server, Excel, and Tableau.
• Creates data extraction procedures and analytical products to measure, track and improve agent quality, contact center efficiency and outsourced vendor performance.
• Provides expertise working with existing team (contract and FTEs) to create business intelligence stored procedures and reports, including design, development and management of a data warehouse environment used for analytics and reporting.
• Understands the needs of the business and translates those into meaningful reporting that allows for actionable decisions.
• Ensures the generation of standard or custom reports summarizing operational and financial data and Key Performance Indicators (KPIs) for review by executives, managers, clients, and other stakeholders.
• Identifies and recommends changes to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity.
• Conducts or coordinates unit and system tests ensuring intelligence is consistent with defined needs.
• Designs and deploys database table structures, reports, and queries.
• Supports implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues.
• Documents specifications for Data Warehouse (DWH) extracts, reports, dashboards, or other outputs.
• Facilitates and leads project planning and execution with cross functional teams across the organization.
• Works with business and engineering managers to prioritize the project stream, aid roadmap definition and identify project dependencies.
• Administers reporting systems including user/role provisioning, deployments and change control.
• Conducts comparison processes to identify and develop process improvements; provides recommendations on next steps and manages deliverables.

SUMMARY OF REQUIREMENTS:

• Mi