You will serve as the critical bridge between data engineering and business logic. Your mission is to transform raw data into trusted, automated, and reusable enterprise KPIs. You'll partner with stakeholders to design semantic layers and dimensional models that eliminate manual reporting and provide a "single source of truth" for performance insights across the organization.
Key Responsibilities
KPI Design & Strategy: Lead the definition and standardization of enterprise-level KPIs. Translate complex business objectives into clear metric logic and scalable dimensional models.
Data Stewardship: Ensure all performance measures are traceable to authoritative data sources. Maintain high standards for data governance, ensuring metrics are consistent, documented, and trusted.
Pipeline Collaboration: Partner with Data Engineering to shape transformation logic and build "analytics-ready" datasets. Focus on developing standardized semantic layers to support self-service analytics.
Automation & Optimization: Identify opportunities to replace manual reporting with automated measurement capabilities. Continuously evaluate the analytics roadmap to recommend the enhancement or retirement of existing metrics.
Best Practices: Act as the Subject Matter Expert (SME) for analytics engineering. Promote the reuse of data assets and analytical patterns to reduce technical debt and redundancy.
Qualifications
Bridging the Gap: Proven ability to communicate technical data concepts to business partners and translate business needs into technical requirements.
Technical Expertise: Strong experience in SQL, data modeling (Kimball/Star Schema), and working within modern data stacks (e.g., dbt, Snowflake, BigQuery).
Metric Governance: Experience defining and managing "Metric Stores" or semantic layers to ensure cross-functional consistency.
Analytical Mindset: Deep understanding of how to build automated, scalable measurement frameworks that drive business decisions.
Collaborative Spirit: Comfortable working across functional silos to drive alignment on data definitions and analytics best practices.
Equal Opportunity Employer / Disabled / Protected Veterans
The Know Your Rights poster is available here:
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf
The pay transparency policy is available here:
https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf
For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.
We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.
AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.
https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf
We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Additional Skills
(none specified)
AllSTEM Representative Contact Info
Account Executive:
Nichols
Branch Phone:
(909) 244-1777
Location:
Ontario, CA