Sr BI Data Analytics Engineer
Company: Nintendo of America Inc.
Location: Redmond
Posted on: April 16, 2025
|
|
|
Job Description:
Nintendo of America Inc.
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 .
Develops and maintains medium to complex data warehouse ETL
(Extraction, Transformation and Loading), reporting, and analytic
tasks for Nintendo global consumer contact centers.
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.
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:
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/data lakes 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.
Requires in-depth conceptual and practical knowledge in own
technical job family and basic knowledge of related technical job
families; has worked with a range of technologies.
Applicants must be legally eligible to work in the United States to
be considered. Visa sponsorship is not available for this role
This position includes a base salary range of $137,000 - $246,500
annually, potential for a semi-annual discretionary performance
bonus, and a comprehensive benefits package that includes medical,
dental, vision, 401(k), and paid time off. Please see our for more
benefits information. Fixed term employees are eligible for all
listed employee benefits except tuition reimbursement.
#LI-Offsite
Keywords: Nintendo of America Inc., Bellevue , Sr BI Data Analytics Engineer, Engineering , Redmond, Washington
|
Click
here to apply!
|
