Report Writer / Data Analyst (Sigma)

Zipdev LLC; United States; À distance; USD 90 000 - 130 000; Plein temps

Avantages offerts par ce poste

Remote work

Vacation: 10 business days a year

Holidays: 5 National Holidays a year

Parental Leave

Health Care Reimbursement

Active Lifestyle Reimbursement

Quarterly Home Office Reimbursement

Payroll Deduction Purchase Plans

Longevity Bonus

Continuous Learning Bonus

Résumé du poste

Zipdev LLC is hiring a data/reporting engineer to create trusted Sigma data models and dashboards. You will transform Snowflake data marts into reusable Sigma models, enabling non-technical teams to self-serve reporting without SQL tickets.

You will build a governed semantic layer, define metrics, and implement data source standards while teaching others. Remote-friendly environment with focus on accurate, scalable reporting for Finance and operations.

Qualifications

• 3+ years building reports and dashboards in a modern BI tool (Sigma preferred).
• Semantic layer design over data models for non-technical users.
• Strong SQL skills: joins, CTEs, window functions, aggregations.

Responsabilités

• Design, build, and maintain reports and dashboards in Sigma for multiple teams.
• Build and own a governed metadata layer in Sigma on top of Snowflake marts.
• Establish data source standards, naming conventions, metrics, and documentation.
• Implement row-level and column-level security in Sigma.
• Enable self-service reporting with templates and starter workbooks.
• Translate stakeholder requirements into metric definitions and dashboards.
• Write and optimize SQL against Snowflake to validate data and prototype reports.
• Collaborate with data engineers on upstream changes and dbt models.
• Monitor report performance and usage to keep the Sigma environment fast.

Connaissances

BI dashboards

Semantic layer

SQL

Dimensional modelling

Finance/ops collaboration

Outils

Sigma

LookML

Power BI

dbt semantic layer

Description du poste

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.

• 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).

• 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!