Senior Data Modeler – MAC BI, Activity Intelligence
nike · Beaverton
Job description
About the role
Nike's MAC BI team owns the data pipelines, reporting platforms and AI-powered insights behind its marketing spend, competitive understanding and athlete coaching. This Senior Data Modeler role reports to the Director of Marketing BI and owns the logical and physical data architecture for the Activity domain, turning wearable device streams and coaching data into a unified athlete profile that feeds the AI Coaching Engine.
Key responsibilities
- Design the unified athlete profile model that harmonizes wearable device streams (heart rate, pace, cadence, sleep, HRV, VO2max, recovery) from multiple vendors into a single, query-optimized schema on Databricks/Sole.
- Model the coaching intelligence data layer, linking structured inputs (goals, baselines, injury history) with unstructured coaching data (notes, feedback, RPE).
- Translate Nike Sport Research Lab sport science constructs into production data structures for coaching algorithms.
- Own the bronze/silver/gold medallion layer design for the Activity domain within the MAC BI pipeline template.
- Produce source-to-target mappings for all Activity data sources, resolve multi-vendor schema conflicts and define data contracts, API schemas, refresh cadences and versioning.
- Model race and sport experience data, including training plans, race-specific schemas and in-race coaching signals.
- Define data quality rules (Spark Expectations, referential integrity, business rules) and establish the Activity data dictionary and catalog.
- Own schema evolution strategy and partner with analysts to validate that models support efficient dashboards and ad-hoc analysis.
Required profile
- Bachelor's degree in computer science, data science, data analytics or a related field; any suitable combination of education, experience or training accepted.
- 5+ years of data modeling experience across analytical and operational systems, with significant experience on large-scale platforms (Databricks, Snowflake, BigQuery or equivalent).
- Deep expertise in dimensional modeling, Data Vault or medallion architectures, with justified trade-offs between star schemas, wide tables and normalized structures.
- Experience harmonizing multi-source data from vendors with different schemas and producing source-to-target mappings.
- Strong collaboration with both engineering and analytics teams.
Required skills
- Advanced SQL and data profiling.
- Preferred: IoT, wearable or sensor data modeling and health, fitness or sport science data.
- Preferred: Databricks/Spark physical design (Delta Lake partitioning, Z-ordering, liquid clustering).
- Preferred: schema evolution, async collaboration across time zones, and data privacy modeling for health/fitness data.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in the United States.
Salaries by job title
- Delivery Specialist 330
- Line Cook 264
- Restaurant Host 251
- Dishwasher 241
- Shift Supervisor 226
- Parts Specialist 208
- Retail Service Specialist 176
- Server - Red Robin 140
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 19 hours ago
Expires 1 month from now
5 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
nike
Beaverton
Related job offers
-
Software Engineer Manager - Merchandising
nike Beaverton -
Software Engineer - Advanced Analytics & Machine Learning
nike Beaverton -
Principal Technical Product Manager - Design Tools
nike Beaverton -
Client Success Manager (Remote, Central US Hours)
Town Web Design -
NetSuite Developer
BillingPlatform Belgrade