Back to the job description
Sigma Reporting Lead
Remote, Chicago, IL
Resume/CV
*
Attach
Please fix the following errors:
Do you have valid work authorization to work in the United States?
Yes
No
This location demands you to work from Chicago/Remote. Are you fine with that?
Yes
No
Describe the most complex Sigma workbook you have personally built — not contributed to, but owned. What was the business use case, how did you structure the data elements and controls, and what was the hardest Sigma-specific limitation you hit and how did you work around it?
Walk me through how you implemented row-level security in Sigma for a multi-tenant or role-based reporting use case. How did you pass user attributes into the security filter, where did the access logic live — in Sigma, the warehouse, or both — and what broke when you tested it with edge-case users?
A Sigma dashboard is timing out for executives on Monday mornings when the Snowflake warehouse is under peak load. Walk me through your diagnostic process and the specific changes you would make — in SQL, the data model, or Sigma itself — to fix it sustainably.
Describe a dimensional model you designed for a reporting layer on top of Snowflake, BigQuery, or Databricks. How did you structure facts and dimensions, how did you handle slowly changing dimensions, and how did you ensure business users got consistent metric definitions across different dashboards?
Tell me about a time a business stakeholder told you exactly what report they wanted — and you pushed back. What did they ask for, why was it wrong or insufficient, how did you redirect them, and did the report you actually built get used?
Apply
We use cookies to offer you our service. By continuing to use this site, you consent to our use of cookies as described in our
policy