Join a team focused on analytics enablement—designing analytics-ready data models and a trusted semantic layer that standardizes business metrics. You will partner with stakeholders to translate requirements into well-modeled datasets in Databricks and Snowflake, using SQL as your primary language and Python when needed. You will define consistent metrics and semantic conventions that enable scalable self-service reporting. You will help create a data ecosystem where consumers trust and reuse what has been built.
As an Analytics Solutions Associate within Analytics Engineering, you will build analytics-ready data models and a trusted semantic layer that standardizes business metrics. You will partner with stakeholders to translate requirements into governed, reusable datasets and semantic definitions. You will own the structure and usability of downstream analytics by defining grains, dimensions, facts, conformed entities, and metric logic so teams can move faster with confidence.
Responsibilities
- Lead development of analytics data models (dimensional and/or domain-oriented) optimized for reporting, business intelligence, and self-service consumption.
- Design and maintain a semantic layer (standardized metrics, dimensions, entities, and business definitions) to ensure consistency across dashboards and analyses.
- Translate stakeholder requirements into clear modeling deliverables (entities, grains, metric definitions, acceptance criteria).
- Build transformations primarily in SQL, leveraging Python when needed for complex logic, automation, or validation.
- Implement and champion data quality controls (tests, reconciliations, anomaly checks) tied to business-critical metrics.
- Optimize model performance in Snowflake and/or Databricks (efficient joins, partitioning and clustering strategies where applicable, cost/performance trade-offs).
- Collaborate with upstream teams on source system understanding (including semi-structured data and non-relational sources) and ensure analytics models reflect correct business meaning.
- Establish modeling standards: naming conventions, documentation, lineage, metric governance, and change management for semantic definitions.
- Support enablement by documenting curated datasets, creating user guidance, and helping consumers adopt the semantic layer correctly.
Qualifications
- Master’s degree in Information Technology, Computer Science, Management Information Systems, Operations Research or related field of study plus 3 years of experience in the job offered or as Analytics Engineer or related occupation; OR Bachelor’s degree plus 5 years of experience.
- Advanced SQL skills (complex joins, performance tuning, incremental logic).
- Strong understanding of data modeling (facts and dimensions, grains, conformed dimensions, slowly changing dimensions, metric design).
- Demonstrated experience building or operating a semantic layer or metrics framework.
- Comfort working with semi-structured data (JSON) and non-relational sources.
- Exposure to data governance concepts (role-based access control, data classification, lineage, audit requirements).
- Working experience with Snowflake and/or Databricks.
- Practical Python skills for data workflows (validation, automation, notebooks and scripts).
- Ability to partner with stakeholders, clarify ambiguous requirements, and drive to measurable outcomes.
- Strong documentation habits and attention to data correctness.
Education
Master’s degree in IT, CS, MIS, Operations Research plus 3 years exp OR Bachelor’s degree plus 5 years exp.
Skills
Business Intelligence, Data Governance, Data Modeling, Databricks, ETL, Python, SQL, Snowflake, Semantic Layer
Experience
3+ years