Bloomerang is looking to build a centralized, trusted, and scalable data foundation to drive forecasting, reporting, and data-informed strategic decisions across the business.
Requirements
- 4+ years of experience in analytics engineering, BI development, or data analysis, with strong SQL expertise.
- Proven ability to model and transform data in modern cloud warehouses (BigQuery, Snowflake, Redshift).
- Familiarity with ELT pipelines (Fivetran, Stitch, Airbyte) and orchestration / version control tools (Git, dbt Cloud, etc.).
- Experience implementing or working with a semantic layer (dbt Metrics, Cube, Looker, Transform, etc.).
- Strong business acumen, ideally with experience in SaaS metrics, finance, or revenue operations – and an understanding of how data drives strategic decisions.
- Bonus points for experience with Finance data workflows, defining or governing enterprise metrics dictionaries, and curiosity about AI-driven analytics and natural language querying.
Responsibilities
- Build and own core data models in BigQuery using Dataform (Fivetran BigQuery Dataform stack) to create single sources of truth for customers, revenue, subscriptions, pipeline and usage.
- Define and document key business metrics (ARR, retention, CAC, etc.) in a consistent, governed semantic layer.
- Partner with Finance and cross-functional teams to reconcile financial and operational metrics across systems like NetSuite, Salesforce, Pendo.
- Ensure data quality and reliability by writing clean, efficient SQL and implementing testing, version control, and documentation standards.
- Enable self-serve analytics by building reusable data assets and empowering teams to access trusted datasets without reinventing logic.
- Contribute towards the buildout of AI and advanced analytics, ensuring data is structured, documented, and accessible for future use cases.
- Establish scalable data modeling standards, including naming conventions, lineage documentation, and metric governance.
Other
- Highly organized and capable of managing multiple priorities while maintaining precision and clarity.
- Collaborative, curious, and comfortable working in a fast-paced, remote-first environment.
- A strong sense of ownership and craftsmanship – you build scalable systems designed for others to use and trust.
- Exceptional communication and storytelling skills – able to translate between business logic and data design, influence senior stakeholders, and present insights clearly.
- 4-year degree or equivalent experience
