BI EngineerRemote

Title: BI Engineer

Location: Remote, US

Duration: 1 Year contract

NIKE, Inc. does more than outfit the world's best athletes. It is a place to explore potential, obliterate boundaries and push out the edges of what can be. The company looks for people who can grow, think, dream and create. Its culture thrives by embracing diversity and rewarding imagination. The brand seeks achievers, leaders and visionaries. At Nike, it’s about each person bringing skills and passion to a challenging and constantly evolving game.

WHO ARE WE LOOKING FOR

• Nike Sports Marketing Analytics is looking for a BI engineer to join its team to help support critical business decisions around Seek, Sign, Serve, and Leverage – key pillars to Sports Marketing.
• This role will report to an Insights Manager and work closely with data scientists and other engineers.

WHAT WILL YOU WORK ON

• Ingesting data from APIs and other data sources and loading into Nike’s datalake (AWS).
• Cleaning and transforming large data in warehouse (Databricks).
• Joining datasets and creating reports in BI tool (Tableau).
• Understand KPIs by working closely with Insights Manager.
• Scaling and automating reporting for Geos/Fields of Play via dashboard.
• Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy.
• Documents and communicates database design.
• Evaluates and installs database management systems.
• Codes complex programs and derives logical processes on technical platforms.
• Builds windows, screens and reports.
• Assists in the design of user interface and business application prototypes.
• Participates in quality assurance and develops test application code in client server environment.
• Provides expertise in devising, negotiating and defending the tables and fields provided in the database.
• Adapts business requirements, developed by modeling/development staff and systems engineers, and develops the data, database specifications, and table and element attributes for an application.
• At more experienced levels, helps to develop an understanding of client's original data and storage mechanisms.
• Determines appropriateness of data for storage and optimum storage organization.
• Determines how tables relate to each other and how fields interact within the tables for a relational model.

WHAT YOU BRING

• Strong experience in relational SQL and database analysis
• Strong experience in Tableau and other reporting technologies
• Experience with Cloud Data Stacks (AWS, Snowflake, etc) and associated analytical tools
• Experience in projects that deliver relevant insights / analytics