Ellevation Education is seeking to support critical data infrastructure and reporting needs as part of their business intelligence modernization, specifically with Snowflake schema design, operational data transformation, and system integration.
Requirements
- 6+ years of experience in data engineering or analytics engineering, with a focus on BI-ready data modeling.
- Deep expertise in Snowflake, dbt, and SQL, with a strong understanding of dimensional modeling and operational reporting.
- Proven experience building automated snapshot pipelines, normalizing inconsistent data structures, and managing system syncs.
- Familiarity with Salesforce data structures and experience embedding reporting into Salesforce environments.
- Bonus: experience replacing or sunsetting legacy BI systems (e.g., Sisense, Looker).
- Strong understanding of dimensional modeling and operational reporting.
- Experience with data transformation and system integration.
Responsibilities
- Design and implement a foundational star schema for operational data to support cross-functional reporting.
- Automate a currently manual invoicing refresh process, normalizing unstructured data and delivering reliable daily output.
- Build and document historical snapshot tables for business-critical processes, including: Opportunity pipeline snapshots and Customer onboarding & training progression
- Design and implement Snowflake-based sync pipelines, replacing legacy Sisense syncs to improve reliability and performance.
- Work with the BI and Product Analytics teams to document and transfer ownership of newly built sync processes.
- Investigate and resolve data sync issues across systems with field parity requirements (e.g., Salesforce, Gainsight, Snowflake).
- Build snapshot logic, standardizing data sync pipelines, and helping transition the business away from Sisense toward Snowflake and Tableau.
Other
- Passionate about growth and eager to learn.
- Drive to excel and make a difference.
- Values diversity, creativity, and a hunger for new perspectives.
- Ability to work in a fast-paced environment and adapt to changing priorities.
- Excellent communication and collaboration skills.
