Report Writer / Data Analyst (Sigma)
New
Z
ZipdevBusiness intelligence
Mexico. Colombia. BrazilFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 3+ years of experience building reports and dashboards in a modern BI tool
- Required Skills
- SQLSnowflakedbt
Requirements
- Have 3+ years of experience building reports and dashboards in a modern BI tool; Sigma is strongly preferred, with Looker, Tableau, Power BI, or similar considered.
- Have built or maintained a semantic layer, such as Sigma data models, LookML, Power BI datasets, or a dbt semantic layer.
- Write strong SQL, including joins, CTEs, window functions, and aggregations, and know how to avoid double counting.
- Understand dimensional modeling concepts, including grain, facts and dimensions, and slowly changing dimensions.
- Be able to work with Finance or Operations stakeholders to understand reporting needs and design useful reports.
- Document metric definitions, validate results against source systems, and communicate discrepancies clearly.
- Be able to teach and explain data concepts to non-technical users.
- Have experience working with a startup and/or a B2B SaaS business.
- Nice to have: experience with Snowflake and dbt.
- Nice to have: financial reporting experience, such as revenue, billing, or ARR, or operational SLA reporting.
- Nice to have: familiarity with HR, benefits, insurance, or leave management data.
- Nice to have: experience preparing data for AI-assisted analytics, including descriptions and metric definitions.
Responsibilities
- Design, build, and maintain Sigma reports and dashboards for Finance, Leave Success, Product, RevOps, CS, and leadership.
- Build and own a governed Sigma semantic layer, including relationships, reusable metrics, calculated columns, and business-friendly names and descriptions.
- Establish standards for certified data sources, naming conventions, metric definitions, and documentation.
- Implement and maintain row-level and column-level security in Sigma.
- Train and support non-technical users, create templates and starter workbooks, and maintain a guide to available reporting.
- Gather reporting requirements, translate stakeholder questions into metric definitions, and explain trade-offs.
- Write and optimize SQL against Snowflake to validate data, prototype reports, and diagnose discrepancies.
- Partner with data engineers on data mart changes, data quality issues, and new data needs, and contribute to dbt models where appropriate.
- Monitor report performance and usage, including materialization and cleanup of unused workbooks.
View Full Description & ApplyYou'll be redirected to the employer's site
