Report Writer / Data Analyst (Sigma)

Zipdev

United States

Remote

USD 90,000 - 140,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote work
Vacation days: 10 business days a year
Holidays: 5 National Holidays a year
Company Holidays: 14 Company Holidays
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 发展

Job summary

Zipdev is seeking a data reporting specialist to turn Snowflake data marts into trusted Sigma models and self-serve dashboards for Finance, Ops, and leadership. You will design a semantic layer, define metrics, and enforce data governance.

Collaborate with data engineers, enable self-service, and train non-technical users. Remote-friendly startup environment with strong emphasis on clarity, trust in numbers, and scalable analytics across the business.

Qualifications

  • 3+ years building reports in a modern BI tool (Sigma preferred).
  • Built or maintained a semantic layer used by non-technical users.
  • Strong SQL including joins, CTEs, window functions, and aggregations.
  • Familiar with dimensional modeling concepts (facts/dimensions, grain).
  • Experience partnering with Finance/Operations to translate asks into reports.
  • Commitment to trust in numbers through definitions and data source validation.

Responsibilities

  • Design, build, and maintain Sigma reports and dashboards for Finance, Leave Success, Product, RevOps, CS, and leadership.
  • Own a governed Sigma metadata layer atop Snowflake data marts.
  • Set standards for data source certification, naming, metrics, and documentation.
  • Implement row-level and column-level security in Sigma to restrict data access.
  • Enable self-service reporting: training, templates, starter workbooks.
  • Collaborate with data engineers and validate data with SQL against Snowflake.
  • Monitor report performance and usage to keep Sigma fast and tidy.
  • Partner with data engineers on upstream data mart changes and dbt where appropriate.

Skills

BI reporting
Semantic layer
SQL proficiency
Dimensional modeling
Stakeholder collaboration
Mentoring/teaching

Tools

Sigma
Snowflake
dbt

Job description

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!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Sigma BI Report Architect
Remote Sigma BI Report Architect

Zipdev LLC • United States

Remote
USD 90,000 - 130,000
Remote work
Vacation: 10 business days a year
Holidays: 5 National Holidays a year
+7
Report Writer / Data Analyst (Sigma)
Report Writer / Data Analyst (Sigma)

Zipdev • United States

Remote
USD 90,000 - 130,000
Remote work
Vacation: 10 business days a year
Holidays: 5 National Holidays a year
+7
Remote Sigma BI Developer – Self-Serve Dashboards
Remote Sigma BI Developer – Self-Serve Dashboards

Zipdev • United States

Remote
USD 90,000 - 140,000
Remote work
Vacation days: 10 business days a year
Holidays: 5 National Holidays a year
+9
Enterprise Solution Engineer - South East / Mid Atlantic
Enterprise Solution Engineer - South East / Mid Atlantic

Sigma Computing • United States

Remote
USD 120,000 - 190,000
Equity
Flexible time off
Paid bonding time for new parents
+4
Data Engineer
Data Engineer

Sigma Computing • New York (NY)

On-site
USD 140,000 - 180,000
Equity
Flexible time off
Paid bonding time for new parents
+4
Enterprise Solution Engineer (Remote)
Enterprise Solution Engineer (Remote)

Sigma Computing • United States

Remote
USD 120,000 - 150,000
Equity
Generous health benefits
Flexible time off policy
+5
Enterprise Solution Engineer
Enterprise Solution Engineer

Sigma Computing • Boston (MA)

Hybrid
USD 160,000 - 180,000
Equity
Generous health benefits
Flexible time off policy
+5
Data Engineer
Data Engineer

Sigma • New York (NY)

On-site
USD 140,000 - 180,000
Equity
Generous health benefits
Flexible time off policy
+5
Enterprise Solution Engineer - Mid-Atlantic
Enterprise Solution Engineer - Mid-Atlantic

Sigma Computing • United States

Remote
USD 120,000 - 160,000
Equity
Flexible time off
Paid bonding time for new parents
+4
Enterprise Solution Engineer - East
Enterprise Solution Engineer - East

Sigma • Boston (MA)

Remote
USD 160,000 - 180,000
Equity
Generous health benefits
Flexible time off policy