The worldwide pioneer in the creation of interactive entertainment, Nintendo Co., Ltd., of Kyoto, Japan, manufactures and markets hardware and software for its Nintendo Switch™ system and the Nintendo 3DS™ family of portable systems. Since 1983, when it launched the Nintendo Entertainment System™, Nintendo has sold billions of video games and hundreds of millions of hardware units globally, including Nintendo Switch and the Nintendo 3DS family of systems, as well as the Game Boy™, Game Boy Advance, Nintendo DS™ family of systems, Super NES™, Nintendo 64™, Nintendo GameCube™, Wii™, and Wii U™ systems. It has also created industry icons that have become well-known, household names, such as Mario, Donkey Kong, Metroid, Zelda and Pokémon. A wholly owned subsidiary, Nintendo of America Inc., based in Redmond, Wash., serves as headquarters for Nintendo’s operations in the Americas.
Nintendo is an equal opportunity employer. We offer a welcoming and inclusive environment in service to one another, our products, the diverse consumers we represent, and the communities we call home. We do all of this with kindness, empathy and respect for each other.
Develops and maintains medium to complex data warehouse ETL (Extraction, Transformation and Loading), reporting, and analytic tasks for Nintendo global consumer contact centers, repair centers, product testing, stores and other Operational departments
DESCRIPTION OF DUTIES:
Designs, develops, and maintains ETL routines and reporting with agreed-upon Service Level Agreements (SLAs) using Microsoft SQL Server, Excel, and Tableau.
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 translate 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.
SUMMARY OF REQUIREMENTS:
Minimum of 5 years of relevant experience in developing data warehousing solutions, dashboards, scorecards, and analytics
Proficient in writing T-SQL code, SSIS packages, and Stored Procedures on Microsoft SQL Server.
Proficient in writing C# routines to extract data from various physical and cloud databases/datalakes through API calls
Experience working as a database report developer to deliver BI to business users using Tableau or similar tool.
Familiarity with Operations KPI's and contact center forecasting
Working knowledge of cloud data architectures like Snowflake
Experience designing and deploying normalized and dimensional database objects (eg. star schemas).
Extensive reporting experience within an ETL based data migration paradigm.
Excellent native SQL skills; comfortable using a data access tool such as Toad or SSMS.
Share Point, Power BI, Excel macro, Windows script development experience (preferred).
Ability to analyze trends in metrics and suggest Dashboard layouts (preferred).
Customer Service, Operations, Retail, CRM, or B2C e-commerce background a plus.
Undergraduate degree or equivalent in computer science, information systems, or other quantitative field.