Report Writer, Data Analyst

This is a fully remote position, open to applicants in Mexico, +2 more countries.

📋 Description

• Design, develop, and maintain Sigma reports and dashboards for Finance, Leave Success, Product, RevOps, CS, and leadership teams.

• Create and manage a governed metadata (semantic) layer in Sigma utilizing data models.

• Define relationships, reusable metrics, calculated columns, and user-friendly names and descriptions on Snowflake data marts.

• Establish standards for certified data sources, naming conventions, metric definitions, and documentation.

• Implement and oversee row-level and column-level security measures in Sigma.

• Facilitate self-service reporting by providing training, support, templates, starter workbooks, and guidance.

• Collect reporting requirements and convert vague inquiries into precise metric definitions.

• Write and enhance SQL queries against Snowflake to validate data, prototype reports, and investigate discrepancies.

• Collaborate with data engineers on data mart modifications, data quality challenges, and emerging data requirements.

• Contribute to dbt models as needed.

• Monitor report performance and usage, including the materialization and cleanup of inactive workbooks.

⛳️ Requirements

• Over 3 years of experience in building reports and dashboards using a modern BI tool (Sigma preferred; Looker, Tableau, Power BI, or similar will also be considered).

• Experience in creating or maintaining a semantic layer (Sigma data models, LookML, Power BI datasets, dbt semantic layer, or similar).

• Proficient in SQL, including joins, CTEs, window functions, and aggregations, with an understanding of how to prevent double counting.

• Knowledge of dimensional modeling concepts such as grain, facts and dimensions, and slowly changing dimensions.

• Ability to comprehend Finance or Operations reporting needs and design suitable reports.

• Capability to document definitions, validate against source systems, and communicate data discrepancies effectively.

• Skill in teaching and explaining data concepts to non-technical users.

• High levels of empathy and the ability to connect deeply with the organization's mission.

• Comfort in navigating ambiguous environments.

• Experience in a startup and/or B2B SaaS environment.

• Familiarity with Snowflake and dbt is a plus.

• Experience in financial reporting or operational SLA reporting is a plus.

• Knowledge of HR, benefits, insurance, or leave management data is a plus.

• Experience in preparing data for AI-assisted analytics is a plus.

🏝️ Benefits

• Work remotely.

• Vacation: 10 business days per year.

• Holidays: 5 National Holidays annually.

• Company Holidays: 14 Company Holidays each 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.