Data Architect
This is the employer's own posting, not a copy on a job board.
What we know
Is it still open?
Confirmed still open
Last checked just now — checked against the employer's own applicant tracking system, which is the company answering directly.
We re-read the employer's own applicant tracking system and the posting was still there. That is the company answering directly.
How old is it?
Posted 1h ago
The date the source published, not the day we noticed it (2026-11-17). Last seen at its source just now.
Is it remote?
Remote
That is the location the employer filed this posting under. Quoted as written — we do not re-word the source's own location.
Who may apply?
Not stated
The description states no restriction of its own. This is the source's own tag.
Skills named in the ad
Recognised terms only, from a fixed vocabulary — this is what CV matching compares against.
Carried by 1 source
-
Greenhouse employer's own board first seen just now · last seen just now
The listing
We are seeking a Data Architect to connect our core business processes, operational systems, and data in a trusted enterprise architecture. This hands-on, build-first leadership role will map key business processes, define systems of record and shared data definitions, and determine how information flows across the company. The successful candidate will lead and contribute directly to rebuilding RCX’s BigQuery platform and developing the pipelines, integrations, data models, quality standards, and governance that support it.
The work spans Salesforce, BigQuery, Tableau, League Central and SMA application databases, Heroku Connect, SKU Vault, and a commerce platform being replaced. RCX’s Analytics team owns reporting, visualization, and analysis; this role owns the underlying architecture and data foundation that enable that work.
Initially a player/coach role, this position calls for someone equally comfortable building a pipeline or troubleshooting an integration and working with executives to shape business processes.
Job Responsibilities:
- Business Process & Systems Architecture
-
Map RCX's highest-priority business processes from beginning to end.
-
Understand the people, activities, decisions, systems, handoffs, and data involved in each process.
-
Identify manual work, disconnected systems, duplicated data, inconsistent definitions, and opportunities for simplification or automation.
-
Define which applications should support key processes and which systems should serve as systems of record.
-
Translate business requirements into clear systems, integration, and data architecture.
-
Ensure new technology decisions fit within a coherent architecture rather than creating additional silos.
-
- Enterprise Data Architecture
-
Define RCX's core business entities and the relationships between them.
-
Establish common definitions for critical data and business metrics across systems and departments.
-
Reconcile conflicting representations of customers, organizations, leagues, participants, registrations, transactions, partners, products, locations, and other core entities.
-
Establish authoritative sources and ownership for important data domains.
-
Design conceptual, logical, and physical data models that support operations, analytics, forecasting, automation, AI, and future data products.
-
Partner with Engineering on application structures that shape enterprise data, such as account hierarchies and the market, program, and catalog model. Own enterprise entity definitions, systems of record, and data flows; Engineering owns application design and keeps Data Architecture informed of changes that affect downstream data.
-
- BigQuery Data Platform
-
Assess and redesign RCX's existing BigQuery implementation into a scalable, governed enterprise data platform.
-
Personally contribute to the architecture and implementation of the new environment.
-
Design appropriate source/raw, transformation, core model, and analytics-ready layers.
-
Build sophisticated SQL transformations and data models.
-
Establish appropriate partitioning, clustering, incremental processing, security, and access-control patterns.
-
Optimize the environment for reliability, performance, scalability, and cost.
-
Establish development, testing, deployment, and monitoring practices for the data platform.
-
- Data Pipelines & Integrations
-
Architect and build pipelines connecting Salesforce and other operational systems to BigQuery.
-
Develop integrations using APIs, databases, files, and other appropriate mechanisms.
-
Build batch, incremental, and change-data-capture processes where appropriate.
-
Use Python or similar technologies for custom ingestion, transformation, validation, and automation.
-
Implement orchestration, testing, monitoring, alerting, and failure recovery.
-
Define where data should flow back into Salesforce or other operational systems when business processes require synchronization or write-back.
-
Resolve discrepancies when multiple systems contain different versions of the same business information.
-
Architect ingestion of operator and participant data from third-party registration platforms, including matching participants across platforms RCX does not control.
-
Own the architecture for data shared with league and licensing partners: what is shared, in what format, and under what consent.
-
- Data Quality & Governance
-
Establish practical standards for data ownership, quality, access, lineage, documentation, security, and change management.
-
Implement automated testing and validation for critical data.
-
Create monitoring for failed pipelines, schema changes, freshness issues, and anomalies.
-
Establish clear documentation and metadata practices.
-
Own the technical controls for participant PII, much of it belonging to minors: access, consent, retention, and keeping production data out of non-production environments. Work within policy set by Security.
-
- Analytics Enablement
-
Partner closely with the Analytics team to provide reliable, well-structured, analysis-ready data with Data Architecture owning the underlying data platform and Analytics focused on reporting, analysis, visualization, and business insight.
-
Create curated data models and marts that support Tableau and other downstream analytical uses.
-
Establish consistent dimensions, metrics, and business definitions.
-
Reduce the manual work required to find, clean, combine, and reconcile data.
-
- AI & Automation Enablement
-
Design the data platform so AI applications and agents can securely access trusted, governed data.
-
Identify opportunities to use AI and automation to reduce manual work and improve business processes.
-
Explore AI-assisted approaches to data mapping, documentation, testing, quality monitoring, anomaly detection, and development productivity.
-
Partner with Engineering on the architecture required for AI applications to safely interact with RCX systems and data. AI should build on the data foundation rather than operate as a separate architecture.
-
Minimum Qualifications:
- Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or a related field.
- 10+ years of progressive experience in data engineering, data architecture, or closely related roles.
- Experience operating at a lead, principal, architect, or technical leadership level.
- Demonstrated experience personally designing and implementing production cloud data platforms.
- Hands-on BigQuery experience.
- Expert SQL skills.
- Strong working proficiency with Python for data engineering and integrations.
- Deep knowledge of enterprise and dimensional data modeling.
- Experience with ETL/ELT, APIs, incremental ingestion, CDC, synchronization, orchestration, testing, and observability.
- Experience with dbt, Dataform, or similar transformation approaches.
- Experience with Airflow, Composer, Dagster, Prefect, or similar orchestration technologies.
- Strong understanding of GCP architecture, IAM, service accounts, storage, and related services.
- Experience integrating Salesforce with enterprise data platforms.
- Understanding of Salesforce objects, APIs, synchronization, CDC, and write-back patterns.
- Experience supporting Tableau or comparable BI environments.
- Strong understanding of data quality, lineage, governance, metadata, privacy, and security.
- Experience handling regulated personal data, ideally including data about minors.
- Demonstrated ability to map business processes and translate them into systems and data architecture.
Additional Position Details:
- Travel: Up to 5%
- Work Schedule: Full-Time 40 hours/week (Monday-Friday) with occasional nights and weekends
- Compensation Structure: Exempt paid Semi-Monthly. This position is eligible for an annual discretionary bonus & benefits including: Medical, Dental, Vision, Life Insurance, Disability, 401(k), Paid Parental Leave, Unlimited PTO, Monthly Wellness Expense Reimbursement and additional voluntary benefits.
- Location: Remote
- Reports to: Vice President of Program Strategy & Experience
- Supervisory Responsibilities: None
- Stay Healthy: Enroll in comprehensive benefits & insurance plans with no waiting period
- Be Well: Expense up to $65 per month for health & wellness
- Maximize Savings: Contribute to your 401k retirement savings with company matching
- Be Comfortable: Enjoy a relaxed casual dress code
- Take Time: Enjoy a variety of time off benefits including Unlimited PTO and paid Parental Leave
- Stay Connected: Work equipment (laptop and monitor) provided by RCX Sports plus, expense up to $350 towards the purchase of a personal use laptop, tablet, or computer