Senior Business Intelligence Developer

About the Company We are seeking a highly experienced Senior BI Developer with deep expertise in Sigma Computing to design and scale a modern, self-service analytics environment. This role is critical in transforming large scale cloud data assets into actionable, real time insights that drive strategic and operational decision making. About the Role As our digital infrastructure footprint expands globally, you will serve as the lead architect for Sigma across the organization. You will design enterprise grade data models, optimize performance for high volume datasets, and enable business stakeholders to independently explore trusted data without compromising governance or performance. This is not a dashboard builder role. We are looking for a data strategist who understands data architecture, warehouse performance, and business context, and who can build a scalable BI ecosystem. Responsibilities Sigma Architecture and Development • Design, develop, and maintain advanced Sigma Workbooks, Datasets, and Data Models. • Architect scalable reporting frameworks using Sigma’s spreadsheet style interface. • Implement reusable components, parameter driven logic, calculated fields, and advanced joins. • Develop structured semantic layers within Sigma to ensure consistency across all reporting assets. • Establish best practices for workbook design, naming conventions, folder structures, and governance. Enterprise Data Modeling • Collaborate closely with Data Engineering teams to design and refine dimensional and fact based data models. • Build and maintain curated “Golden Datasets” that serve as the single source of truth across departments. • Validate metric definitions and enforce standard KPI calculations across all analytics assets. • Ensure compatibility between Sigma and underlying data platforms such as Snowflake and Databricks. Cloud Data Warehouse Optimization • Optimize complex SQL queries using CTEs, window functions, aggregations, and partitioning strategies. • Monitor query performance and reduce compute costs through warehouse tuning and materialization strategies. • Leverage Sigma materializations and caching effectively for large scale datasets containing millions of rows. • Work with engineering teams to improve indexing, clustering, and storage optimization strategies. Operational Write Back and Planning Enablement • Implement and manage Sigma Input Tables and write back functionality. • Enable business teams to update operational data such as project timelines, budget forecasts, and capacity planning metrics directly within Sigma. • Ensure secure role based access controls for write back workflows. • Maintain data integrity and auditability for all user generated inputs. Business Enablement and Self Service Analytics • Conduct workshops and training sessions for department leaders and operations teams. • Create documentation and usage guides to drive adoption of Sigma explore features. • Promote a governed self service model where business users can analyze data independently while maintaining centralized control. • Act as a strategic advisor to stakeholders, translating business questions into scalable data solutions. Governance and Security • Implement row level security and access control policies. • Ensure compliance with internal data governance standards. • Monitor usage analytics and recommend improvements to data accessibility and performance. Qualifications Required Qualifications Sigma Expertise • 2 to 3+ years of hands on experience working extensively with Sigma Computing. • Advanced knowledge of Sigma formulas, join logic, parameters, input tables, and materialization. • Proven experience building enterprise level workbooks and governed datasets. • Advanced SQL Skills • Strong proficiency in complex SQL including CTEs, window functions, subqueries, and performance tuning. • Experience optimizing queries in large scale cloud data warehouse environments. • Ability to analyze execution plans and improve query efficiency. Data Warehousing Experience • Direct experience with Snowflake, Databricks, or Google BigQuery. • Strong understanding of dimensional modeling, star schemas, and fact table design. • Experience working with multi terabyte datasets in production environments. Data Modeling and Transformation Tools • Hands on experience with dbt for data transformation and modeling. • Understanding of version control, CI/CD processes, and deployment workflows in analytics environments. • Familiarity with ELT based architectures. Preferred Qualifications • Prior experience in Data Center operations, Construction technology, Infrastructure analytics, or Real Estate technology environments. • Understanding of metrics such as Power Usage Effectiveness (PUE), Megawatt capacity planning, SLA tracking, and cooling efficiency metrics. • Experience working in high growth infrastructure or energy intensive industries. • Ability to collaborate with Denver based teams when required. Equal Opportunity Employer Statement We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.