Report Writer / Data Analyst (Sigma)
Zipdev · Remote
Engineering has built modeled data marts in Snowflake that support Finance, Leave Success, and other teams. Your job is to turn those data marts into trusted, reusable Sigma data models and reports, so that teams outside of engineering can build and explore their own reporting without filing a ticket or writing SQL.
Responsibilities will include:
- Designing, building, and maintaining reports and dashboards in Sigma for Finance, Leave Success, Product, RevOps, CS, and leadership.
- Building and owning a governed metadata (semantic) layer in Sigma using data models: defining relationships, reusable metrics, calculated columns, and clear business-friendly names and descriptions on top of our Snowflake data marts.
- Establishing standards for certified data sources, naming conventions, metric definitions, and documentation so everyone is working from one version of the truth.
- Implementing and maintaining row-level and column-level security in Sigma (for example, user attributes and teams) so people only see the data they should.
- Enabling self-service reporting: training and supporting non-technical users, creating templates and starter workbooks, and maintaining a simple guide for "where to find what."
- Gathering reporting requirements from stakeholders, translating vague questions into clear metric definitions, and pushing back with trade-offs when needed.
- Writing and optimizing SQL against Snowflake to validate data, prototype new reports, and diagnose discrepancies.
- Partnering with data engineers on upstream data mart changes, data quality issues, and new data needs, and contributing to dbt models where it makes sense.
- Monitoring report performance and usage (for example, materialization and cleanup of unused workbooks) to keep the Sigma environment fast and tidy.
Requirements
- You have 3+ years of experience building reports and dashboards in a modern BI tool (Sigma strongly preferred; Looker, Tableau, Power BI, or similar also considered).
- You have built or maintained a semantic layer (Sigma data models, LookML, Power BI datasets, dbt semantic layer, or similar) that non-technical users rely on.
- You write strong SQL, including joins, CTEs, window functions, and aggregations, and you know how to avoid double counting.
- You understand dimensional modeling concepts such as grain, facts and dimensions, and slowly changing dimensions.
- You can sit with a Finance or Operations partner, understand what they are really asking, and design a report that answers it.
- You care about trust in the numbers: you document definitions, validate against source systems, and communicate clearly when something is off.
- You enjoy teaching others and can explain data concepts to people who do not work with data every day.
- You have high levels of empathy and can connect deeply with our mission.
- You are comfortable working in ambiguous environments and know that we need your help to figure things out.
- You have experience working with a startup and/or with a B2B SaaS business.
Nice to have:
- Experience with Snowflake and dbt.
- Experience with financial reporting (revenue, billing, ARR) or operational SLA reporting.
- Familiarity with HR, benefits, insurance, or leave management data.
- Experience preparing data for AI-assisted analytics (for example, writing descriptions and metric definitions that tools like Sigma Assistant can use).
Benefits
- Work remotely
- Vacation: 10 business days a year
- Holidays: 5 National Holidays a year
- Company Holidays: 14 Company Holidays a year
- Parental Leave
- Health Care Reimbursement
- Active Lifestyle Reimbursement
- Quarterly Home Office Reimbursement
- Payroll Deduction Purchase Plans
- Longevity Bonus
- Continuous Learning Bonus
- Access to Training and Professional Development Platforms
- Did we mention it's REMOTE?!!
One of our core values at Zipdev is "Be authentic." that's why we encourage you to answer the application form in your own words; we are interested in getting to know you, not a digital assistant.
Wondering how our remote environment or our payment method work? We've put together some helpful answers in our FAQs at the bottom our our career site. Take a look and let us know if you have any other questions!